column "tgisconstraint" does not exist

column "tgisconstraint" does not exist

Postby 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
ccampbell
 
Posts: 29
Joined: Tue 01 Jun 2010 17:31
Location: Oregon

Postby 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.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

column "tgisconstraint" does not exist

Postby 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.
ccampbell
 
Posts: 29
Joined: Tue 01 Jun 2010 17:31
Location: Oregon

Postby 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

Postby 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

Postby 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/postgresql/download.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
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48


Return to dotConnect for PostgreSQL