From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
---|---|
To: | Michael Paquier <michael(at)paquier(dot)xyz> |
Cc: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: propagating replica identity to partitions |
Date: | 2019-03-28 17:10:23 |
Message-ID: | CANP8+j+M1rdKW7AYowPsNfPb7z3JQsqG8CcS3-LhWF=55jAqpw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Sat, 23 Mar 2019 at 01:34, Michael Paquier <michael(at)paquier(dot)xyz> wrote:
> I'm slightly baffled that we would even allow having different owners on
> > different partitions, but that seems to be a separate discussion.
>
> Different owners can make sense for multiple layers of partitions
> where the children have less restrictions than the children. Imagine
> for example a table listing the population of a country, with children
> partitioned by regions, and grand-children partitioned by cities. The
> top-most parent could be owned by a minister, and lower levels apply
> to the region administrator, down to the city administrators.
>
That use case is possible using different privileges.
Having different owners makes it *very* difficult to administer.
--
Simon Riggs http://www.2ndQuadrant.com/
<http://www.2ndquadrant.com/>
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2019-03-28 17:16:11 | Re: propagating replica identity to partitions |
Previous Message | Andrey Borodin | 2019-03-28 17:08:29 | Re: amcheck verification for GiST |