Re: rollback in C functions - Mailing list pgsql-general

From Juan Pablo L
Subject Re: rollback in C functions
Date
Msg-id CABSYDaYNSqFzH37U6xh0+09PR6+NssXukhPY3HDv3GizKDUP8w@mail.gmail.com
Whole thread Raw
In response to Re: rollback in C functions  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: rollback in C functions  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Re: rollback in C functions  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Hi, i want previous updates to rollback ... like nothing happened (a normal begin/rollback behaviour)

On 19 February 2015 at 15:34, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
Juan Pablo L wrote:
> Hello, i have created a function (in C) that receives an array that
> contains tuples of ID's and values.

Why are you writing a C function?  Sounds like you could accomplish the
same with a plpgsql function, with much less effort.

> The function is to execute updates on each ID assigning the value, but if
> one of these operation fails (does not meet certain criteria)
> inside the function i would like to rollback and leave everything
> untouched, in case other ID;s were already updated previously,
> and come back to the caller and inform about it.

Do you want previous updates to remain in place, or do you want to roll
them back too?  This is not clear.


--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: rollback in C functions
Next
From: Alvaro Herrera
Date:
Subject: Re: rollback in C functions