| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Chris Hoover <revoohc(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Can you run out of oids? |
| Date: | 2006-08-01 19:00:35 |
| Message-ID: | 44CFA4D3.9090907@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Martijn van Oosterhout wrote:
> On Tue, Aug 01, 2006 at 02:02:18PM -0400, Chris Hoover wrote:
>> Somewhat silly question, but is it possible to run out of OID's?
>
> Nope. When you reach 4 billion, they just start again at zero.
O.k. but there is a catch.. if you are using them, they can and will
wrap. So don't use OIDs.
Joshua D. Drake
>
> Have a nice day,
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Harding | 2006-08-01 19:02:22 | Re: LISTEN considered dangerous |
| Previous Message | Eric Andrews | 2006-08-01 18:58:00 | proper use of array datatype |