Edmundo Robles <edmundo@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general