Trigger documentation problem
| От | Antonio Sergio de Mello e Souza |
|---|---|
| Тема | Trigger documentation problem |
| Дата | |
| Msg-id | 3BEFE7EB.4070206@bol.com.br обсуждение исходный текст |
| Ответы |
Re: Trigger documentation problem
|
| Список | pgsql-general |
Hi all,
There's a problem with the documentation for triggers.
In the CREATE TRIGGER documentation page, the synopsis says:
CREATE TRIGGER name { BEFORE | AFTER } { event [OR ...] }
ON table FOR EACH { ROW | STATEMENT }
EXECUTE PROCEDURE func ( arguments )
and one of the examples given is:
CREATE TRIGGER if_dist_exists
BEFORE INSERT OR UPDATE ON films FOR EACH ROW
EXECUTE PROCEDURE check_primary_key ('did', 'distributors', 'did');
However, in the section 21.1 TRIGGER CREATION, one can read:
The trigger function must be created before the trigger is created as a
function taking no arguments and returning opaque.
Also, in the section 24.3 TRIGGER PROCEDURES:
They are created with the usual CREATE FUNCTION command as a function
with no arguments and a return type of OPAQUE.
Regards,
Antonio Sergio
В списке pgsql-general по дате отправления: