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: | Raw Message | Whole Thread | 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 |