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

Cannot use all four trigger events at once

From: Greg Sabino Mullane <greg(at)turnstep(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Cannot use all four trigger events at once
Date: 2009-06-17 20:22:51
Message-ID: 4A39509B.6060803@turnstep.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
This was failing:

CREATE TRIGGER foo
AFTER INSERT OR UPDATE OR DELETE OR TRUNCATE
ON foobar
FOR EACH STATEMENT EXECUTE PROCEDURE baz();

Turns out the parser wasn't set up to handle four different trigger
event types. Patch attached.

-- 
Greg Sabino Mullane greg(at)endpoint(dot)com  greg(at)turnstep(dot)com
End Point Corporation 610-983-9073
PGP Key: 0x14964AC8 200906171620
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

Responses

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2009-06-17 21:16:24
Subject: Re: Named transaction
Previous:From: Andrew DunstanDate: 2009-06-17 19:51:02
Subject: Re: Named transaction

pgsql-bugs by date

Next:From: Tom LaneDate: 2009-06-17 22:50:30
Subject: Re: [HACKERS] Cannot use all four trigger events at once
Previous:From: Tom LaneDate: 2009-06-16 15:50:25
Subject: Re: BUG #4854: Problems with replaying WAL files on Warm Standby

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