Get next OID

Поиск
Список
Период
Сортировка
От Dianne Yumul
Тема Get next OID
Дата
Msg-id 8C1F9FA6-4E25-467B-B1C8-B6FE2BFEEF0E@wellsgaming.com
обсуждение исходный текст
Ответы Re: Get next OID  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
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



В списке pgsql-general по дате отправления:

Предыдущее
От: Thom Brown
Дата:
Сообщение: Re: Prepared statements and unknown types
Следующее
От: David Kerr
Дата:
Сообщение: Centralized User Management Tool?