| From: | Emi Lu <emilu(at)encs(dot)concordia(dot)ca> |
|---|---|
| To: | "Pedro B(dot)" <pedro(dot)borracha(at)netcabo(dot)pt> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: About how to use "exception when ??? then " |
| Date: | 2006-03-16 20:11:23 |
| Message-ID: | 4419C66B.9010602@encs.concordia.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
>On Thursday 16 March 2006 19:32, Emi Lu wrote:
>|> Errors I got are:
>|> syntax error at or near "SQLSTATE" at character 2613
>|> LINE 58: RAISE NOTICE 'Hmmmm.... [%,%]', SQLSTATE, SQL...
>|>
>|>
>|> Should I install any patches or do anything elese to have SQLSTATE and
>|> SQLERRM work for me?
>
>
>I'm so sorry, i had a terrible day and in the rush to reply to you, i forgot
>to mention the patch i applied some time ago.
>
>The patch and thread talking about it can be found here:
>
>http://archives.postgresql.org/pgsql-patches/2005-04/msg00123.php
>
>This was what i used in my 8.0.6, and it worked fine ever since. :)
>
>
Thanks a lot Pedro. Could you help me how to apply this patch such as
the steps to load the patch please?
By the way, I am using postgresql 8.0.1. I think the patch will work for
all 8.0.x version, right?
Thanks again,
Ying
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-03-16 20:18:01 | Re: About how to use "exception when ??? then " |
| Previous Message | Emi Lu | 2006-03-16 19:44:53 | Re: About how to use "exception when ??? then " |