Re: Return Value on UPDATE trigger
От | derrick@grifflink.com |
---|---|
Тема | Re: Return Value on UPDATE trigger |
Дата | |
Msg-id | 030701c49f87$e1efb180$0200a8c0@main обсуждение исходный текст |
Ответ на | Backups (Eduardo Vázquez Rodríguez<evazquez@insys-corp.com.mx>) |
Список | pgsql-novice |
RAISE EXCEPTION 'Your specific error message'; works just great. ----- Original Message ----- From: <derrick@grifflink.com> To: <pgsql-novice@postgresql.org> Sent: Monday, September 20, 2004 1:09 PM Subject: [NOVICE] Return Value on UPDATE trigger > 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 >
В списке pgsql-novice по дате отправления: