From: CHRIS HOOVER <CHRIS.HOOVER@companiongroup.com>
To: pgsql-sql@postgresql.org
Subject: raise is not working
Date: Tue, 21 Sep 2004 12:44:00 -0400
Message-ID: <NY3dc8d8-04950e86@companiongroup.com> (raw)
Hello again everyone.
I need some help once again. I am following the postgresql pl/pgsql docs and
trying to have my function show me the query it is trying to run since it not
returning the expected results. However, it does not appear that the raise
option is working. Can anyone please point me to what is wrong, or what
server options need to be turned on.
I have tried setting both server_min_messages (all the way down to debug5),
and client_min_messages (to debug1), and I still do not get a responce. I did
bounce the server after these changes.
Anyway, here is a code snippet of what I am trying to do:
SQL_Str := SQL_Str || "limit 15000;";
RAISE NOTICE ''SQL STRING = %'', SQL_Str;
raise exception ''THIS SUCKS!'';
for Clmhdr_rec in execute SQL_Str loop
return next Clmhdr_rec;
end loop;
return;
end;
---------------
SQL_Str is defined as a varchar. Neither of the raise calls have done
anything, but I don't get any errors either.
I'm running 7.3.4.
Thanks,
Chris
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: CHRIS.HOOVER@companiongroup.com
Subject: Re: raise is not working
In-Reply-To: <NY3dc8d8-04950e86@companiongroup.com>
* 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