Re: lastval()

From: Alvaro Herrera <alvherre(at)surnet(dot)cl>
To: John Hansen <john(at)geeknet(dot)com(dot)au>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, 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 20:35:48
Message-ID: 20050511203548.GA10281@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

On Thu, May 12, 2005 at 04:58:54AM +1000, John Hansen wrote:
> Alvaro Herrera wrote:

> > Actually, having it throw an error would be helpful, because
> > then you can find in the application which calls should be
> > replaced by the generic runquery() that has to return nothing
> > versus the one that has to return a sequence value. So
> > porting is a little more involved but more useful in the end.
>
> Indeed, but my point was that often it is going in the too hard basket.
> Not that I disagree, but how do you predetermine which queries would
> throw an error if they're built dynamically?

Hmm, if your app can build any of them at an arbitrary point, you have a
rather serious problem, I'd say. The apps I've seen build either kind
at each call site of such runquery().

--
Alvaro Herrera (<alvherre[a]surnet.cl>)
"La fuerza no está en los medios físicos
sino que reside en una voluntad indomable" (Gandhi)

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2005-05-11 20:51:08 Re: [HACKERS] plperl and pltcl installcheck targets
Previous Message Andrew Dunstan 2005-05-11 20:29:17 Re: [HACKERS] plperl and pltcl installcheck targets