| 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:54:35 |
| Message-ID: | 14975.975448475@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:
>> 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 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?
It should be 4G, but not all the code has been checked to make sure that
OIDs are always treated as unsigned rather than signed :-(. There are
probably more weak spots than just views ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Chmara | 2000-11-28 22:17:01 | Re: Is this possible or am I on drugs :) |
| Previous Message | Bryan White | 2000-11-28 21:47:35 | Re: Create View failing |