Postgres Pro
Downloads
Home   >   mailing lists

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

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

> The oid column will always be blank. The oid column can never be used
> for anything usefull.

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


______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
Attachment

pgsql-sql by date:

Previous
From: "Sushil Kumar"
Date:
Subject: Privileges on Functions in Postgres 7.1.3
Next
From: Douglas Rafael da Silva
Date:
Subject: Diferent databases on same query...