Postgres Pro
Downloads
Home   >   mailing lists

Re: DROP RULE ... CASCADE - Mailing list pgsql-sql

From Tom Lane
Subject Re: DROP RULE ... CASCADE
Date
Msg-id 8189.1268749487@sss.pgh.pa.us
Whole thread Raw
In response to DROP RULE ... CASCADE  (Dmitriy Igrishin <dmitigr@gmail.com>)
List pgsql-sql
Tree view 
Dmitriy Igrishin <dmitigr@gmail.com> writes:
> What objects may depend on the rule (and which of them will removed via
> cascade rule deletion)?

At present I don't think that a rule can have any dependent objects.
The CASCADE option is there for symmetry and future-proofing.
(The same goes for some other types of objects, too.)
        regards, tom lane

pgsql-sql by date:

Previous
From: Dmitriy Igrishin
Date:
Subject: SQL code beautifier for PostgreSQL.
Next
From: Niklas Johansson
Date:
Subject: Re: I, nead to capture the IP number from the PC how is running the script ...