Questions regarding OID - Mailing list pgsql-general

From Richi Plana
Subject Questions regarding OID
Date
Msg-id Pine.LNX.4.10.9906252254380.12924-100000@jaguar.mozcom.com
Whole thread Raw
Responses Re: [GENERAL] Questions regarding OID  (Karl DeBisschop <kdebisschop@spaceheater.infoplease.com>)
List pgsql-general
Hi,

I'm trying to use PostgreSQL data type oid and I have a couple of
questions about it:

1) (Most important) Where can I find documentation covering the use of
OIDs in PostgreSQL? The only doc which discusses it somewhat that I've
seen is the FAQ (and it just tells people what OIDs are)

2) Can it be used together with NOT NULL or PRIMARY KEY?

3) How does one INSERT data in a table with an oid field? (what does one
put in the VALUES () entry assigned to the OID?)

4) What happens if you CREATE a table with more than one field with oids?

5) How big are OIDs? If I use another field in another table to reference
the OID, I need to know how big a char() field I need to define.

Thanks for any help.


L   L Richi Plana 8^)         ,-,-.     ,-,-.     ,-,-.     ,-,-.     ,-
LL LL Systems Administrator  / / \ \   / / \ \   / / \ \   / / \ \   / /
LLLLL Mosaic Communications, Inc. \ \ / /   \ \ / /   \ \ / /   \ \ / /
LLLLL mailto:richip@mozcom.com     `-'-'     `-'-'     `-'-'     `-'-'


pgsql-general by date:

Previous
From: Mario Jorge Nunes Filipe
Date:
Subject: What does this mean ?
Next
From: Thomas Reinke
Date:
Subject: Re: [GENERAL] What does this mean ?