Dianne Yumul <dia...@wellsgaming.com> writes: > 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.
pg_controldata would tell you approximately where the OID counter is. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general