Thread: Get next OID

Get next OID

From
Dianne Yumul
Date:
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
onadding a serial column to the tables and modifying the code to use the serial column instead.  But I am curious to
findout how close we are before the OID wraps around.  Is there a way to check for this?  I tried select max(oid) from
tableon the tables and the highest I got was around 8 million.  I searched the docs, faq and mailing list archives but
haven'tfound any info on getting the next OID. 

Thank you very much.

Dianne



Re: Get next OID

From
Tom Lane
Date:
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
planningon adding a serial column to the tables and modifying the code to use the serial column instead.  But I am
curiousto 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
archivesbut haven't found any info on getting the next OID. 

pg_controldata would tell you approximately where the OID counter is.

            regards, tom lane

Re: Get next OID

From
Dianne Yumul
Date:
On Sep 29, 2010, at 7:56 PM, Tom Lane wrote:

> pg_controldata would tell you approximately where the OID counter is.

Just what I needed.  Thank you so much Tom.

Dianne