Re: can't CREATE TRIGGER

From: "Jaime Casanova" <systemguards(at)gmail(dot)com>
To: "gustavo halperin" <ggh(dot)develop(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: can't CREATE TRIGGER
Date: 2007-01-22 03:38:05
Message-ID: c2d9e70e0701211938ge25cb0cp1864b1c0ec5301b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 1/21/07, gustavo halperin <ggh(dot)develop(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2007-01-22 03:41:21 Re: can't CREATE TRIGGER
Previous Message Stephan Szabo 2007-01-22 03:36:39 Re: can't CREATE TRIGGER