Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

pgsql-admin by date

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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group