Re: Functions, savepoints, autocommit = I am confused ! - Mailing list pgsql-general

From Tim Smith
Subject Re: Functions, savepoints, autocommit = I am confused !
Date
Msg-id CA+HuS5H+_s5vVBqnsYofuO-j0Ya0oApR-KA069tvWF8m_oyFTw@mail.gmail.com
Whole thread Raw
In response to Re: Functions, savepoints, autocommit = I am confused !  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
>
>
> I knew I was missing something:(
> http://www.postgresql.org/docs/9.4/interactive/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING
>
> "When an error is caught by an EXCEPTION clause, the local variables of the
> PL/pgSQL function remain as they were when the error occurred, but all
> changes to persistent database state within the block are rolled back. As an
> example, consider this fragment:"
>
>
> So I would try



You are a genius.  ;-)

Thank you !

Have a delightful weekend.


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Functions, savepoints, autocommit = I am confused !
Next
From: Kevin Grittner
Date:
Subject: Re: Question about the isolation level and visible