Horton

Re: [PATCHES] Changes to sequence.c

Vadim B. Mikheev <vadim@sable.krasnoyarsk.su>

View thread
From: "Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
To: "Billy G. Allie" <Bill.Allie@mug.org>
Cc: pgsql-patches@postgreSQL.org, pgsql-hackers@postgreSQL.org
Date: 1998-03-02T07:55:47Z
Lists: pgsql-hackers 
Billy G. Allie wrote:
> 
> I encountered a problem (bug? feature?) where "select currval('sequence')"
> will generate an error if "select nextval('sequence')" is not executed first.
> The attached patch will change this behaviour by reading the sequence tuple
> and returning the last_value attribute if nextval has not been called on the
> sequence yet.

This is feature :)
1. This is what Oracle does.
2. currval () is described as returning value returned by
   last nextval() in _session_.

Vadim