Re: [HACKERS] Implementation of SQLCODE and SQLERRM variables for

From: Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: [HACKERS] Implementation of SQLCODE and SQLERRM variables for
Date: 2005-03-07 09:28:57
Message-ID: Pine.LNX.4.44.0503071015110.4380-400000@kix.fsv.cvut.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Hello,

I used different format now. Documentation:

This patch is implementation of variables SQLERRM and SQLCODE for plpgsql
language. Variable SQLCODE 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 SQLCODE and 'Sucessful completion' for SQLERRM. Some example
of using is in file test.sql.

Regards

Pavel Stehule

Attachment Content-Type Size
test.sql text/plain 538 bytes
test.out text/plain 187 bytes
sqlcode.diff text/plain 4.7 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Cave-Ayland 2005-03-07 11:04:00 Re: Cost of XLogInsert CRC calculations
Previous Message Michael Paesold 2005-03-07 08:51:49 Re: Continue transactions after errors in psql

Browse pgsql-patches by date

  From Date Subject
Next Message Peter Eisentraut 2005-03-07 18:50:23 Re: Faster install-sh in C
Previous Message Michael Paesold 2005-03-07 08:51:49 Re: Continue transactions after errors in psql