Postgres Pro
Downloads
Home   >   mailing lists

Re: No return from trigger function - Mailing list pgsql-general

From Tom Lane
Subject Re: No return from trigger function
Date
Msg-id 18475.1239221193@sss.pgh.pa.us
Whole thread Raw
In response to No return from trigger function  ("James B. Byrne" <byrnejb@harte-lyne.ca>)
Responses Re: No return from trigger function
Re: No return from trigger function
List pgsql-general
Tree view 
"James B. Byrne" <byrnejb@harte-lyne.ca> writes:
> I just need another set of eyes to see whatever it is that I am
> overlooking.

The RETURN is inside the EXCEPTION clause.

You really need two BEGINs here, one for the outer function body and
one for the exception block around the INSERT.

            regards, tom lane

pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: No return from trigger function
Next
From: "James B. Byrne"
Date:
Subject: Re: No return from trigger function