Re: thw rewriter and default values, again - Mailing list pgsql-hackers

From Greg Stark
Subject Re: thw rewriter and default values, again
Date
Msg-id 87psvb4ec3.fsf@stark.xeocode.com
Whole thread Raw
In response to thw rewriter and default values, again  (Jaime Casanova <systemguards@gmail.com>)
Responses Re: thw rewriter and default values, again
List pgsql-hackers
Jaime Casanova <systemguards@gmail.com> writes:

> The only problem i have found until now is that
> update v_foo set col1 = DEFAULT; execute nextval twice per every record.
> so there will be a gasp between numbers, but AFAIK nextval has no guarantee
> of returning sequential numbers.

While there's no guarantee that strong there's still an expected behaviour.
sequences generate sequential numbers and only skip in specific cases.

I think this would still surprise and bother most users.

-- 
greg



pgsql-hackers by date:

Previous
From: Jochem van Dieten
Date:
Subject: Re: overlaps() does not work as expected?
Next
From: Tom Lane
Date:
Subject: Re: thw rewriter and default values, again