On Fri, Jun 17, 2005 at 15:27:30 -0700, Benjamin Smith <lists@xxxxxxxxxxxxxxxxxx> 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 ] ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
