[Postgres-xl-developers] ERROR: Internal subtransactions not supported in Postgres-XL

Krzysztof Nienartowicz Krzysztof.Nienartowicz at unige.ch
Thu Jun 18 02:44:10 PDT 2020


Yes, as written in the error message - exception handling is based on subtransactions support. You could try TBase (XL-fork) as they implemented it, it seems.

> On 16 Jun 2020, at 03:41, 1484597709 <1484597709 at qq.com> wrote:
> 
> CREATE OR REPLACE FUNCTION GETEXCEPTION(v_phone text) RETURNS void AS
> $$
> BEGIN
>     IF v_phone = 'iphone' THEN
>        RAISE EXCEPTION 'aaaa';
>     ELSIF  v_phone = 'samsung' THEN 
>        RAISE EXCEPTION 'bbbbbbb
>     else
>        RETURN;   
>     END IF;
>     EXCEPTION
>     WHEN others THEN   
>     RAISE EXCEPTION '(%)', SQLERRM;
> END
> $$ LANGUAGE PLPGSQL;
> 
> CONTEXT: PL/pgSQL function getexception(text) line 2 during statement block entry SQL state: XX000
> _______________________________________________
> Postgres-xl-developers mailing list
> Postgres-xl-developers at lists.postgres-xl.org
> http://lists.postgres-xl.org/listinfo.cgi/postgres-xl-developers-postgres-xl.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/pipermail/postgres-xl-developers-postgres-xl.org/attachments/20200618/27158d5e/attachment.html>


More information about the Postgres-xl-developers mailing list