| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | multiple action rules |
| Date: | 2005-06-22 23:31:52 |
| Message-ID: | 1119483112.8208.23.camel@state.g2switchworks.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
OK, so I'm trying to make a rule with >1 action.
The docs, not so helpfully, only seem to show a single action rule (at
least in the rules section, not sure about elsewhere) The syntax
diagram:
CREATE RULE rule_name AS ON event
TO object [WHERE rule_qualification]
DO [INSTEAD] [action | (actions) | NOTHING];
seems to imply to me that >2 actions would look like this:
create rule audit_test as on delete to ntest do (
insert into naudit(id,path) values (OLD.id, OLD.path);
notify test;
)
But no matter what flavor of syntax I throw at this, I get:
syntax error at or near "insert" at character xxx
So, what's the magic pixie dust I need to sprinkle on this to make it
work?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2005-06-22 23:45:36 | Re: multiple action rules |
| Previous Message | David Mitchell | 2005-06-22 23:22:21 | Re: Vacuum advice |