Por favor, o que pode estar errado na criação da Function e Trigger
abaixo?
CREATE FUNCTION teste(integer) RETURNS trigger AS
'DELETE FROM cliente WHERE cliente_id=$1;'
LANGUAGE plpgsql;
>> Query returned successfully with no result in 81 ms.
CREATE TRIGGER teste BEFORE DELETE ON cliente_20080902
FOR EACH ROW EXECUTE PROCEDURE teste(cliente_id);
>> ERROR: function teste() does not exist
Desde já, obrigado.
--
Antonio Prado
(62) 8174 4383
(62) 3278 0111
www.antonioprado.eti.br
[EMAIL PROTECTED]
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
