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

rules

From: "Jie Liang" <jie(at)stbernard(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "postgres-list" <pgsql-admin(at)postgresql(dot)org>,<pgsql-sql(at)postgresql(dot)org>
Subject: rules
Date: 2004-05-19 17:20:18
Message-ID: E7E213858379814A9AE48CA6754F5ECB1E1FC8@mail01.stbernard.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-sql
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?
Even I use { .... }

Jie Liang

Responses

pgsql-admin by date

Next:From: Tony ReinaDate: 2004-05-19 17:25:18
Subject: Re: Postgresql ssl mode
Previous:From: Jie LiangDate: 2004-05-19 17:14:18
Subject: rules

pgsql-sql by date

Next:From: Kornelije RabuzinDate: 2004-05-19 17:30:18
Subject: Re: Replace function ...
Previous:From: Martin KnipperDate: 2004-05-19 17:09:35
Subject: Re: Function valid only for one table

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