Skip site navigation (1) Skip section navigation (2)

Re: dbmirror - migration to 8.3 from 7.4

From: "Claus Guttesen" <kometen(at)gmail(dot)com>
To: "Achilleas Mantzios" <achill(at)matrix(dot)gatewaynet(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: dbmirror - migration to 8.3 from 7.4
Date: 2008-05-07 11:51:23
Message-ID: b41c75520805070451q2e0f1b4dyb3c53224582f42fc@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-sql
>> 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

In response to

pgsql-sql by date

Next:From: Achilleas MantziosDate: 2008-05-07 11:52:59
Subject: Re: dbmirror - migration to 8.3 from 7.4
Previous:From: Claus GuttesenDate: 2008-05-07 11:49:31
Subject: Re: dbmirror - migration to 8.3 from 7.4

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group