Re:

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alex Lau <alex(at)dpcgroup(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re:
Date: 2002-04-02 20:34:12
Message-ID: 27559.1017779652@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alex Lau <alex(at)dpcgroup(dot)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

In response to

  • at 2002-03-28 15:58:05 from Alex Lau

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Kalchev 2002-04-02 20:39:33 Re: maxint reached?
Previous Message Daniel Kalchev 2002-04-02 20:25:15 maxint reached?