knowledge-database (beta)

Current group: pgsql.docs

FAQ 4.15 misleading about uniqueness of OIDs

FAQ 4.15 misleading about uniqueness of OIDs  
Michael Fuhr
 Re: FAQ 4.15 misleading about uniqueness of OIDs  
Tom Lane
From:Michael Fuhr
Subject:FAQ 4.15 misleading about uniqueness of OIDs
Date:Sun, 23 Jan 2005 22:10:37 -0700
FAQ 4.15 "What is an OID? What is a TID?" is misleading about the
uniqueness of OIDs. It does mention the possibility of overflow
(while mentioning that nobody has ever reported it), but it doesn't
discourage their use as primary keys like the documentation does
in, for example, the following sections:

http://www.postgresql.org/docs/8.0/static/datatype-oid.html
http://www.postgresql.org/docs/8.0/static/ddl-system-columns.html

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
From:Tom Lane
Subject:Re: FAQ 4.15 misleading about uniqueness of OIDs
Date:Mon, 24 Jan 2005 00:28:12 -0500
Michael Fuhr writes:
> FAQ 4.15 "What is an OID? What is a TID?" is misleading about the
> uniqueness of OIDs. It does mention the possibility of overflow
> (while mentioning that nobody has ever reported it),

The latter claim is surely obsolete, anyway.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org
   

Copyright © 2006 knowledge-database   -   All rights reserved