Re: [BUGS] Unable to handle error in plperl

2013-07-15 Thread Alex Hunsaker
On Mon, Jul 15, 2013 at 5:56 AM, Ming Lai wrote: > I know how elog works. elog only show the status, but it does not allow me > to execute another query when the current query fails because one of the > invalid column was specified. Hrm? Im not sure what you mean. If you elog(ERROR) outside of

Re: [BUGS] Unable to handle error in plperl

2013-07-15 Thread Ming Lai
@postgresql.org Sent: Thursday, July 11, 2013 11:47:04 AM Subject: Re: [BUGS] Unable to handle error in plperl On Wed, Jul 10, 2013 at 2:36 PM, Alex Lai wrote: > Dear all, > > I have a situation. I am unable to pass control back to the function once > it hit the "undefined_column&q

Re: [BUGS] Unable to handle error in plperl

2013-07-11 Thread Alex Hunsaker
On Wed, Jul 10, 2013 at 2:36 PM, Alex Lai wrote: > Dear all, > > I have a situation. I am unable to pass control back to the function once > it hit the "undefined_column" error code. > I am not sure there's a way to return '123' instead exit from the function. > > Here is my code > > CREATE OR RE