Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] How to set the global OID counter? COPY WITH OIDS does - Mailing list pgsql-general

From Tom Lane
Subject Re: [ADMIN] How to set the global OID counter? COPY WITH OIDS does
Date
Msg-id 10905.1149866303@sss.pgh.pa.us
Whole thread Raw
In response to Re: [ADMIN] How to set the global OID counter? COPY WITH OIDS does  (Dirk Lutzebäck <lutzeb@aeccom.com>)
Responses Re: [ADMIN] How to set the global OID counter? COPY WITH OIDS does  (Dirk Lutzebäck <lutzeb@aeccom.com>)
List pgsql-general
Tree view 
=?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

pgsql-general by date:

Previous
From: Adam Witney
Date:
Subject: Re: not valid character for Unicode
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Fabian Pascal and RDBMS deficiencies in fully implementing the relational model