Re: Create View failing

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Create View failing
Дата
Msg-id 11893.975446921@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Create View failing  ("Bryan White" <bryan@arcamax.com>)
Список 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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: sgmlspl?
Следующее
От: "Bryan White"
Дата:
Сообщение: Re: Create View failing