Questions regarding OID

From: Richi Plana <richip(at)mozcom(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Questions regarding OID
Date: 1999-06-25 15:00:25
Message-ID: Pine.LNX.4.10.9906252254380.12924-100000@jaguar.mozcom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)mozcom(dot)com `-'-' `-'-' `-'-' `-'-'

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Reinke 1999-06-25 15:17:38 Re: [GENERAL] What does this mean ?
Previous Message Mario Jorge Nunes Filipe 1999-06-25 14:32:57 What does this mean ?