multiple action rules

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?

Responses

Browse pgsql-general by date

  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