Thread: Dump Error Message
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
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
"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