Home > mailing lists

Re: can you do rollback in a trigger function? - Mailing list pgsql-general

From	Vick Khera
Subject	Re: can you do rollback in a trigger function?
Date	October 15, 2013 22:00:19
Msg-id	CALd+dcdtMQgJx6t8paVYBswHE2mDd8hQLJYO02A0V36Mwgr2jA@mail.gmail.com Whole thread Raw
In response to	can you do rollback in a trigger function? (Quang Thoi <Quang_Thoi@symantec.com>)
List	pgsql-general

On Tue, Oct 15, 2013 at 2:38 PM, Quang Thoi <Quang_Thoi@symantec.com> wrote:

I want to roll back deletion if there is a reference (FK) in another table.
Can I explicitly call a rollback inside a function?

You should RAISE an error. The transaction should roll back due to the error.

From: Quang Thoi
Date: 15 October 2013, 21:33:59
Subject: can you do rollback in a trigger function?

From: Shaun Thomas
Date: 15 October 2013, 22:18:41
Subject: Re: can you do rollback in a trigger function?