From:
Andres Freund <andres(at)anarazel(dot)de>
To:
pgsql-hackers(at)postgresql(dot)org
Cc:
Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>,
Dave Page <dpage(at)pgadmin(dot)org>,
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,
Robert Haas <robertmhaas(at)gmail(dot)com>,
Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
Subject:
Re: Application name patch - v4
Date:
2009-12-01 09:22:13
Message-ID:
200912011022.14098.andres@anarazel.de (view raw or flat )
Thread:
2009-11-26 15:50:15 from Dave Page <dpage(at)pgadmin(dot)org>
2009-11-28 23:47:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-11-29 00:27:14 from Joshua Tolley <eggyknap(at)gmail(dot)com>
2009-11-29 01:34:16 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-11-29 00:51:21 from Andres Freund <andres(at)anarazel(dot)de>
2009-11-29 17:00:54 from Dave Page <dpage(at)pgadmin(dot)org>
2009-11-29 17:22:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-11-29 20:03:24 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2009-11-29 23:25:29 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-11-30 00:16:43 from "Florian G(dot) Pflug" <fgp(at)phlo(dot)org>
2009-11-30 07:20:46 from Andres Freund <andres(at)anarazel(dot)de>
2009-11-30 21:11:11 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2009-11-30 21:38:30 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-11-30 21:54:54 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2009-11-30 22:06:12 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-11-30 23:59:09 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-01 00:11:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-01 00:26:32 from Andres Freund <andres(at)anarazel(dot)de>
2009-12-01 08:59:17 from Dave Page <dpage(at)pgadmin(dot)org>
2009-12-01 09:11:49 from Andres Freund <andres(at)anarazel(dot)de>
2009-12-01 09:16:45 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2009-12-01 09:18:39 from Dave Page <dpage(at)pgadmin(dot)org>
2009-12-01 16:19:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-01 16:23:59 from Dave Page <dpage(at)pgadmin(dot)org>
2009-12-01 16:28:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-01 16:33:54 from Dave Page <dpage(at)pgadmin(dot)org>
2009-12-01 16:52:31 from Marko Kreen <markokr(at)gmail(dot)com>
2009-12-01 18:25:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-01 20:07:06 from Marko Kreen <markokr(at)gmail(dot)com>
2009-12-01 20:18:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-01 21:08:06 from Marko Kreen <markokr(at)gmail(dot)com>
2009-12-01 21:20:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-01 21:30:53 from Marko Kreen <markokr(at)gmail(dot)com>
2009-12-02 05:09:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-02 08:14:47 from Magnus Hagander <magnus(at)hagander(dot)net>
2009-12-02 08:34:25 from Dave Page <dpage(at)pgadmin(dot)org>
2009-12-02 15:19:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-01 09:22:13 from Andres Freund <andres(at)anarazel(dot)de>
2009-12-01 10:46:15 from Marko Kreen <markokr(at)gmail(dot)com>
2009-12-01 11:54:03 from Brar Piening <brar(at)gmx(dot)de>
2009-12-01 08:13:58 from Marko Kreen <markokr(at)gmail(dot)com>
2009-12-01 09:30:03 from Tatsuo Ishii <ishii(at)postgresql(dot)org>
2009-11-30 01:01:55 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2009-11-30 01:20:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-11-30 02:21:59 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2009-11-30 03:20:53 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Lists:
pgsql-hackers
On Tuesday 01 December 2009 10:16:45 Heikki Linnakangas wrote:
> Dave Page wrote:
> > Upthread, Tom suggested a new 'SET DEFAULT ...' variant of SET which
> > could be used to set the default GUC value that RESET would revert to.
> > This seems to me to be the ideal solution, and I'd somewhat hesitantly
> > volunteer to work on it (hesitantly as it means touching the parser
> > and other areas of the code I currently have no experience of).
>
> If an application can do SET DEFAULT, how does the connection pooler
> *really* reset the value back to what it was?
Why does it need to? SET DEFAULT should imho only be allowed for values whcih
can be set during connection initiation. For those it can simply issue the
sets anyway.
Andres
In response to
pgsql-hackers by date
Next :From: Tatsuo IshiiDate: 2009-12-01 09:30:03Subject : Re: Application name patch - v4 Previous :From : Dave PageDate : 2009-12-01 09:18:39Subject : Re: Application name patch - v4
