Re: can't CREATE TRIGGER - Mailing list pgsql-general

From Jaime Casanova
Subject Re: can't CREATE TRIGGER
Date
Msg-id c2d9e70e0701211938ge25cb0cp1864b1c0ec5301b@mail.gmail.com
Whole thread Raw
In response to can't CREATE TRIGGER  (gustavo halperin <ggh.develop@gmail.com>)
List 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 by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: can't CREATE TRIGGER
Next
From: Michael Fuhr
Date:
Subject: Re: can't CREATE TRIGGER