Re: [subxacts] Aborting a function

> create function crashme2() returns int strict language plpgsql as '
> begin
> subbegin;
> select foo; -- aborts the transaction
> -- did not close the subxact
> end;';

I'm not sure I follow. Are you saying that the following code or
something similar will never work?

create function insertOrUpdateTabX(int, text) returns as '
BEGIN
SUBBEGIN;
INSERT INTO tab (key, col) VALUES ($1, $2);

GET DIAGNOSTICS status = SQLSTATE;
IF (status != 000000) THEN
-- Got an error, determine what it is
SUBABORT;

IF (status = 23505) THEN
-- This entry already exists. Update the value instead
UPDATE tab SET col = $2 WHERE key = $1;
ELSE
RAISE EXCEPTION ''Unrecoverable error'';
END IF
ELSE
SUBCOMMIT:
END IF;

END;
' language plpgsql;