Re: pg_config wrongly marked as not parallel safe?
От
Joe Conway
Тема
Re: pg_config wrongly marked as not parallel safe?
Дата
Msg-id
ae6446c1-b08a-6e79-8f8e-9269e97f5abb@joeconway.com
Ответ на
Re: pg_config wrongly marked as not parallel safe? (Andres Freund)
Список
Дерево обсуждения
pg_config wrongly marked as not parallel safe? Andres Freund <andres@anarazel.de>
Re: pg_config wrongly marked as not parallel safe? Joe Conway <mail@joeconway.com>
Re: pg_config wrongly marked as not parallel safe? Andres Freund <andres@anarazel.de>
Re: pg_config wrongly marked as not parallel safe? Stephen Frost <sfrost@snowman.net>
Re: pg_config wrongly marked as not parallel safe? Andres Freund <andres@anarazel.de>
Re: pg_config wrongly marked as not parallel safe? Stephen Frost <sfrost@snowman.net>
Re: pg_config wrongly marked as not parallel safe? Andres Freund <andres@anarazel.de>
Re: pg_config wrongly marked as not parallel safe? Stephen Frost <sfrost@snowman.net>
Re: pg_config wrongly marked as not parallel safe? Laurenz Albe <laurenz.albe@cybertec.at>
Re: pg_config wrongly marked as not parallel safe? Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: pg_config wrongly marked as not parallel safe? Stephen Frost <sfrost@snowman.net>
Re: pg_config wrongly marked as not parallel safe? Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: pg_config wrongly marked as not parallel safe? Laurenz Albe <laurenz.albe@cybertec.at>
Re: pg_config wrongly marked as not parallel safe? Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_config wrongly marked as not parallel safe? Stephen Frost <sfrost@snowman.net>
Re: pg_config wrongly marked as not parallel safe? Robert Haas <robertmhaas@gmail.com>
Re: pg_config wrongly marked as not parallel safe? Stephen Frost <sfrost@snowman.net>
Re: pg_config wrongly marked as not parallel safe? Robert Haas <robertmhaas@gmail.com>
Re: pg_config wrongly marked as not parallel safe? Stephen Frost <sfrost@snowman.net>
Re: pg_config wrongly marked as not parallel safe? Robert Haas <robertmhaas@gmail.com>
Re: pg_config wrongly marked as not parallel safe? Stephen Frost <sfrost@snowman.net>
Re: pg_config wrongly marked as not parallel safe? Andres Freund <andres@anarazel.de>
Re: pg_config wrongly marked as not parallel safe? Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: pg_config wrongly marked as not parallel safe? Joe Conway <mail@joeconway.com>
Re: pg_config wrongly marked as not parallel safe? Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_config wrongly marked as not parallel safe? Joe Conway <mail@joeconway.com>
Re: pg_config wrongly marked as not parallel safe? Stephen Frost <sfrost@snowman.net>
Re: pg_config wrongly marked as not parallel safe? Joe Conway <mail@joeconway.com>
Re: pg_config wrongly marked as not parallel safe? Andres Freund <andres@anarazel.de>
On 11/26/18 7:08 PM, Andres Freund wrote: > On 2018-11-26 19:04:46 -0500, Joe Conway wrote: >> Not intentional. Though, sitting here chatting with Stephen about it, I >> am now wondering if pg_config() should actually be marked immutable: >> >> select * from pg_config() where name = 'VERSION'; >> name | setting >> ---------+----------------- >> VERSION | PostgreSQL 10.5 >> (1 row) >> >> [...upgrade the postgres binaries...] >> >> select * from pg_config() where name = 'VERSION'; >> name | setting >> ---------+----------------- >> VERSION | PostgreSQL 10.6 >> (1 row) >> >> So the correct answer is probably to mark pg_config() stable, but it >> still seems to be parallel safe to me. > > I don't think we should consider immutability to mean anything across > major versions. What'd be helped by doing that? We'd have to rule out > any behaviour change to any immutable function for that to make > sense. Including making an immutable function not immutable anymore. Umm, this is a minor version not major. Joe -- Crunchy Data - http://crunchydata.com PostgreSQL Support for Secure Enterprises Consulting, Training, & Open Source Development
В списке pgsql-hackers по дате отправления