Re: propagating replica identity to partitions - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: propagating replica identity to partitions
Date
Msg-id CANP8+j+M1rdKW7AYowPsNfPb7z3JQsqG8CcS3-LhWF=55jAqpw@mail.gmail.com
Whole thread Raw
In response to Re: propagating replica identity to partitions  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
On Sat, 23 Mar 2019 at 01:34, Michael Paquier <michael@paquier.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/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-hackers by date:

Previous
From: Andrey Borodin
Date:
Subject: Re: amcheck verification for GiST
Next
From: Simon Riggs
Date:
Subject: Re: propagating replica identity to partitions