In the future, please don't send the same email to a bunch of pgsql lists; one is almost always sufficient. (In this case, -admin OR -general woulud have been best). On Fri, Jun 09, 2006 at 05:27:47PM +0200, Dirk Lutzeb?ck wrote: > True. > > Dirk > > Tom Lane wrote: > >=?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 > > > > -- > /This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they are > addressed. If you are not the intended recipient, you should not copy > it, re-transmit it, use it or disclose its contents, but should return > it to the sender immediately and delete your copy from your system. > Thank you for your cooperation./ > > *Dirk Lutzeb?ck* <lutzeb@xxxxxxxxxx> Tel +49.30.5362.1635 Fax .1638 > CTO AEC/communications GmbH <http://www.aeccom.com>, Berlin, Germany > -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
