On Fri, Jun 17, 2005 at 15:27:30 -0700,
Benjamin Smith <lists@benjamindsmith.com> wrote:
> I wrote a rule a while back that, due to the software being extended, now
> needs to be deleted.
>
> How do I drop a rule?
>
> DELETE FROM pg_rules WHERE rulename='foo';
>
> doesn't seem to cut it...
DROP RULE name ON relation [ CASCADE | RESTRICT ]