Re: [PATCHES] Changes to sequence.c - Mailing list pgsql-hackers

From Vadim B. Mikheev
Subject Re: [PATCHES] Changes to sequence.c
Date
Msg-id 34FA6603.CE3EB1BC@sable.krasnoyarsk.su
Whole thread Raw
In response to Changes to sequence.c  ("Billy G. Allie" <Bill.Allie@mug.org>)
Responses Re: [HACKERS] Re: [PATCHES] Changes to sequence.c  ("Billy G. Allie" <Bill.Allie@mug.org>)
List 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

pgsql-hackers by date:

Previous
From: Brook Milligan
Date:
Subject: SOLUTION: undefined symbols in libpgtcl.so
Next
From: Tom I Helbekkmo
Date:
Subject: Re: [HACKERS] configure.in patch for --with-tcl