Re: PL/SQL question

From: Mike Nolan <nolan(at)gw(dot)tssi(dot)com>
To: froggy(at)froggycorp(dot)com (Froggy / Froggy Corp(dot))
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PL/SQL question
Date: 2004-04-21 18:17:26
Message-ID: 200404211817.i3LIHQtq029234@gw.tssi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> In fact the problem seems to come from the "INSERT INTO". I delete
> everything from the function and only keep the "INSERT INTO" and get the
> same problem.

Given that this is supposed to be a trigger function, what's
your 'create trigger' statement look like?

Part of the problem may be how your 'return null' is being handled,
and that can be related to when the trigger fires.
--
Mike Nolan

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2004-04-21 18:18:54 Re: 7.3.4 on Linux: UPDATE .. foo=foo+1 degrades massivly over time
Previous Message Joe Conway 2004-04-21 18:12:15 Re: Can I reset the lower bound of an array.