Re: OID's....

> >    Also, when the OID's reach the limit of an int4, if I recall correctly,
> > they simply wrap around, and things keep working unless you depend on
> > unique OID's.  Is that correct?
>
> That's the theory, anyway.  After the wrap, you could see occasional
> failures due to OID conflicts in the system catalogs --- for example, if
> you try to create a table but the assigned OID duplicates some existing
> table's OID, you'd get a can't-insert-duplicate-into-unique-index kind
> of failure.  The solution if that happens is just to try again;
> eventually you'll get an OID that doesn't conflict.  But the odds of a
> conflict like that should be very low in practice.

Seems we could avoid that by getting another oid and retrying.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026