Automatically ROLLBACK after fall in *ABORT STATE* - Mailing list pgsql-hackers

From hstenger@adinet.com.uy
Subject Automatically ROLLBACK after fall in *ABORT STATE*
Date
Msg-id 39818F05.4669119F@adinet.com.uy
Whole thread Raw
List pgsql-hackers
Hello dear people,

We all know PostgreSQL inability to handle exceptions. Inside a transaction, any
error will make it fall in *ABORT STATE*, and any further action not being
ROLLBACK, ABORT or COMMIT, will ask for a ROLLBACK, ABORT or COMMIT statement. I
want to know what exact code is executed inside PostgreSQL, when a ROLLBACK
statement is issued. Knowing that, I will modify backend/tcop/postgres.c, to do
the necesary calls to ROLLBACK. This will make PostgreSQL behave at least just
like IBM's DB2, which rolls back automatically after an error.

Regards,
Haroldo.


-- 
----------------------+------------------------Haroldo Stenger      | hstenger@ieee.orgMontevideo, Uruguay. |
hstenger@adinet.com.uy
----------------------+------------------------Visit UYLUG Web Site: http://www.linux.org.uy
-----------------------------------------------


pgsql-hackers by date:

Previous
From: JanWieck@t-online.de (Jan Wieck)
Date:
Subject: toasting for other varlena types
Next
From: hstenger@adinet.com.uy
Date:
Subject: Automatically ROLLBACK after fall in *ABORT STATE*