Re: GetNewOidWithIndex can cause infinite loop on user tables(not catalog). - Mailing list pgsql-bugs

From Tom Lane
Subject Re: GetNewOidWithIndex can cause infinite loop on user tables(not catalog).
Date
Msg-id 8705.1203524119@sss.pgh.pa.us
Whole thread Raw
In response to Re: GetNewOidWithIndex can cause infinite loop on user tables(not catalog).  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
List pgsql-bugs
"Heikki Linnakangas" <heikki@enterprisedb.com> writes:
> Jacky Leng wrote:
>> --Create table t(a int) with oids;
>> --create unique index it on t(oid);
>> --insert 4G-16384 rows into t;

> ... Therefore: don't do that.

Indeed.  It might be a good idea if that loop had a
CHECK_FOR_INTERRUPTS, though.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #3965: UNIQUE constraint fails on long column values
Next
From: Tom Lane
Date:
Subject: Re: BUG #3969: pg_ctl cannot detect server startup