Re: alter user/role CURRENT_USER
От
Tom Lane
Тема
Re: alter user/role CURRENT_USER
Дата
Msg-id
9875.1414702785@sss.pgh.pa.us
Ответ на
Re: alter user/role CURRENT_USER (Stephen Frost)
Список
Дерево обсуждения
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 по дате отправления