Re: Issue with server side statement-level rollback

2020-11-22 Thread Gilles Darold
Le 20/11/2020 à 16:18, Gilles Darold a écrit : > I will work later on a POC to demonstrate the use case I want to > implement. Hi Andres, I have created a new version of the pg_statement_rollback extension [1] to demonstrate the use of the hooks on start_xact_command(), finish_xact_command() a

Re: Issue with server side statement-level rollback

2020-11-20 Thread Gilles Darold
Hi, Le 19/11/2020 à 21:43, Andres Freund a écrit : Hi, On 2020-11-12 11:40:22 +0100, Gilles Darold wrote: The problem we are encountering is when PostgreSQL is compiled in debug mode with --enable-cassert. At line 1327 of src/backend/tcop/pquery.c the following assert fail:     /*      * Cl

Re: Issue with server side statement-level rollback

2020-11-19 Thread Andres Freund
Hi, On 2020-11-12 11:40:22 +0100, Gilles Darold wrote: > The problem we are encountering is when PostgreSQL is compiled in debug > mode with --enable-cassert. At line 1327 of src/backend/tcop/pquery.c > the following assert fail: > >     /* >      * Clear subsidiary contexts to recover temporary

Issue with server side statement-level rollback

2020-11-12 Thread Gilles Darold
Hi, We're facing some issue in a new extension we use at LzLabs to emulate server side rollback at statement level in PostgreSQL, see for full detail https://github.com/lzlabs/pg_statement_rollback/ The problem we are encountering is when PostgreSQL is compiled in debug mode with --enable-casse