column "tgisconstraint" does not exist

ccampbell · 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 · 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 · 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 · 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 · 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 · 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