can't CREATE TRIGGER

Поиск
Список
Период
Сортировка
От gustavo halperin
Тема can't CREATE TRIGGER
Дата
Msg-id 45B3E77C.7020603@gmail.com
обсуждение исходный текст
Ответы Re: can't CREATE TRIGGER  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Re: can't CREATE TRIGGER  ("Jaime Casanova" <systemguards@gmail.com>)
Re: can't CREATE TRIGGER  (Michael Fuhr <mike@fuhr.org>)
Список 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 по дате отправления:

Предыдущее
От: Chris
Дата:
Сообщение: Re: More grist for the PostgreSQL vs MySQL mill
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: can't CREATE TRIGGER