Re: [GENERAL] Get next OID

2010-09-30 Thread Dianne Yumul
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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

[GENERAL] Get next OID

2010-09-29 Thread Dianne Yumul
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

Re: [GENERAL] Get next OID

2010-09-29 Thread Tom Lane
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