Re: Create View failing - Mailing list pgsql-general

From Bryan White
Subject Re: Create View failing
Date
Msg-id 02c701c05984$d1d31280$2dd260d1@arcamax.com
Whole thread Raw
In response to Create View failing  ("Bryan White" <bryan@arcamax.com>)
Responses Re: Create View failing  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> 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 creating the view on the main server and it worked just fine.  If
the OID limit has been exceeded, would not the database load fail miserably?
Or are you saying that the limit is really 4G but there is a bug in 'create
view' that limits it to 2G?

>
> regards, tom lane


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Create View failing
Next
From: Tom Lane
Date:
Subject: Re: Create View failing