Re: Segmentation fault in pg_dumpall from master down to 9.1 and other bug introduced by RLS

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Segmentation fault in pg_dumpall from master down to 9.1 and other bug introduced by RLS
Дата
Msg-id 21764.1415917312@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Segmentation fault in pg_dumpall from master down to 9.1 and other bug introduced by RLS  (Gilles Darold <gilles.darold@dalibo.com>)
Ответы Re: Segmentation fault in pg_dumpall from master down to 9.1 and other bug introduced by RLS  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-hackers
Gilles Darold <gilles.darold@dalibo.com> writes:
> In the same query there is another bug introduced by commit 491c029
> that add Row-Level Security Policies.  Current master code has a broken
> pg_dumpall when trying to dump from a backend lower than 8.1.

Actually, I think that code is not just under-tested but poorly thought
out.  It will dump ALL roles from a pre-9.5 database with NOBYPASSRLS;
even superusers.  I would think that existing superusers ought to be
assumed to have the BYPASSRLS property, no?  (This assumes that the
property means anything at all for superusers, which maybe it doesn't;
but if so we probably ought to be forcing it true for superusers to
avoid confusion.)
        regards, tom lane



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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Inconsistencies in documentation of row-level locking
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Segmentation fault in pg_dumpall from master down to 9.1 and other bug introduced by RLS