Re: Create View failing

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Bryan White" <bryan(at)arcamax(dot)com>
Cc: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Create View failing
Date: 2000-11-28 21:28:41
Message-ID: 11893.975446921@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Bryan White" <bryan(at)arcamax(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bryan White 2000-11-28 21:47:35 Re: Create View failing
Previous Message Brian Aker 2000-11-28 21:12:29 to_days(now())