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."
pgsql-novice by date
|Next:||From: Lduren02||Date: 2004-01-13 21:47:27|
|Subject: installing postgre|
|Previous:||From: Devrim GUNDUZ||Date: 2004-01-13 14:42:02|
|Subject: Re: PostgreSQL booting automaticaly|
pgsql-general by date
|Next:||From: netadmin||Date: 2004-01-13 21:13:28|
|Subject: Re: Best practice? Web application: single PostgreSQL|
|Previous:||From: Bruno Wolff III||Date: 2004-01-13 21:07:12|
|Subject: Re: Error since powerouttage|