Hello everyone,

We have PostgreSQL 8.1.21 on CentOS 5.5 and some of our older programs still 
use OIDs to identify a row.  I'm planning on adding a serial column to the 
tables and modifying the code to use the serial column instead.  But I am 
curious to find out how close we are before the OID wraps around.  Is there a 
way to check for this?  I tried select max(oid) from table on the tables and 
the highest I got was around 8 million.  I searched the docs, faq and mailing 
list archives but haven't found any info on getting the next OID.

Thank you very much.

Dianne



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to