=?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <lutzeb@xxxxxxxxxx> 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
