>> The way i find the primary key of a table is: >> SELECT indkey FROM pg_index WHERE indisprimary='t' AND >> indrelid=TABLEOID; >> i noticed that some columns have been added to pg_index : indisvalid, >> indcheckxmin, indisready,indoption >> Should i include any of them (e.g. indisvalid) in the where clause above? > > Do you use oid? We had an issue where old code relied on oid and when > we tested 8.2 we had issues with oid being used but not available. The > fix was easy and only required a id-column of type serial.
... with oid being used [in our webcode] but not available. -- regards Claus When lenity and cruelty play for a kingdom, the gentlest gamester is the soonest winner. Shakespeare -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
