| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Cris Carampa | 2004-09-22 09:08:22 | where clause on a left outer join |
| Previous Message | Mischa Sandberg | 2004-09-21 22:16:24 | Re: COUNT(*) to find records which have a certain number of dependencies |