I have written a 'before insert' trigger using a similar technique to
that described in section 5.11.3 of :
https://www.postgresql.org/docs/14/ddl-partitioning.html#DDL-PARTITIONING-USING-INHERITANCE
However my trigger queries to see if the partition table exists,
creates it if it doesn't then ins
Ted Toth writes:
> I'm dynamically creating tables that inherit from another table but
> they don't inherit the access privileges. Is there a way to have the
> new tables inherit their parent tables access privileges?
No, but do you need that? When accessing the parent table, there's
no need for