[Postgres-xl-general] Exceptions constitute internal subtransaction
Aaron Jackson
ajackson at revionics.com
Wed Nov 19 11:10:27 PST 2014
They are probably right that it is less pressing in the short-term.
Still, I think there is a broader conversation that I need to have with my executive sponsors around our investment into PGXL development. Our executive team is currently in a monthly meeting but I will try to queue that conversation up with our CTO next week.
Aaron
________________________________
From: Aaron Jackson
Sent: Monday, November 17, 2014 3:49 PM
To: postgres-xl-general at lists.sourceforge.net
Subject: Exceptions constitute internal subtransaction
Got an error today that made me question whether I should use PLPGSQL for a procedure I wanted to provide. Suffice it to say the function had the following form...
CREATE OR REPLACE FUNCTION foo( params int )
RETURNS VOID AS
$$
DECLARE
... stuff ...
BEGIN
EXCEPTION WHEN OTHERS THEN
END;
$$ LANGUAGE plpgsql
So, this is consumed fine into PGXL, but fails during execution with the following error.
ERROR: Internal subtransactions not supported in Postgres-XL
What I've discovered is that the use of the exception block seems to trigger the error. Does this behavior extend to other language implementations as well? Asking because presumably, languages are trapping the exception in their runtime in a manner that is a little more agnostic??
Aaron
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/pipermail/postgres-xl-general-postgres-xl.org/attachments/20141119/65716ed0/attachment.htm>
More information about the postgres-xl-general
mailing list