Dear Tom,

 trigger on "prepare", "commit", "rollback", "savepoint",
Yup, and there won't be.

That's a definite answer!

This has been suggested and rejected before. See the archives.

I'll check into that.

It seems to me that such triggers would be useful to help implement a "simple" (hmmm...) synchroneous replication system,

That argument has no credibility whatever.

If you say so.

We have not even been able to get the replication projects to agree on a common set of custom hooks; the chance that they could get by with triggers on SQL-visible events is nil.

That is indeed an issue.

On the other hand, there are several possible strategies to implement replication, but ISTM that all should require a hook (whether SQL visible or not) at the prepare/commit levels to play around with the 2PC.

Well, thanks for your answer anyway,

--
Fabien.

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to