On Wed, Dec 21, 2016 at 3:36 PM, Edmundo Robles <edmundo@sw-argos.com> wrote:
> Hi!
>
> i need disable inheritance from many tables in a query like
>
> "delete from pg_inherits where inhparent=20473" instead alter table ...
>
> but is safe? which is the risk for database if i delete it?
You could change the source query to use the only keyword:
delete from only parenttable where ...
OR you could write a rule or trigger that rewrote the query to have
the only keyword in it under certain circumstances.
