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

From Aasmund Midttun Godal
Subject Re: oid's in views.
Date
Msg-id 20011019191030.2126.qmail@ns.krot.org
Whole thread Raw
In response to Re: oid's in views.  ("Josh Berkus" <josh@agliodbs.com>)
Responses Re: oid's in views.  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-sql
On Fri, 19 Oct 2001 08:07:50 -0700, "Josh Berkus" <josh@agliodbs.com> wrote:
> Aasmund,
> 
> 
> I believe the *official* reccommendation now is that you leave the OIDs
> to the system, and create your own SERIAL values for row identification.
> There are *lots* of problems with using OIDs as an index, and you've
> just found one more!
> 
> -Josh
I don't use them in indexes foreign keys etc., however they are very usefull when your application tries to edit/update
individualrows, as the oid is like a universal primary key.
 
> 
> 
> ______AGLIO DATABASE SOLUTIONS___________________________
>                                        Josh Berkus
>   Complete information technology      josh@agliodbs.com
>    and data management solutions       (415) 565-7293
>   for law firms, small businesses        fax 621-2533
>     and non-profit organizations.      San Francisco
> 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html

Aasmund Midttun Godal

aasmund@godal.com - http://www.godal.com/
+47 40 45 20 46


pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: system maintained keys
Next
From: Jason Earl
Date:
Subject: Re: system maintained keys