On Wed, Nov 16, 2005 at 06:29:40AM +0100, Tomas Zerolo wrote:
> AFAIK, serials are not guaranteed to produce sequential values; tehy
> will produce unique values. That means that they can (and sometimes
> will) jump.
In this particular case, however, the behavior is due to the rule
on test1:
CREATE RULE test1_on_insert AS ON INSERT TO test1
DO INSERT INTO test_log1 (qid) VALUES (new.id);
This "gotcha" comes up occasionally; it's due to the fact that rules
are macros. Search the archives for past discussion.
--
Michael Fuhr