Re: [BUGS] [ADMIN] How to set the global OID counter? COPY WITH OIDS does

#1

=?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <lutzeb (AT) aeccom (DOT) com> writes:

Quote:

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] [ADMIN] How to set the global OID counter? COPY WITH OIDS does

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] [ADMIN] How to set the global OID counter? COPY WITH OIDS does - 06-09-2006 , 10:19 AM