From: Emi Lu <emilu@encs.concordia.ca>
To: Pedro B. <pedro.borracha@netcabo.pt>
Cc: pgsql-sql@postgresql.org
Subject: Re: About how to use "exception when ??? then "
Date: Thu, 16 Mar 2006 15:11:23 -0500
Message-ID: <4419C66B.9010602@encs.concordia.ca> (raw)
In-Reply-To: <200603161957.46039.pedro.borracha@netcabo.pt>
References: <4419AB1A.3070805@encs.concordia.ca>
<200603161827.19462.pedro.borracha@netcabo.pt>
<4419BD3A.1050903@encs.concordia.ca>
<200603161957.46039.pedro.borracha@netcabo.pt>
>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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: emilu@encs.concordia.ca, pedro.borracha@netcabo.pt
Subject: Re: About how to use "exception when ??? then "
In-Reply-To: <4419C66B.9010602@encs.concordia.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox