CREATE TABLE mytesting ( dosnotmatter text );

CREATE INDEX myunique ON mytesting oid;

will this help to make sure the oid is unique? and is that right?
if in fact the oid roll over, and insertation fail. Will reinsert  get 
an new oid or the same oid retry.
Alex



Thu, 28 Mar 2002 09:58:05 -0600
Alex Lau <alex@dpcgroup.com>
None
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

Tue, 02 Apr 2002 15:34:12 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: 