Re: Segmentation fault in pg_dumpall from master down to 9.1 and other bug introduced by RLS - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Segmentation fault in pg_dumpall from master down to 9.1 and other bug introduced by RLS
Date
Msg-id 21764.1415917312@sss.pgh.pa.us
Whole thread Raw
In response to Segmentation fault in pg_dumpall from master down to 9.1 and other bug introduced by RLS  (Gilles Darold <gilles.darold@dalibo.com>)
Responses Re: Segmentation fault in pg_dumpall from master down to 9.1 and other bug introduced by RLS  (Stephen Frost <sfrost@snowman.net>)
List 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 by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Inconsistencies in documentation of row-level locking
Next
From: Stephen Frost
Date:
Subject: Re: Segmentation fault in pg_dumpall from master down to 9.1 and other bug introduced by RLS