"Bryan White" <[EMAIL PROTECTED]> 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
> 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 am doing this on my backup db server. The database is recreated nightly
from a dump from the main database server. Maybe I need to do an initdb
nightly as well?
I tried crea
"Bryan White" <[EMAIL PROTECTED]> 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 soun
I am trying to play with views. Every time I try to create one I get a
message like this:
ERROR: pg_atoi: error reading "3642040800": Numerical result out of range
The reported number is incremented by a small amount each time. Here is the
create statement:
create view ordertotals as select
