On a table update, I want to check for certain conditions in a trigger
function, and if a condition is met, NOT ALLOW the update. Not a big
problem...I can accomplish that.

My question is this: How can I send a message back to the calling
application telling the user that the update was denied or failed, and for
the user to try again? Basically, I need a way to send a return value back
to the application (a 0 or a 1) when a trigger function says so.

Any ideas?

Thanks,
Derrick


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

RAISE EXCEPTION 'Your specific error message';
works just great.

----- Original Message -----
From: <derrick (AT) grifflink (DOT) com>
To: <pgsql-novice (AT) postgresql (DOT) org>
Sent: Monday, September 20, 2004 1:09 PM
Subject: [NOVICE] Return Value on UPDATE trigger



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match