=CE=A3=CF=84=CE=B9=CF=82 Wednesday 07 May 2008 14:49:31 =CE=BF/=CE=B7
Claus=
Guttesen =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5:
> > we have been running our own heavily modified/enhanced version of
dbmir=
ror, 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=3D't' AND
indreli=
d=3DTABLEOID;
> > i noticed that some columns have been added to pg_index : indisvalid,
i=
ndcheckxmin, indisready,indoption
> > Should i include any of them (e.g. indisvalid) in the where clause
abov=
e?
>=20
> 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.
>=20
No, we dont use OID as primary keys.
--=20
Achilleas Mantzios
--=20
Sent via pgsql-sql mailing list (pgsql-sql@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
|
