I tried to get the definition of unique and primary key constraints via
as oidofconstraint I put the OID displayed in pg_admins property pain when
selecting a constraint.
This failed with
ERROR: could not find tuple for constraint 36099
SQL state: XX000
when I took the OID from UNIQUE and PRIMARY KEY constraints.
Then I moved on and took the OID from FOREIGN KEY constraints, and got
digging in pg_catalog.pg_constraints made me learn that pg_admin shows those
OIDs for UNIQUE and PRIMARY key constraints "off by one", that is:
if I do
I get the needed result....
Please find that "-1" and add it again :)
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Python: the only language with more web frameworks than keywords.
pgadmin-support by date
|Next:||From: Dave Page||Date: 2007-04-04 15:52:59|
|Subject: Re: Wrong OID for Primary Key and UNIQUE constraints
shown in property pane|
|Previous:||From: Raymond O'Donnell||Date: 2007-04-04 10:54:16|
|Subject: Re: Document for PgAdmin|