On Wed, Dec 21, 2016 at 3:36 PM, Edmundo Robles <edmundo@xxxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
