From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Robert Haas <robertmhaas(at)gmail(dot)com>
Cc:
Amit kapila <amit(dot)kapila(at)huawei(dot)com>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>,
"pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>,
Dimitri Fontaine <dimitri(at)2ndquadrant(dot)fr>,
"cedric(at)2ndquadrant(dot)com" <cedric(at)2ndquadrant(dot)com>,
Greg Smith <greg(at)2ndquadrant(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>,
Magnus Hagander <magnus(at)hagander(dot)net>,
Christopher Browne <cbbrowne(at)gmail(dot)com>,
Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Subject:
Re: Proposal for Allow postgresql.conf values to be changed via SQL
Date:
2012-11-30 19:59:33
Message-ID:
22694.1354305573@sss.pgh.pa.us (view raw or flat )
Thread:
2012-10-29 13:40:56 from Chris Corbyn <chris(at)w3style(dot)co(dot)uk>
2012-10-29 14:14:27 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-10-30 22:02:25 from Hannu Krosing <hannu(at)2ndQuadrant(dot)com>
2012-10-31 04:02:35 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-10-30 21:25:23 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-10-30 21:47:34 from Christopher Browne <cbbrowne(at)gmail(dot)com>
2012-10-30 21:54:57 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-10-30 22:24:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-10-30 22:28:18 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-10-31 03:39:34 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-10-31 16:51:56 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-11-01 04:00:05 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-02 16:00:11 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2012-10-30 22:43:40 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-10-31 03:33:39 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-10-31 12:17:53 from Magnus Hagander <magnus(at)hagander(dot)net>
2012-11-01 07:35:04 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-02 01:19:51 from Greg Smith <greg(at)2ndQuadrant(dot)com>
2012-11-02 11:17:40 from Magnus Hagander <magnus(at)hagander(dot)net>
2012-11-07 23:54:15 from Greg Smith <greg(at)2ndQuadrant(dot)com>
2012-11-08 14:53:10 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-02 15:34:18 from Greg Stark <stark(at)mit(dot)edu>
2012-11-03 01:38:49 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-11-06 11:26:36 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-06 18:00:06 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-11-07 04:19:06 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-07 15:23:42 from Magnus Hagander <magnus(at)hagander(dot)net>
2012-11-07 16:53:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-07 17:09:46 from Magnus Hagander <magnus(at)hagander(dot)net>
2012-11-07 17:19:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-07 17:24:23 from Magnus Hagander <magnus(at)hagander(dot)net>
2012-11-07 17:29:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-07 18:47:54 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-11-07 18:58:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-07 19:50:14 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-11-07 20:15:07 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-11-07 20:29:36 from Andres Freund <andres(at)2ndquadrant(dot)com>
2012-11-08 14:26:27 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-08 14:36:32 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2012-11-08 15:01:29 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-08 15:18:07 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2012-11-10 04:59:19 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-12 06:37:55 from Greg Smith <greg(at)2ndQuadrant(dot)com>
2012-11-12 14:17:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-13 03:59:57 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-13 18:13:08 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-11-13 18:16:11 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-13 18:45:16 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-11-14 06:24:33 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-13 18:54:45 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-11-14 05:09:53 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-15 14:48:14 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-15 17:58:06 from Cédric Villemain <cedric(at)2ndquadrant(dot)com>
2012-11-16 06:16:09 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-16 08:24:38 from Cédric Villemain <cedric(at)2ndquadrant(dot)com>
2012-11-16 09:58:06 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-16 14:08:30 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-16 14:22:22 from Cédric Villemain <cedric(at)2ndquadrant(dot)com>
2012-11-17 13:25:34 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-17 21:38:03 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-11-17 21:57:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-18 09:52:24 from Cédric Villemain <cedric(at)2ndquadrant(dot)com>
2012-11-19 07:04:27 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-19 07:01:00 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-19 14:22:31 from Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
2012-11-19 14:46:55 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-19 15:05:56 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2012-11-19 15:36:58 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-20 13:51:28 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-22 12:38:42 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-22 16:39:26 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-11-23 09:56:56 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-23 16:40:54 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2012-11-24 05:10:45 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-24 17:26:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-25 05:01:12 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-28 14:47:44 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-30 19:39:17 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-11-30 19:59:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-12-01 08:09:04 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-12-01 16:30:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-12-01 16:45:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-12-02 05:48:25 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-12-03 15:19:41 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-12-03 15:28:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-12-04 03:07:00 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-12-06 04:42:31 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-12-04 03:22:44 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-12-02 05:19:34 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-12-03 11:38:17 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-12-03 15:21:12 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-12-03 15:32:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-12-03 15:41:21 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2012-12-10 23:54:58 from Jaime Casanova <jaime(at)2ndquadrant(dot)com>
2012-12-11 10:47:54 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-12-11 15:21:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-11-19 05:38:32 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-14 15:11:16 from Amit kapila <amit(dot)kapila(at)huawei(dot)com>
2012-11-08 14:50:59 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-10-31 09:07:11 from Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
2012-10-30 22:10:41 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Lists:
pgsql-hackers
Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> On Wed, Nov 28, 2012 at 9:47 AM, Amit kapila <amit(dot)kapila(at)huawei(dot)com> wrote:
>> 5. PERSISTENT Keyword is added to the reserved keyword list. As it was giving some errors given below while parsing gram.y
>> 15 shift/reduce conflicts .
> Allow me to be the first to say that any syntax for this feature that
> involves reserving new keywords is a bad syntax.
Let me put that a little more strongly: syntax that requires reserving
words that aren't reserved in the SQL standard is unacceptable.
Even if the new word is reserved according to SQL, we'll frequently
try pretty hard to avoid making it reserved in Postgres, so as not to
break existing applications. But if it's not in the standard then
you're breaking applications that can reasonably expect not to get
broken.
But having said that, it's not apparent to me why inventing SET
PERSISTENT should require reserving PERSISTENT. In the existing
syntaxes SET LOCAL and SET SESSION, there's not been a need to
reserve LOCAL or SESSION. Maybe you're just trying to be a bit
too cute in the grammar productions? Frequently there's more than
one way to do it and not all require the same level of keyword
reservedness.
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Robert HaasDate: 2012-11-30 20:03:21Subject : Re: Enabling frontend-only xlog "desc" routinesPrevious :From : Bruce MomjianDate : 2012-11-30 19:50:40Subject : Re: initdb.c::main() too large
