Re: [GENERAL] [NOVICE] Skipping numbers in a sequence.

2000-11-24 Thread Robert Boyd
Try a dump of your database using pg_dump. 4294967296 is the maxval if I remember correctly. 32 bit integers are a good thing. Your question still holds, what is the condition of overflow after maxval has been reached. Typically, you want to use a sequence like this for a unique opaque indent

[GENERAL] [NOVICE] Skipping numbers in a sequence.

2000-11-23 Thread GH
Hello all. It's like this. ;-) I have a table with a column that has a default nextval('sequence'). The sequence is a standard increment 1 cycle sequence. What happens when the sequence wraps after inserting the 2-million-and-whatever-th row some of the earlier