OIDs (Or: another RTFM question?)

From: Adrian 'Dagurashibanipal' von Bidder <avbidder(at)fortytwo(dot)ch>
To: pgsql-general(at)postgresql(dot)org
Subject: OIDs (Or: another RTFM question?)
Date: 2002-07-16 14:23:49
Message-ID: 1026829429.974.35.camel@atlas
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Yo!

Browsing through the online docs, I see the special columns documented
in http://www.postgresql.org/idocs/index.php?sql-syntax-columns.html .

But I'm missing discussion about significance of the oids - something
along the lines of 'Creating tables WITHOUT OIDS does *not* safe any
disk space, but does <give you what?> at the expense of <what? being not
backward compatible, I guess>.'

Such documentation seems necessary to me, since pg creates tables with
oids per default (does it still?), but intuitively I feel this somewhat
silly - as oids are obviously optional, why have them built in?

(I'm sure these issues have been beaten to death when the WITHOUT OIDS
feature was introduced, but I couldn't find the relevant discussion in
the archives. Pointers welcome.)

cheers
-- vbi

--
secure email with gpg http://fortytwo.ch/gpg

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Cyrill Polikarpov 2002-07-16 14:27:18 User's management
Previous Message Rick Eicher II 2002-07-16 14:22:47 Backend died abnormally - postgresql 7.2.1-5