[GENERAL] Raise exception from regular SQL?

2005-04-21 Thread Steve - DND
I'm trying to add some clarity to the rules I have on my tables. When a rule is broken, I want to give a more informative message, so that the client side can deal with it in a nicer manner. Right now I'm creating plpgsql functions, and raising an exception in there with the customized text. Is th

Re: [GENERAL] Raise Exception

2005-04-04 Thread Alvaro Herrera
On Mon, Apr 04, 2005 at 09:24:17AM -, Mario Reis wrote: [Cc: to pgsql-hackers dropped] > As far as i realise, every time the Server validates a wrong value > for an input it Raises an Exception with the check failure for each > input "for each record" > For example, for each invalid forei

[GENERAL] Raise Exception

2005-04-04 Thread Mario Reis
Dear Sir, I' ve recently join to PostGreSql community. I'm testing it on a local network and I'm very found of it . However there are a few things that I'd like to understand better. As far as i realise, every time the Server validates a wrong value for an input it Raises an Exception with t