Re: Create View failing - Mailing list pgsql-general

From Tom Lane
Subject Re: Create View failing
Date
Msg-id 11893.975446921@sss.pgh.pa.us
Whole thread Raw
In response to Create View failing  ("Bryan White" <bryan@arcamax.com>)
List pgsql-general
"Bryan White" <bryan@arcamax.com> writes:
> ERROR:  pg_atoi: error reading "3642040800": Numerical result out of range

> The reported number is incremented by a small amount each time.

Hmm.  Have you been running that database long enough that the OID
counter could be up to 3.6 billion?  It sounds like there might be some
confusion in the view save/read routines about whether OIDs are signed
or unsigned.

I'll take a look, but in the meantime you might be faced with an initdb
to bring the OID counter back under 2G :-(

            regards, tom lane

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: sgmlspl?
Next
From: "Bryan White"
Date:
Subject: Re: Create View failing