Re: lastval() - Mailing list pgsql-patches

From John Hansen
Subject Re: lastval()
Date
Msg-id 5066E5A966339E42AA04BA10BA706AE50A9335@rodrick.geeknet.com.au
Whole thread Raw
In response to lastval()  (Dennis Bjorklund <db@zigo.dhs.org>)
List pgsql-patches
Yes please...

... That's exactly what I've been asking for....

> -----Original Message-----
> From: pgsql-patches-owner@postgresql.org
> [mailto:pgsql-patches-owner@postgresql.org] On Behalf Of Neil Conway
> Sent: Monday, June 06, 2005 12:18 PM
> To: Dennis Bjorklund
> Cc: pgsql-patches@postgresql.org
> Subject: Re: [PATCHES] lastval()
>
> If you're busy, I can clean this up and apply it.
>
> I wonder if it would be better to have lastval() return the
> last value returned by nextval() or setval() for the current
> session, regardless of any intervening DROP SEQUENCE
> commands. This would simplify the implementation (we can just
> store the int8 value produced by the last
> nextval() / setval() rather than a pointer to the sequence
> object itself), although it is debatable whether this
> behavior is more logical or not. Comments?
>
> -Neil
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>
>

pgsql-patches by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: SQLSTATE again
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: lastval()