X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP
	id 9E8B1D1B16B; Wed, 19 May 2004 14:50:54 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 33800-02; Wed, 19 May 2004 14:50:35 -0300 (ADT)
Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210])
	by svr1.postgresql.org (Postfix) with ESMTP
	id 1B16ED1B238; Wed, 19 May 2004 14:50:34 -0300 (ADT)
Received: by megazone.bigpanda.com (Postfix, from userid 1001)
	id 19DCF35932; Wed, 19 May 2004 10:50:34 -0700 (PDT)
Received: from localhost (localhost [127.0.0.1])
	by megazone.bigpanda.com (Postfix) with ESMTP
	id 1856235923; Wed, 19 May 2004 10:50:34 -0700 (PDT)
Date: Wed, 19 May 2004 10:50:34 -0700 (PDT)
From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: Jie Liang <jie@stbernard.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>,
	postgres-list <pgsql-admin@postgresql.org>, pgsql-sql@postgresql.org
Subject: Re: [SQL] rules
In-Reply-To: <E7E213858379814A9AE48CA6754F5ECB1E1FC8@mail01.stbernard.com>
Message-ID: <20040519104830.J85664@megazone.bigpanda.com>
References: <E7E213858379814A9AE48CA6754F5ECB1E1FC8@mail01.stbernard.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200405/198
X-Sequence-Number: 13514

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?