X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 087F33A5391 for ; Mon, 24 Jan 2005 05:10:54 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 31017-03 for ; Mon, 24 Jan 2005 05:10:42 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id 82F8C3A5367 for ; Mon, 24 Jan 2005 05:10:41 +0000 (GMT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.1/8.13.1) with ESMTP id j0O5AbQQ011530 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK) for ; Sun, 23 Jan 2005 22:10:39 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.1/8.13.1) with ESMTP id j0O5AbMP039511 for ; Sun, 23 Jan 2005 22:10:37 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.1/8.13.1/Submit) id j0O5Ab6R039510 for pgsql-docs@postgresql.org; Sun, 23 Jan 2005 22:10:37 -0700 (MST) (envelope-from mfuhr) Date: Sun, 23 Jan 2005 22:10:37 -0700 From: Michael Fuhr To: pgsql-docs@postgresql.org Subject: FAQ 4.15 misleading about uniqueness of OIDs Message-ID: <20050124051036.GA39462@winnie.fuhr.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/48 X-Sequence-Number: 2807 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/