Re: Double sequence increase on single insert with RULE on targeted table

From: tomas(at)tuxteam(dot)de (Tomas Zerolo)
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: Tomas Zerolo <tomas(at)tuxteam(dot)de>, Sarunas Krisciukaitis <sarunask(at)lonus-tech(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Double sequence increase on single insert with RULE on targeted table
Date: 2005-11-16 06:02:27
Message-ID: 20051116060227.GB6265@www.trapp.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, Nov 15, 2005 at 10:51:10PM -0700, Michael Fuhr wrote:
> 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);

[...]

Oops, I didn't see that. Your eyes are sharper than mine ;-)

thanks
-- tomas

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Sarunas Krisciukaitis 2005-11-16 08:31:10 Re: Double sequence increase on single insert with RULE on
Previous Message Michael Fuhr 2005-11-16 05:51:10 Re: Double sequence increase on single insert with RULE on targeted table