Horton

Re: How to set the global OID counter? COPY WITH OIDS does

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dirk Lutzebäck <lutzeb@aeccom.com>
Cc: Alvaro Herrera <alvherre@commandprompt.com>, pgsql-admin@postgresql.org, pgsql-general@postgresql.org, pgsql-bugs@postgresql.org, Sven Geisler <sgeisler@aeccom.com>, pavel rabaev <pavel@aeccom.com>
Date: 2006-06-09T15:18:23Z
Lists: pgsql-bugs 
=?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <lutzeb@aeccom.com> writes:
> This is not a large object. We are seeing rows with duplicate oids 
> because the OID counter is not changed after the dump (exported with 
> --oids) is being loaded.
> How does 8.1 prevent to allocate duplicate OIDs?

If there's a unique index on the OID column then 8.1 will not allocate
duplicate OIDs.  If there's not such a unique index, you had no
guarantee of no-duplicates before 8.1 either.

			regards, tom lane