From: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
---|---|
To: | "Claus Guttesen" <kometen(at)gmail(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: dbmirror - migration to 8.3 from 7.4 |
Date: | 2008-05-07 11:52:59 |
Message-ID: | 200805071452.59344.achill@matrix.gatewaynet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Στις Wednesday 07 May 2008 14:49:31 ο/η Claus Guttesen έγραψε:
> > we have been running our own heavily modified/enhanced version of dbmirror, running on 7.4 for some years,
> > and now it is the time to upgrade to 8.3.
> >
> > 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.
>
No, we dont use OID as primary keys.
--
Achilleas Mantzios
From | Date | Subject | |
---|---|---|---|
Next Message | Woody Woodring | 2008-05-07 14:36:26 | Insert with pl/pgsql trigger |
Previous Message | Claus Guttesen | 2008-05-07 11:51:23 | Re: dbmirror - migration to 8.3 from 7.4 |