pgsql: Fix missing dependency for pg_dump's ENABLE ROW LEVEL SECURITYi - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Fix missing dependency for pg_dump's ENABLE ROW LEVEL SECURITYi
Date
Msg-id E1fuMv9-0004oc-HB@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix missing dependency for pg_dump's ENABLE ROW LEVEL SECURITY items.

The archive should show a dependency on the item's table, but it failed
to include one.  This could cause failures in parallel restore due to
emitting ALTER TABLE ... ENABLE ROW LEVEL SECURITY before restoring
the table's data.  In practice the odds of a problem seem low, since
you would typically need to have set FORCE ROW LEVEL SECURITY as well,
and you'd also need a very high --jobs count to have any chance of this
happening.  That probably explains the lack of field reports.

Still, it's a bug, so back-patch to 9.5 where RLS was introduced.

Discussion: https://postgr.es/m/19784.1535390902@sss.pgh.pa.us

Branch
------
REL_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/c5e235ff8ad0f4907a736a6440dc4be6f939e65c

Modified Files
--------------
src/bin/pg_dump/pg_dump.c | 13 +++++++++----
1 file changed, 9 insertions(+), 4 deletions(-)


pgsql-committers by date:

Previous
From: Peter Eisentraut
Date:
Subject: pgsql: Add some not null constraints to catalogs
Next
From: Peter Eisentraut
Date:
Subject: pgsql: Fix snapshot leak warning for some procedures