Re: Create View failing

"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