Re: oid's in views. - Mailing list pgsql-sql

From Josh Berkus
Subject Re: oid's in views.
Date
Msg-id web-151411@davinci.ethosmedia.com
Whole thread Raw
In response to Re: oid's in views.  ("Aasmund Midttun Godal" <postgresql@envisity.com>)
Responses Re: oid's in views.  ("Aasmund Midttun Godal" <aasmund@godal.com>)
List pgsql-sql
Aasmund,

> I don't use them in indexes foreign keys etc., however they are very
> usefull when your application tries to edit/update individual rows,
> as the oid is like a universal primary key.

You'd still be better off defining your own SERIAL columns and/or
primary keys and using those.  Some Trigger types require referencing
the OID, but that's about it.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco
 


pgsql-sql by date:

Previous
From: Joel Burton
Date:
Subject: Re: system maintained keys
Next
From: "David Allardyce"
Date:
Subject: Re: Table Constraints with NULL values