Get next OID
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
Dianne Yumul <dianne@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