| From: | Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql: Teach RemoveRoleFromObjectPolicy() about partitioned tables. |
| Date: | 2017-06-14 07:45:03 |
| Message-ID: | E1dL2z9-0002cS-QI@gemulon.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Teach RemoveRoleFromObjectPolicy() about partitioned tables.
Table partitioning, introduced in commit f0e44751d7, added a new
relkind - RELKIND_PARTITIONED_TABLE. Update
RemoveRoleFromObjectPolicy() to handle it, otherwise DROP OWNED BY
will fail if the role has any RLS policies referring to partitioned
tables.
Dean Rasheed, reviewed by Amit Langote.
Discussion: https://postgr.es/m/CAEZATCUnNOKN8sLML9jUzxecALWpEXK3a3W7y0PgFR4%2Buhgc%3Dg%40mail.gmail.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/f356ec57444e42e53474ad5a029cdf6dca195069
Modified Files
--------------
src/backend/commands/policy.c | 3 ++-
src/test/regress/expected/rowsecurity.out | 4 ++++
src/test/regress/sql/rowsecurity.sql | 5 +++++
3 files changed, 11 insertions(+), 1 deletion(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dean Rasheed | 2017-06-14 08:01:15 | pgsql: Teach PL/pgSQL about partitioned tables. |
| Previous Message | Tom Lane | 2017-06-14 03:46:49 | pgsql: Disallow set-returning functions inside CASE or COALESCE. |