can't CREATE TRIGGER
От | gustavo halperin |
---|---|
Тема | can't CREATE TRIGGER |
Дата | |
Msg-id | 45B3E77C.7020603@gmail.com обсуждение исходный текст |
Ответы |
Re: can't CREATE TRIGGER
Re: can't CREATE TRIGGER Re: can't CREATE TRIGGER |
Список | pgsql-general |
Hello I can't create triggers, when I call for example: ficha=> CREATE TRIGGER TRG_persons_id AFTER INSERT ON ficha_ofperson ficha-> EXECUTE PROCEDURE add_person_id ( 'family_id', 'person_id' ); , the creation never finish and finally, after many minutes, I kill the creation with Ctrl+c. I try also a simple trigger creation with a function without arguments and also the creation never finish. The functions work OK, I can call theme without problems, see below: ficha=> select add_person_id (1,7); I also add a permissions as postgres user's, see below: ficha=# GRANT TRIGGER ON TABLE ficha_ofperson TO PUBLIC; GRANT So.., any Idea what is my error ??? Thank you in advance, Gustavo -- ||\ // \ | \\ // | I'm thinking. \ \\ l\\l_ // | _ _ | \\/ `/ `.| | /~\\ \ //~\ | Y | | || Y | | \\ \ // | | \| | |\ / | [ || || ] \ | o|o | > / ] Y || || Y [ \___\_--_ /_/__/ | \_|l,------.l|_/ | /.-\(____) /--.\ | >' `< | `--(______)----' \ (/~`--____--'~\) / U// U / \ `-_>-__________-<_-' / \ / /| /(_#(__)#_)\ ( .) / / ] \___/__\___/ `.`' / [ /__`--'__\ |`-' | /\(__,>-~~ __) | |__ /\//\\( `--~~ ) _l |--:. '\/ <^\ /^> | ` ( < \\ _\ >-__-< /_ ,-\ ,-~~->. \ `:.___,/He (___\ /___) (____/ (____) `---'
В списке pgsql-general по дате отправления: