[Postgres-xc-developers] Savepoints

[Leonard B. <le...@si...>]

Hi all,

We've been eagerly following XC since it's first announcement and are
eager to start testing XC. We had to wait for trigger support, but it
seems our only remaining barrier is no support for savepoints.

I've seen some recent activity on this question and wanted to chime in
with our use-case.

We access Pg from Erlang and use savepoints extensively to implement
update-insert / insert-update (with loop limits) logic within
transactions which require safe modification of other data *prior* to
the insert-update / update-insert.

Yes, we could move all this into db functions, but that would take a
fairly large effort on our part and it makes code management more
complex for us.

Maybe this use-case will bump the feature priority a touch.

Kind regards,
Leonard