Re: Using oids - Mailing list pgsql-general

From Dennis Gearon
Subject Re: Using oids
Date
Msg-id 3F560C29.3070705@fireserve.net
Whole thread Raw
In response to Re: Using oids  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
List pgsql-general
The elimination is in concert with the dying of popularity in 'Object
Oriented Databases', right?

Shridhar Daithankar wrote:

>On 3 Sep 2003 at 10:27, Malcolm Warren wrote:
>
>
>
>>To sum up: The Debian migration gzip file declares that oids are not
>>guaranteed to be unique, issues dire warnings about using them as keys and
>>worst of all states that they may be phased out in the future.
>>
>>The book states that they are unique, tells you how to use them, actually
>>gives an example of using them as primary and foreign keys (which
>>fortunately I decided was not very wise) and certainly doesn't say anything
>>about phasing them out in the future.
>>
>>
>
>Yes. It is correct. As of 7.3.x and onwards oids are optional at table creation
>times. They default to be available for new objects but that is for backwards
>compatibility I believe. In future, they would default to be not available for
>a particular object(hopefully). Right now you need to explicitly specify no
>oids while creating tables etc.
>
>About oids not being unique, oids can assume 4 billion different values. If you
>have more than those many rows in a table, oids will wrap around and will no
>longer be unique in that object.
>
>About oids being eliminated, I am sure it would happen some time in the future,
>looking at the development on this issue. Core team could elaborate more on
>this.
>
>Correct me if I am wrong.
>
>HTH
>
>Bye
> Shridhar
>
>--
>Nusbaum's Rule:    The more pretentious the corporate name, the smaller the
>organization.  (For instance, the Murphy Center for the    Codification of Human
>and Organizational Law, contrasted    to IBM, GM, and AT&T.)
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faqs/FAQ.html
>
>
>


pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: Using oids
Next
From: psql-mail@freeuk.com
Date:
Subject: postmaster crashing