From:
Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
To:
"'Dimitri Fontaine'" <dimitri(at)2ndQuadrant(dot)fr>,
"'Tom Lane'"<tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
"'Peter Eisentraut'" <peter_e(at)gmx(dot)net>,
"'pgsql-hackers'"<pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: another idea for changing global configuration settings from SQL
Date:
2012-11-17 13:28:46
Message-ID:
005301cdc4c7$7954f7c0$6bfee740$@kapila@huawei.com (view raw or flat )
Thread:
2012-11-15 17:53:15 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2012-11-15 18:04:18 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-11-15 18:06:48 from Cédric Villemain <cedric(at)2ndquadrant(dot)com>
2012-11-15 18:38:53 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-11-15 23:31:33 from Craig Ringer <craig(at)2ndQuadrant(dot)com>
2012-11-15 21:31:16 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2012-11-15 22:08:47 from Magnus Hagander <magnus(at)hagander(dot)net>
2012-11-15 22:38:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-16 14:27:07 from Hannu Krosing <hannu(at)krosing(dot)net>
2012-11-16 14:57:14 from Euler Taveira <euler(at)timbira(dot)com>
2012-11-16 17:05:17 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-11-16 19:06:14 from Hannu Krosing <hannu(at)krosing(dot)net>
2012-11-16 19:16:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-16 14:59:35 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2012-11-16 15:26:56 from Euler Taveira <euler(at)timbira(dot)com>
2012-11-16 15:46:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-16 22:05:25 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2012-11-17 13:28:46 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-17 21:23:22 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2013-01-15 13:53:30 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2013-02-12 10:27:55 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Lists:
pgsql-hackers
On Saturday, November 17, 2012 3:35 AM Dimitri Fontaine wrote:
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> > Have you considered ALTER SYSTEM SET ... ? We'd talked about that in
> > the context of the other patch, but it seems to fit much more
> naturally
> > with this one. Or maybe ALTER GLOBAL SET or ALTER ALL SET.
>
> I would paint that one ALTER SYSTEM SET and the file based one ALTER
> CONFIGURATION SET. No new keyword were armed in that proposal.
One more could be to have built-in function
pg_change_config(level,key,value)
level - PG_NEW_CONNECTION
- PG_SYTEM_LEVEL
Level will distinguish how and when the value will be used.
With Regards,
Amit Kapila.
In response to
pgsql-hackers by date
Next :From: Hannu KrosingDate: 2012-11-17 13:30:27Subject : Re: logical changeset generation v3 - comparison to Postgres-R
change set formatPrevious :From : Amit KapilaDate : 2012-11-17 13:25:34Subject : Re: Proposal for Allow postgresql.conf values to be changed via SQL
