Re: [GENERAL] Bigger sequences (int8)

2000-06-20 Thread Bryan White
> Can I make a sequence use an int8 instead of int4? > > I have an application where, over a few years, it's quite possible to hit > the ~2 billion limit. (~4 billion if I start the sequence at -2 > billion.) > > There won't be that many records in the table, but there will be that many > inserts

[GENERAL] Bigger sequences (int8)

2000-06-20 Thread Paul Caskey
Can I make a sequence use an int8 instead of int4? I have an application where, over a few years, it's quite possible to hit the ~2 billion limit. (~4 billion if I start the sequence at -2 billion.) There won't be that many records in the table, but there will be that many inserts. In othe