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.
