Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group