Re: Deleting a rule? - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Deleting a rule?
Date
Msg-id 20050618041511.GA4989@wolff.to
Whole thread Raw
In response to Deleting a rule?  (Benjamin Smith <lists@benjamindsmith.com>)
List pgsql-general
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 ]

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Deleting a rule?
Next
From: Jeffery Reedy
Date:
Subject: Replication