Re: Using oids - Mailing list pgsql-general

From Malcolm Warren
Subject Re: Using oids
Date
Msg-id opruw3roxaoa2ek7@10.0.0.1
Whole thread Raw
In response to Re: Using oids  (Bo Lorentsen <bl@netgroup.dk>)
Responses Re: Using oids  (Jonathan Bartlett <johnnyb@eskimo.com>)
List pgsql-general
On Wed, 03 Sep 2003 11:28:01 +0200, Bo Lorentsen <bl@netgroup.dk> wrote:

> On Wed, 2003-09-03 at 11:10, Shridhar Daithankar wrote:
>
>> 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.

The point about oids is that they are so useful that many people have used
them extensively, me included.
And I did so on the basis of a book written by Bruce Mowjian, one of
Postgresql's major contributors.

If we are saying that there will always be backwards compatibility then I
can sleep at night.
If we are saying that at some point oids will exist no more then all of a
sudden I am going to have to re-write an awful lot of code.

Malcolm Warren

pgsql-general by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: Oracle decode Function in Postgres
Next
From: "Amin Schoeib"
Date:
Subject: ERROR: PLPGSQL does not exist