Skip site navigation (1) Skip section navigation (2)

Re: raise is not working

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "CHRIS HOOVER" <CHRIS(dot)HOOVER(at)companiongroup(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: raise is not working
Date: 2004-09-21 22:29:10
Message-ID: 4074.1095805750@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-sql
"CHRIS HOOVER" <CHRIS(dot)HOOVER(at)companiongroup(dot)com> writes:
> SQL_Str is defined as a varchar.  Neither of the raise calls have done
> anything, but I don't get any errors either.

The only way RAISE EXCEPTION "isn't going to do anything" is if control
doesn't get to it.  My bet would be that you are invoking some other
function than you think you are --- we've seen examples of that sort of
mistake recently.  Check for multiple functions with same name and
different argument types.

			regards, tom lane

In response to

pgsql-sql by date

Next:From: Cris CarampaDate: 2004-09-22 09:08:22
Subject: where clause on a left outer join
Previous:From: Mischa SandbergDate: 2004-09-21 22:16:24
Subject: Re: COUNT(*) to find records which have a certain number of dependencies

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group