Re: can't CREATE TRIGGER

Поиск
Список
Период
Сортировка
От Jaime Casanova
Тема Re: can't CREATE TRIGGER
Дата
Msg-id c2d9e70e0701211938ge25cb0cp1864b1c0ec5301b@mail.gmail.com
обсуждение исходный текст
Ответ на can't CREATE TRIGGER  (gustavo halperin <ggh.develop@gmail.com>)
Список pgsql-general
On 1/21/07, gustavo halperin <ggh.develop@gmail.com> wrote:
> 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.

perhaps the table is locked, view in pg_locks...

--
regards,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
                                       Richard Cook

В списке pgsql-general по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: can't CREATE TRIGGER
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: can't CREATE TRIGGER