I think I have found a bug in version 7.1.3. (I have installed binary
rpms from postgres site on rh7.1)
Here is the DB and some sample entries.
CREATE TABLE "timetest" (
"id" serial primary key,
"timebegin" time,
"timeend" time
);
insert into timetest (timeb
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
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
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
