Re: thw rewriter and default values, again

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Jaime Casanova <systemguards(at)gmail(dot)com>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: thw rewriter and default values, again
Date: 2005-05-28 14:25:48
Message-ID: 87psvb4ec3.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Jaime Casanova <systemguards(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-05-28 15:23:30 Re: thw rewriter and default values, again
Previous Message Jochem van Dieten 2005-05-28 13:30:46 Re: overlaps() does not work as expected?