Re: [ADMIN] OID Overflow for large objects

2004-05-11 Thread Jeff Boes
Tom Lane wrote: (http://www3.sk.postgresql.org/docs/faqs/FAQ.html): OIDs are stored as 4-byte integers, and will overflow at 4 billion. No one has reported this ever happening, and we plan to have the limit removed before anyone does. That comment in the FAQ seems quite out-of-date. Wha

Re: [ADMIN] OID Overflow for large objects

2004-05-07 Thread Tom Lane
Jeff Boes <[EMAIL PROTECTED]> writes: > I found some indication of the problem referenced in the Pg FAQ > (http://www3.sk.postgresql.org/docs/faqs/FAQ.html): > OIDs are stored as 4-byte integers, and will overflow at 4 billion. No > one has reported this ever happening, and we plan to have the lim

[ADMIN] OID Overflow for large objects

2004-05-07 Thread Jeff Boes
We had a puzzling situation occur last weekend. Subsequently, I figured out how to work around it for now, but of course those who sign my checks want to know how we can nail down forever the possibility that something like that will ever happen again ... The OID value for large objects crossed th