Re: [HACKERS] Implementation of SQLCODE and SQLERRM - Mailing list pgsql-patches

From Pavel Stehule
Subject Re: [HACKERS] Implementation of SQLCODE and SQLERRM
Date
Msg-id Pine.LNX.4.44.0504190656200.32148-100000@kix.fsv.cvut.cz
Whole thread Raw
In response to Re: [HACKERS] Implementation of SQLCODE and SQLERRM variables  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [HACKERS] Implementation of SQLCODE and SQLERRM variables
List pgsql-patches
Hello,

I am not sure, I corrected memory problems, I think, but there are some
changes in plpgsql code. I'l update patch today.

Regards
Pavel Stehule

On Mon, 18 Apr 2005, Bruce Momjian wrote:

>
> Guys, is this patch ready for application?  I think so, but am not 100%
> sure.
>
> ---------------------------------------------------------------------------
>
> Pavel Stehule wrote:
> > Hello,
> >
> > I changed code by your and Neil's notes. The name SQLCODE isn't well,
> > better is SQLSTATE. It's very similar DB2 variable. I am not sure, so my
> > solutions is best. Propably not. It's only particular solution for
> > plpgsql. The files plpgsql.sql and plpgsql.out are diffs for regression
> > tests.
> >
> >  This patch is implementation of variables SQLERRM and SQLSTATE for plpgsql
> >  language. Variable SQLSTATE contains five chars PostgreSQL Error Code,
> >  SQLERRM contains relevant message last catched exception. All variables
> >  are attached to plpgsql_block and have local scope. Default values are
> >  '00000' for SQLSTATE and 'Sucessful completion' for SQLERRM.
> >
> > Regards
> >
> > Pavel Stehule
> >
>
> Content-Description:
>
> [ Attachment, skipping... ]
>
> Content-Description:
>
> [ Attachment, skipping... ]
>
> Content-Description:
>
> [ Attachment, skipping... ]
>
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
>
>


pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Implementation of SQLCODE and SQLERRM variables for
Next
From: Pavel Stehule
Date:
Subject: Re: [HACKERS] Implementation of SQLCODE and SQLERRM