Re: [Postgres-xc-developers] In XC, SQL functions cannot contain utility statements

[David E. W. <DA...@JU...>]

On Feb 3, 2014, at 6:20 AM, Koichi Suzuki <koi...@gm...> wrote:

> Good news.   Then this restriction can be resolved in XC-1.3.

Meanwhile, it looks like I can work around it by sticking this in the functions that create or drop temporary objects in EXECUTE statements:

      SET LOCAL enforce_two_phase_commit = off;

Now, if only SAVEPOINTS were supported (we use a lot of exception-handling in functions), we would be set! Is SAVEPOINT support on the road map? I only see it mentioned as unsupported.

https://sourceforge.net/apps/mediawiki/postgres-xc/index.php?title=Roadmap

Thanks,

David