RE: [GENERAL] Re: 4 billion record limit?

2000-07-28 Thread Andrew Snow
> > That's an excellent point, especially considering that *sequences* use > > an integer to hold their max_value, which is by default 2,147,483,647. > > You cannot go larger than that, either. I guess it's constrained to be > > positive. So OIDs give you more potential unique values than seque

Re: [GENERAL] Re: 4 billion record limit?

2000-07-28 Thread Ross J. Reedstrom
On Fri, Jul 28, 2000 at 11:48:10AM -0500, Keith G. Murphy wrote: > Mitch Vincent wrote: > > > > There is something else that many aren't considering. In every application > > I've ever written to use any database I use ID numbers of my own making, > > always they're integer. 4 billion is the lim

Re: [GENERAL] Re: 4 billion record limit?

2000-07-28 Thread Keith G. Murphy
Mitch Vincent wrote: > > There is something else that many aren't considering. In every application > I've ever written to use any database I use ID numbers of my own making, > always they're integer. 4 billion is the limit on any integer field, not > just the OID so there are limitations everyo