Re: dbmirror - migration to 8.3 from 7.4

>> 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@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql