Re: Create View failing - Mailing list pgsql-general

From Tom Lane
Subject Re: Create View failing
Date
Msg-id 14975.975448475@sss.pgh.pa.us
Whole thread Raw
In response to Re: Create View failing  ("Bryan White" <bryan@arcamax.com>)
List pgsql-general
"Bryan White" <bryan@arcamax.com> writes:
>> I'll take a look, but in the meantime you might be faced with an initdb
>> to bring the OID counter back under 2G :-(

> I tried creating the view on the main server and it worked just fine.  If
> the OID limit has been exceeded, would not the database load fail miserably?
> Or are you saying that the limit is really 4G but there is a bug in 'create
> view' that limits it to 2G?

It should be 4G, but not all the code has been checked to make sure that
OIDs are always treated as unsigned rather than signed :-(.  There are
probably more weak spots than just views ...

            regards, tom lane

pgsql-general by date:

Previous
From: "Bryan White"
Date:
Subject: Re: Create View failing
Next
From: Ron Chmara
Date:
Subject: Re: Is this possible or am I on drugs :)