note 40257 added to function.pg-last-oid

From: Date: Thu, 26 Feb 2004 19:51:54 +0000
Subject: note 40257 added to function.pg-last-oid
Groups: php.notes 
Request: Send a blank email to php-notes+get-65823@lists.php.net to get a copy of this message
note the following: "The oid type is currently implemented as an unsigned four-byte integer. Therefore, it is not large enough to provide database-wide uniqueness in large databases, or even in large individual tables. So, using a user-created table's OID column as a primary key is discouraged. OIDs are best used only for references to system tables." and "OIDs are 32-bit quantities and are assigned from a single cluster-wide counter. In a large or long-lived database, it is possible for the counter to wrap around. Hence, it is bad practice to assume that OIDs are unique, unless you take steps to ensure that they are unique." from: http://www.phphub.com/postgres_manual/index.php?p=datatype-oid.html ---- Manual Page -- http://www.php.net/manual/en/function.pg-last-oid.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+40257 Delete -- http://master.php.net/manage/user-notes.php?action=delete+40257&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+40257&report=yes Search -- http://master.php.net/manage/user-notes.php

« previous php.notes (#65823) next »