On 9/28/09, Josh Berkus <j...@agliodbs.com> wrote > > > I already mentioned one case that there's longstanding demand for, which > > is to instantiate the correct permissions on new partition child tables. > > Wouldn't that be handled by inheritance?
I wish, but no: http://www.postgresql.org/docs/current/interactive/ddl-inherit.html The first paragraph under "5.8.1 Caveats": Table access permissions are not automatically inherited. Therefore, a user attempting to access a parent table must either have permissions to do the same operation on all its child tables as well, or must use the ONLYnotation. When adding a new child table to an existing inheritance hierarchy, be careful to grant all the needed permissions on it.
