| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tony Reina | 2004-05-19 17:25:18 | Re: Postgresql ssl mode |
| Previous Message | Jie Liang | 2004-05-19 17:14:18 | rules |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kornelije Rabuzin | 2004-05-19 17:30:18 | Re: Replace function ... |
| Previous Message | Martin Knipper | 2004-05-19 17:09:35 | Re: Function valid only for one table |