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
(___\ /___) (____/ (____) `---'
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
