| From: | Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz> |
|---|---|
| To: | pgsql-patches(at)postgresql(dot)org |
| Cc: | "'Bruce Momjian'" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <neilc(at)samurai(dot)com> |
| Subject: | Implementation of SQLSTATE and SQLERRM variables |
| Date: | 2005-04-19 13:41:38 |
| Message-ID: | Pine.LNX.4.44.0504191534070.3352-200000@kix.fsv.cvut.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
Hello,
I updated patch to last changes plpgsql code. Patch contains changes for
gram.y, pl_exec.c, plpgsql.h, regress/sql/plpgsql.sql and
regress/output/plpgsql.out. I can't to write documenation, my english is
terrible.
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.
Best regards
Pavel Stehule
| Attachment | Content-Type | Size |
|---|---|---|
| sqlstate.diff | text/plain | 7.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2005-04-19 14:33:54 | Re: [HACKERS] Implementation of SQLCODE and SQLERRM variables |
| Previous Message | Pavel Stehule | 2005-04-19 06:09:24 | Re: [HACKERS] Implementation of SQLCODE and SQLERRM |