Re: alter user/role CURRENT_USER

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: alter user/role CURRENT_USER
Дата
Msg-id
9875.1414702785@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
alter user/role CURRENT_USER Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: alter user/role CURRENT_USER Rushabh Lathia <rushabh.lathia@gmail.com>
Re: alter user/role CURRENT_USER Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: alter user/role CURRENT_USER "Brightwell, Adam" <adam.brightwell@crunchydatasolutions.com>
Re: alter user/role CURRENT_USER Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: alter user/role CURRENT_USER Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: alter user/role CURRENT_USER Marti Raudsepp <marti@juffo.org>
Re: alter user/role CURRENT_USER David G Johnston <david.g.johnston@gmail.com>
Re: alter user/role CURRENT_USER Alvaro Herrera <alvherre@2ndquadrant.com>
Re: alter user/role CURRENT_USER Adam Brightwell <adam.brightwell@crunchydatasolutions.com>
Re: alter user/role CURRENT_USER Stephen Frost <sfrost@snowman.net>
Re: alter user/role CURRENT_USER Kevin Grittner <kgrittn@ymail.com>
Re: alter user/role CURRENT_USER Stephen Frost <sfrost@snowman.net>
Re: alter user/role CURRENT_USER Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: alter user/role CURRENT_USER Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: alter user/role CURRENT_USER Adam Brightwell <adam.brightwell@crunchydatasolutions.com>
Re: alter user/role CURRENT_USER Tom Lane <tgl@sss.pgh.pa.us>
Re: alter user/role CURRENT_USER Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: alter user/role CURRENT_USER Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: alter user/role CURRENT_USER Alvaro Herrera <alvherre@2ndquadrant.com>
Re: alter user/role CURRENT_USER Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: alter user/role CURRENT_USER Alvaro Herrera <alvherre@2ndquadrant.com>
Re: alter user/role CURRENT_USER Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: alter user/role CURRENT_USER Alvaro Herrera <alvherre@2ndquadrant.com>
Re: alter user/role CURRENT_USER Alvaro Herrera <alvherre@2ndquadrant.com>
Re: alter user/role CURRENT_USER Alvaro Herrera <alvherre@2ndquadrant.com>
Re: alter user/role CURRENT_USER Alvaro Herrera <alvherre@2ndquadrant.com>
Re: alter user/role CURRENT_USER Alvaro Herrera <alvherre@2ndquadrant.com>
Re: alter user/role CURRENT_USER Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: alter user/role CURRENT_USER Alvaro Herrera <alvherre@2ndquadrant.com>
Re: alter user/role CURRENT_USER Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: alter user/role CURRENT_USER Michael Paquier <michael.paquier@gmail.com>
Re: alter user/role CURRENT_USER Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: alter user/role CURRENT_USER Stephen Frost <sfrost@snowman.net>
Re: alter user/role CURRENT_USER Tom Lane <tgl@sss.pgh.pa.us>
Re: alter user/role CURRENT_USER Adam Brightwell <adam.brightwell@crunchydatasolutions.com>
Re: alter user/role CURRENT_USER Robert Haas <robertmhaas@gmail.com>
Re: alter user/role CURRENT_USER Rushabh Lathia <rushabh.lathia@gmail.com>
Re: alter user/role CURRENT_USER Adam Brightwell <adam.brightwell@crunchydatasolutions.com>
Stephen Frost  writes:
> The other idea which comes to mind is- could we try to actually resolve
> what the 'right' answer is here, instead of setting a special value and
> then having to detect and fix it later?

No, absolutely not.  Read the NOTES at the head of gram.y.  Or if you
need it spelled out: when we run the bison parser, we may not be inside a
transaction at all, and even if we are, we aren't necessarily going to
be seeing the same current user that will apply when the parsetree is
ultimately executed.  (Consider a query inside a plpgsql function, which
might be called under multiple userids over the course of a session.)

I think Alvaro's suggestion is a perfectly appropriate solution.
		regards, tom lane


В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Tom Lane
Дата:
FAQ