Re: Reset oid , starting value=1 -- Max. Number of OID - Mailing list pgsql-general

From Gellert, Andre
Subject Re: Reset oid , starting value=1 -- Max. Number of OID
Date
Msg-id 2740724BDE77EC4CB3CF41EA2227845730AE90@NT-VISEXCH
Whole thread Raw
Responses Re: Reset oid , starting value=1 -- Max. Number of OID  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
> The only way to reset oids is to destroy the entire data directory and
> initdb again. In recent versions you can create tables
> without oids, thus
> reducing their usage.

Today we have oid's > 2147483647 , what happens, if we have more than
allowed ? I remember it was about 4 billions max. oid's, will Postgres
refresh itself or will it produce errors like "max. records inserted" ???

PS: My solution : I moved the applications data to another server ;-) with
only 1.970.230.087 used OIDs , the application is being fixed at the moment
(a typecast to int is used on nearly every page).


pgsql-general by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: [ADMIN] Full textsearch & gist (fwd)
Next
From: "John Sidney-Woollett"
Date:
Subject: Re: Select for update Question