From: | "Bob Pawley" <rjpawley(at)shaw(dot)ca> |
---|---|
To: | "Postgresql" <pgsql-general(at)postgresql(dot)org> |
Subject: | Dump Error Message |
Date: | 2011-11-04 17:22:54 |
Message-ID: | B7108572432E495CB43F178B5F7A94C5@BobPC |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2011-11-04 17:32:16 | Re: Dump Error Message |
Previous Message | Brandon Phelps | 2011-11-04 17:07:58 | Re: Replication Across Two Servers? |