Re: No return from trigger function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "James B(dot) Byrne" <byrnejb(at)harte-lyne(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: No return from trigger function
Date: 2009-04-08 20:06:33
Message-ID: 18475.1239221193@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"James B. Byrne" <byrnejb(at)harte-lyne(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kashmir 2009-04-08 20:08:06 some external sql not working in psql
Previous Message Ron Mayer 2009-04-08 20:05:55 Re: Are there performance advantages in storing bulky field in separate table?