| From: | "Brian H Mayo" <bmayo(at)comcast(dot)net> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | RAISE EXCEPTION not working |
| Date: | 2003-11-20 23:08:55 |
| Message-ID: | !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAAG3YoS0+KdkSnINSjzQKMisKAAAAQAAAA7z14CMS7K0KIMl5K7nqVxAEAAAAA@comcast.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I am trying the use the following statements in a function:
SELECT INTO temp_i id FROM public.t_customer_profile WHERE
id=cust_id;
IF NOT FOUND THEN
RAISE EXCEPTION "Username already exists";
END IF;
I know the table and the select statement is correct.
And I keep receiving the following error:
WARNING: plpgsql: ERROR during compile of f_insert_login_profile_record
near line 19
ERROR: syntax error at or near ""Username already exists""
I do not understand why.
Thank you.
Brian H Mayo
<mailto:bmayo(at)comcast(dot)net> bmayo(at)comcast(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Francisco Reyes | 2003-11-20 23:33:57 | Psql bug? |
| Previous Message | Tom Lane | 2003-11-20 22:39:50 | Re: ERROR: nodeRead: did not find '}' [x2] |