From: Alex Lau <alex(at)dpcgroup(dot)com>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject:
Date: 2002-03-28 15:58:05
Message-ID: 3CA33D8D.3090806@dpcgroup.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

  • Re: at 2002-04-02 20:34:12 from Tom Lane

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephan Szabo 2002-03-28 16:30:53 Re: deadlock problems with foreign keys
Previous Message Hannu Krosing 2002-03-28 15:56:39 Re: Rough sketch for locale by default