X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 6026F47592C
	for <pgsql-sql@postgresql.org>; Thu,  6 Feb 2003 10:51:14 -0500 (EST)
Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.227.56])
	by postgresql.org (Postfix) with ESMTP id E505F47590C
	for <pgsql-sql@postgresql.org>; Thu,  6 Feb 2003 10:51:13 -0500 (EST)
Received: from roberto by brasileiro.net with local (Exim 3.35 #1 (Debian))
	id 18goPh-0007CS-00; Thu, 06 Feb 2003 08:58:09 -0700
Date: Thu, 6 Feb 2003 08:58:09 -0700
From: Roberto Mello <rmello@cc.usu.edu>
To: =?iso-8859-1?Q?Maur=EDcio?= Sessue Otta <mauricio@cristorei.com.br>
Cc: LISTA POSTGRES <pgsql-sql@postgresql.org>
Subject: Re: Trigger para fazer log
Message-ID: <20030206155809.GF27389@cc.usu.edu>
References: <002301c2cdd8$30b82640$830101c0@mauricio1>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
In-Reply-To: <002301c2cdd8$30b82640$830101c0@mauricio1>
User-Agent: Mutt/1.4i
X-message-flag: Please consider using an e-mail program other than Outlook.
	It's insecure.
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/118
X-Sequence-Number: 11516

On Thu, Feb 06, 2003 at 10:06:32AM -0200, Maur=EDcio Sessue Otta wrote:
>=20
> Quando est=E1 "EXCEPTION", o que deveria ser guardado no "log" tamb=E9m =
=E9 desfeito. Quando coloco "NOTICE", a
> informa=E7=E3o vai para o LOG.
>=20
> Como fazer para o trigger gerar uma "EXCEPTION" e mesmo assim gravar em o=
utra tabela?!?!

N=E3o d=E1. Quando voc=EA levanta uma exce=E7=E3o (exception) o controle vo=
lta para
quem chamou o gatilho. N=E3o h=E1 como contornar, que eu saiba.

Voc=EA tem que fazer a inser=E7=E3o na rela=E7=E3o desejada antes de levant=
ar a
exce=E7=E3o (talvez chamando outra fun=E7=E3o que o fa=E7a).

-Roberto

P.S.: Tomaz, you understood his question correctly :-)

--=20
+----|        Roberto Mello   -    http://www.brasileiro.net/  |------+
+       Computer Science Graduate Student, Utah State University      +
+       USU Free Software & GNU/Linux Club - http://fslc.usu.edu/     +
I'm not super man. But I am very dense.