column "tgisconstraint" does not exist

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
ccampbell
Posts: 29
Joined: Tue 01 Jun 2010 17:31
Location: Oregon

column "tgisconstraint" does not exist

Post by ccampbell » Mon 03 Jan 2011 17:46

Using PostgreSQL 9.0.2-1
Devart.data = 5.0.143.0
Devart.data.PostgreSql = 4.95.190.0
vb.net 2010

Seems to me I saw a thread that said this was fixed. Howsever, I just downloaded the latest version (at least I think it's the latest version) and I'm still getting this error when I try to do the following:

Code: Select all

 pgDump.Mode = Devart.Common.DumpMode.All
 pgDump.Backup()
I know it has to do with changes to the 9.0 version of PostgreSQL, but again, I thought this was fixed.

Thanks for your help!

Chris

StanislavK
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Post by StanislavK » Tue 04 Jan 2011 16:58

The latest dotConnect for PostgreSQL version is 5.0.69. Please contact our Sales department ( sales * devart * com ) to get the new credentials for downloading this version.

If the problem can be reproduced with the latest version, please specify the definition of the database object with which the issue occurs.

ccampbell
Posts: 29
Joined: Tue 01 Jun 2010 17:31
Location: Oregon

column "tgisconstraint" does not exist

Post by ccampbell » Fri 07 Jan 2011 15:36

(Using vb.net 2010 / Postgres 9.0.2-1)
I upgraded to the following version:
devart.data 5.0.170.0
devart.data.postgresql 5.0.69.0

I'm still receiving the error "column "tgisconstraint" does not exist" when I attempt to perform a database dump. I'm told Postgres 9.0.2-1 no longer includes this column in it's catelog, yet your backup routine is apparently still referencing it?

Here is my code:

Code: Select all

 Dim pgDump As PgSqlDump = New PgSqlDump
        pgDump.Connection = GetDatabaseConnectionPG(blnBailApp, False)
        pgDump.ObjectTypes = PgSqlDumpObjects.Schemas + PgSqlDumpObjects.Tables + PgSqlDumpObjects.Indexes + PgSqlDumpObjects.StoredProcs + PgSqlDumpObjects.Views + PgSqlDumpObjects.Triggers + PgSqlDumpObjects.Sequences + PgSqlDumpObjects.Constraints

        pgDump.Schema = ""
        pgDump.Tables = ""
        pgDump.IncludeDrop = False
        pgDump.Mode = Devart.Common.DumpMode.All
        pgDump.Backup()  <-- Error occurs on this line

The above code works fine using Postgres 8.4.5

If it helps, I initially created the database / schema / tables / indexes / views / etc. through the devart data connection. I am also able to go into pgAdmin III and manually perform a backup with no errors.

Thanks.

StanislavK
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Post by StanislavK » Mon 10 Jan 2011 17:05

Thank you for your assistance, we have reproduced the problem. We will investigate it and inform you about the results as soon as possible.

StanislavK
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Post by StanislavK » Fri 21 Jan 2011 16:45

We have fixed the problem with dumping PostgreSQL databases of version 9. We plan to release the build containing this fix in about a week, we will inform you when it is available.

StanislavK
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Post by StanislavK » Thu 27 Jan 2011 18:06

We have released the new 5.10.96 version of dotConnect for PostgreSQL. The new build can be downloaded from
http://www.devart.com/dotconnect/postgr ... nload.html
(the trial version) or from Registered Users' Area (for users with active subscription only):
http://secure.devart.com/

For the detailed information about the fixes and improvements available in dotConnect for Oracle 6.10.96, please refer to
http://www.devart.com/forums/viewtopic.php?t=20122

Post Reply