Wrong OID for Primary Key and UNIQUE constraints shown in property pane

Hello,

I tried to get the definition of unique and primary key constraints via

select pg_get_constraintdef(<oidofconstraint>)

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
results...

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

select pg_get_constraintdef(36100)

instead of

select pg_get_constraintdef(36099)

I get the needed result....

Please find that "-1" and add it again :)

Best wishes,

Harald

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
fx 01212-5-13695179
-
Python: the only language with more web frameworks than keywords.