Edmundo Robles <edmu...@sw-argos.com> writes: > 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?
This seems really dangerous. You're certainly missing the pg_depend linkages, not to mention attribute inheritance counts in pg_attribute, and there may be other things I'm not remembering offhand. Why can't you use the normal ALTER TABLE approach? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general