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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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