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

triggers on prepare, commit, rollback... ?

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Subject: triggers on prepare, commit, rollback... ?
Date: 2008-05-19 09:42:24
Message-ID: alpine.DEB.1.10.0805191128180.5593@briare.cri.ensmp.fr (view raw or flat)
Thread:
Lists: pgsql-hackers
Dear pgdev,

I've played with triggers a bit, and I have noticed that there seem to be 
no way to add a trigger on events such as "prepare", "commit", "rollback", 
"savepoint", if I'm not mistaken. Also, possible interesting events could 
be "create", "alter" and so, but it may already be possible to catch these 
by having a trigger on "pg_class" or the like.

It seems to me that such triggers would be useful to help implement a 
"simple" (hmmm...) synchroneous replication system, possibly by extending 
or modifying slony, or for advance logging.

Is there any special semantical issue for providing them in pg, or is it 
just the matter of implementing the parser, bookkeeping, callbacks... but 
with no other special "intrinsic" difficulty?

Thanks in advance,

-- 
Fabien.

Responses

pgsql-hackers by date

Next:From: Zoltan BoszormenyiDate: 2008-05-19 09:56:17
Subject: Re: [HACKERS] WITH RECURSIVE patch V0.1
Previous:From: Zoltan BoszormenyiDate: 2008-05-19 09:15:02
Subject: Re: [HACKERS] WITH RECURSIVE patch V0.1

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