Postgres Pro
Downloads
Home   >   mailing lists

Can you run out of oids? - Mailing list pgsql-general

From Chris Hoover
Subject Can you run out of oids?
Date
Msg-id 1d219a6f0608011102x5c06809bt30e81691f880fb7d@mail.gmail.com
Whole thread Raw
Responses Re: Can you run out of oids?  (Martijn van Oosterhout <kleptog@svana.org>)
Re: Can you run out of oids?  (Michael Fuhr <mike@fuhr.org>)
Re: Can you run out of oids?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
Somewhat silly question, but is it possible to run out of OID's?

Since we upgraded to 8.1.3, I noticed that I can create tables without an oid column.  I am wondering if I should consider trying to rebuild the existing tables to be built without OID. 

If it is possible to run out of OID's, how can you tell how close you are to the edge.

Thanks,

Chris

RH4.0
PG8.1.3

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: LISTEN considered dangerous
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Can you run out of oids?