Sim existe...
EXCEPTION WHEN OTHERS THEN
Wolak.
George escreveu:
Bom dia,
Gostaria de saber dntro da trigger
de qualquer tabela pegar o erro geral que deu na tabela e colocar
dentro de outra tabela o erro , exemplo :
BEGIN
new.id = null
EXCEPTION WHEN GERAL THEN
INSERT INTO TABELA_DADOS_COM_ERROS (TG_OP,SQLERRM)
DE ERROS;
return new;
Existe alguma maneira de generalizar
(GERAL) qualquer tipo erro, sem ter que tratar um a um ? eu Uso o
postgresql 8.2.
Obrigado
George
__________ Information from ESET NOD32 Antivirus, version of virus
signature database 4617 (20091118) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
__________ Information from ESET NOD32 Antivirus, version of virus signature database 4617 (20091118) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__________ Information from ESET NOD32 Antivirus, version of virus signature database 4617 (20091118) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
|
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
