Re: [HACKERS] RLS in CTE incorrect permission failure

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] RLS in CTE incorrect permission failure
Дата
Msg-id 22863.1498088811@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [HACKERS] RLS in CTE incorrect permission failure  (Rod Taylor <rod.taylor@gmail.com>)
Ответы Re: [HACKERS] RLS in CTE incorrect permission failure  (Rod Taylor <rod.taylor@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
Rod Taylor <rod.taylor@gmail.com> writes:
> In the attached script, the second insert into t2 (as part of the CTE)
> should succeed.

No, I don't think so.  You declared the check function as STABLE which
means it is confined to seeing the same snapshot as the surrounding query.
So it can't see anything inserted by that query.

Possibly it'd work as you wish with a VOLATILE function.
        regards, tom lane

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [HACKERS] [COMMITTERS] pgsql: Restart logical replication launcher when killed
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] [COMMITTERS] pgsql: Restart logical replicationlauncher when killed