Re: [SQL] duplicated oid

2001-09-06 Thread Tom Lane
Carolyn Lu Wong <[EMAIL PROTECTED]> writes: > anyone knows if duplicated oid is possible?? Yes, if you don't have a unique index on it and you've generated more than four billion rows in the database. > is there a possible way to remove the duplicate row, now that i don't > know which ID to use

Re: [SQL] duplicated oid

2001-09-06 Thread Stephan Szabo
On Fri, 7 Sep 2001, Carolyn Lu Wong wrote: > anyone knows if duplicated oid is possible?? > > is there a possible way to remove the duplicate row, now that i don't > know which ID to use? any suggestions? Hmm, that's wierd. AFAIK that should only occur in cases like copy with oids and oid wrap

Re: [SQL] duplicated oid

2001-09-06 Thread Carolyn Lu Wong
anyone knows if duplicated oid is possible?? is there a possible way to remove the duplicate row, now that i don't know which ID to use? any suggestions? Carolyn Lu Wong wrote: > > i'm using V6.5. > > >From my understanding, the oid should be unique in all rows of database. > However, I'm get

[SQL] duplicated oid

2001-09-03 Thread Carolyn Lu Wong
i'm using V6.5. >From my understanding, the oid should be unique in all rows of database. However, I'm getting duplicated data on one particular table, including the oid is the same! I don't recall trying to restore nor import any data. Any idea why? ---(end of broadcast