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 `-'-' `-'-' `-'-' `-'-'