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