Re: - Mailing list pgsql-hackers

From Tom Lane
Subject Re:
Date
Msg-id 27559.1017779652@sss.pgh.pa.us
Whole thread Raw
In response to ...  (Alex Lau <alex@dpcgroup.com>)
List pgsql-hackers
Alex Lau <alex@dpcgroup.com> writes:
> CREATE TABLE mytesting ( dosnotmatter text );
> CREATE INDEX myunique ON mytesting oid;

> will this help to make sure the oid is unique?

No, but

CREATE UNIQUE INDEX myunique ON mytesting (oid);

would do the trick.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Daniel Kalchev
Date:
Subject: maxint reached?
Next
From: Daniel Kalchev
Date:
Subject: Re: maxint reached?