Re: [SQL] rules

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Jie Liang <jie(at)stbernard(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, postgres-list <pgsql-admin(at)postgresql(dot)org>, pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] rules
Date: 2004-05-19 17:50:34
Message-ID: 20040519104830.J85664@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

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?

In response to

  • rules at 2004-05-19 17:20:18 from Jie Liang

Responses

  • Re: rules at 2004-06-25 07:16:58 from Jan Norman Pedersen

Browse pgsql-admin by date

  From Date Subject
Next Message admin 2004-05-19 20:11:25 postgresql not using enough memory?
Previous Message Jie Liang 2004-05-19 17:41:57 Re: rules

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas 2004-05-20 00:33:34 where to start with this procedure ?
Previous Message Jie Liang 2004-05-19 17:41:57 Re: rules