Re: sequence skips 30 values, how?

am Wed, dem 31.01.2007, um 7:43:05 -0500 mailte Geoffrey folgendes:
> dies. We've tracked this to an unusual situation where a sequence value
> that is being created during the process that is causing the core file
> generation. The thing that is bizarre is that the sequence value skips
> 30+ entries.
>
> How is this even possible? Any suggestions would be greatly appreciated.

A sequence don't guaranteed a gapless behavior.

Simple example:

test=# create table gap (id serial);
NOTICE: CREATE TABLE will create implicit sequence "gap_id_seq" for
serial column "gap.id"
CREATE TABLE
test=*# insert into gap values (default)
test-# ;
INSERT 0 1
test=*# commit;
COMMIT
test=# insert into gap values (default);
INSERT 0 1
test=*# insert into gap values (default);
INSERT 0 1
test=*# rollback;
ROLLBACK
test=# insert into gap values (default);
INSERT 0 1
test=*# commit;
COMMIT
test=# select * from gap;
id
----
1
4
(2 rows)

Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net