| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Dianne Yumul <dianne(at)wellsgaming(dot)com> |
| Cc: | PostgreSQL List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Get next OID |
| Date: | 2010-09-30 02:56:06 |
| Message-ID: | 25755.1285815366@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Dianne Yumul <dianne(at)wellsgaming(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karl Denninger | 2010-09-30 02:57:03 | Re: Somewhat odd messages being logged on replicated server |
| Previous Message | Jeff Davis | 2010-09-30 01:55:59 | Re: Somewhat odd messages being logged on replicated server |