| From: | Terry Lee Tucker <terry(at)esc1(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Trigger Question |
| Date: | 2004-01-13 21:07:35 |
| Message-ID: | 200401111713.54786.terry@esc1.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice |
Hi,
I have a simple question. I have been looking at the HTML docs for Postgres
version: PostgreSQL 7.2.3-RH on i686-pc-linux-gnu, compiled by GCC 2.96. I
need to know if it is necessary to RETURN NULL from a trigger function after
raising an exception with RAISE EXCEPTION. We are doing many different data
validations in a "BEFORE UPDATE OR INSERT" trigger and we have been raising
an exception with an error string such that the error comes back to the
X-Windows applicaton. I read that returning NULL prevents other triggers from
fireing but doesn't RAISE EXCEPTION abort the tranaction and cause all
processing to stop?
Thanks in advance for your help...
--
"The world we have created is a product of our thinking. It cannot be
changed without changing our thinking."
--Albert Einstein
Work: 1-336-372-6812
Cell: 1-336-363-4719
email: terry(at)esc1(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | netadmin | 2004-01-13 21:13:28 | Re: Best practice? Web application: single PostgreSQL |
| Previous Message | Bruno Wolff III | 2004-01-13 21:07:12 | Re: Error since powerouttage |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lduren02 | 2004-01-13 21:47:27 | installing postgre |
| Previous Message | Devrim GUNDUZ | 2004-01-13 14:42:02 | Re: PostgreSQL booting automaticaly |