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