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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers