Re: rules - Mailing list pgsql-sql

From Jan Norman Pedersen
Subject Re: rules
Date
Msg-id 40dbd135$0$223$edfadb0f@dread11.news.tele.dk
Whole thread Raw
In response to rules  ("Jie Liang" <jie@stbernard.com>)
List pgsql-sql
Anslag

"Stephan Szabo" <sszabo@megazone.bigpanda.com> wrote in message
news:20040519104830.J85664@megazone.bigpanda.com...
> On Wed, 19 May 2004, Jie Liang wrote:
>
> > According to the document of rule:
> >
> > CREATE RULE rulename AS ON delete TO mytablename DO
> > (
> > delete from aaa where id=OLD.id;
> > Delete from bbb where id=OLD.id;
> > Delete from ccc where id=OLD.id
> > );
> >
> >
> > Should work, but it doesn't, what wrong with it?
>
> What is it doing and what version is this on?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>




pgsql-sql by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Queries across multiple database
Next
From: Kenneth Gonsalves
Date:
Subject: Re: finding if a foreign key is in use