On Mon, 2009-10-05 at 11:45 +0100, Simon Riggs wrote: > On Mon, 2009-10-05 at 13:06 +0300, Peter Eisentraut wrote: > > On Mon, 2009-10-05 at 10:47 +0100, Simon Riggs wrote: > > > top level: data-template > > > main tables: data, data-recent both inherit from data-template > > > all partitions inherit from data > > > only recent partitions inherit from data-recent > > > grants are issued on data and data-recent > > > > I don't see where the problem is here. > > In your last post you said it was necessary to use ONLY to address the > required partitions and so setup would be weird. I am showing that this > is not required and the setup is smooth.
Well, you posted this: top level: data-template main tables: data, data-recent both inherit from data-template all partitions inherit from data only recent partitions inherit from data-recent grants are issued on data and data-recent But this is too vague for me to make out who can read what and what would change under the proposed change and why that would be a problem. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers