Failed to add relation(s).

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
manisys
Posts: 2
Joined: Tue 09 Jan 2007 21:43

Failed to add relation(s).

Post by manisys » Tue 09 Jan 2007 21:54

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

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Wed 10 Jan 2007 07:14

We are investigating this problem.
Look forward to the next build.

manisys
Posts: 2
Joined: Tue 09 Jan 2007 21:43

Post by manisys » Wed 10 Jan 2007 22:18

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

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 12 Jan 2007 07:59

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.

Post Reply