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