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

Re: lastval()

From: "John Hansen" <john(at)geeknet(dot)com(dot)au>
To: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: "Neil Conway" <neilc(at)samurai(dot)com>,"Dennis Bjorklund" <db(at)zigo(dot)dhs(dot)org>, <pgsql-patches(at)postgresql(dot)org>
Subject: Re: lastval()
Date: 2005-05-11 03:39:40
Message-ID: 5066E5A966339E42AA04BA10BA706AE50A931C@rodrick.geeknet.com.au (view raw or flat)
Thread:
Lists: pgsql-patches
Bruce Momjian wrote:
> Sent: Wednesday, May 11, 2005 1:27 PM
> To: John Hansen
> Cc: Neil Conway; Dennis Bjorklund; pgsql-patches(at)postgresql(dot)org
> Subject: Re: [PATCHES] lastval()
> 
> John Hansen wrote:
> > Neil Conway wrote:
> > > Sent: Wednesday, May 11, 2005 10:56 AM
> > > To: Dennis Bjorklund
> > > Cc: pgsql-patches(at)postgresql(dot)org
> > > Subject: Re: [PATCHES] lastval()
> > > 
> > > Dennis Bjorklund wrote:
> > > > Here is a small patch that implements a function lastval()
> > > that works
> > > > just like currval() except that it give the current value
> > > of the last
> > > > sequence used by nextval().
> > > 
> > > What do people think of this idea? (Tom seems opposed, I'm just 
> > > wondering if there are other opinions out there.)
> > 
> > I'm all for it. Even more so if the 'currval(void) called before 
> > nextval(seq_name)' error message could be supressed by a 
> GUC variable 
> > and return 0 instead.
> 
> Why zero and no error?

That's the exact behaviour of the "other database's" equivalent.
Makes porting easier, and avoids hugely annoying error messages in the
logfiles.

> 
> -- 
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
>   +  If your life is a hard drive,     |  13 Roberts Road
>   +  Christ can be your backup.        |  Newtown Square, 
> Pennsylvania 19073
> 
> 

Responses

pgsql-patches by date

Next:From: Bruce MomjianDate: 2005-05-11 03:44:38
Subject: Re: lastval()
Previous:From: Abhijit Menon-SenDate: 2005-05-11 03:35:45
Subject: Re: lastval()

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