Thread: Dump Error Message

Dump Error Message

From
"Bob Pawley"
Date:
Hi
 
I am attempting to dump a database using PostgreDAC.
 
I am getting the following error message which I don’t understand.
 
Can someone shed some light on this?
 
“Error message from server: ERROR:  column "tgisconstraint" does not exist
LINE 1: ...c AS tgfname, tgtype, tgnargs, tgargs, tgenabled, tgisconstr...
                                                             ^
FileHandler: The command was: SELECT tgname, tgfoid::pg_catalog.regproc AS tgfname, tgtype, tgnargs, tgargs, tgenabled, tgisconstraint, tgconstrname, tgdeferrable, tgconstrrelid, tginitdeferred, tableoid, oid, tgconstrrelid::pg_catalog.regclass AS tgconstrrelname FROM pg_catalog.pg_trigger t WHERE tgrelid = '19069'::pg_catalog.oid AND tgconstraint = 0”
 
When I execute this command in the SQL pane of PGAdmin and remove “AND tgconstraint = 0” the selct shows a row which is unfamiliar to me.
 
Bob

Re: Dump Error Message

From
John R Pierce
Date:
On 11/04/11 10:22 AM, Bob Pawley wrote:
> I am attempting to dump a database using PostgreDAC.

this postgresDAC?
http://www.microolap.com/products/connectivity/postgresdac/

thats a commercial product, you probably should contact them for support.


--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


Re: Dump Error Message

From
Tom Lane
Date:
"Bob Pawley" <rjpawley@shaw.ca> writes:
> I am attempting to dump a database using PostgreDAC.

> I am getting the following error message which I don’t understand.
> Can someone shed some light on this?

> Error message from server: ERROR:  column "tgisconstraint" does not exist

The pg_trigger.tgisconstraint column was removed in 9.0.  You evidently
need a newer version of PostgreDAC that has heard of 9.0.

            regards, tom lane