Re: Pl/pgSQL trigger failing and i ant see why

On 24 Jul 2002, Maurice Walshe wrote:

> HI all
>
> I have read the skimpy docs on postgres triggers and whilst I can
> get a simple trigger working when I try to call a Pl/pgsql function
> to return the value I want to set one of the foields in NEW to it wont
> work.
>
> immediateparentid_ is INT4
>
> This fails NEW.immediateparentid_ := FindRealParent(NEW.messageid_) ;
> This works NEW.immediateparentid_ := 123456 ;
>
> Here are the function's btw I have tested the interactivlky so they
> are returning coorect values.
>

What are you getting as an error when you insert to the table?

> Any one got any ideas? BTW WTF does postgres hide its logs?

General logs? That depends on your configuration. You either should
be redirecting output/error from postmaster to somewhere or having
it go to syslog.