Page 1 of 1

Failed to add relation(s).

Posted: Tue 09 Jan 2007 21:54
by manisys
OS: Windows XP
Compiler: Visual Studio 2005 SP2 / c#
Driver: PostgresqlDirect Version 2.55.23.0

I am trying attach a new dataSet with two tables using the "Add Project Data Source" wizard.

I drop a DataGrid onto a blank form. Then I attach a new dataSet with two tables using the "Add Project Data Source" wizard.
I am using the test database that is provided in the Samples code.
I add the "dept" and the "emp" table together in the Wizard and then get the error .

I get an error saying:
"Failed to add relation(s)."
"Column 'Index' does not belong to table IndexColumns"

I researched this a little on google and learned the the IndexColumns table is related to the GetSchema() command return values for "IndexColumns".

I can perform the operation if I use an Access (OLEDB) or SQL Server just not with Postgresql and the PostgresqlDirect driver.

Please let me know how to either get around this or when it will be resolved.

Thank you.

James

Posted: Wed 10 Jan 2007 07:14
by Alexey
We are investigating this problem.
Look forward to the next build.

Posted: Wed 10 Jan 2007 22:18
by manisys
I installed the Beta 3.0 version and the problem has been resolved.

Thank you.

Do you know when the Beta version will be released? I am under pressure to get a project out the door.

James

Posted: Fri 12 Jan 2007 07:59
by Alexey
PostgreSQLDirect .NET 3.0 is going to be released in a month.
The issue with relations is also fixed in PostgreSQLDirect .NET 2.55.24 which is coming out in two weeks.