Re: Trigger Update Issue

On Friday 05 March 2004 14:00, beer wrote:
> Hello All
>
> I'm running 7.3.4-1 on a RH9 box. I'm having a problem with a trigger
> that seems to execute without actually performing the update that it
> should. The update returns true everytime however if it is the first time
> that the trigger executes on a given row, the column is not updated. The
> column is updated correctly on subsequent calls.

Perhaps put some debug code in and insert into tabB manually

> CREATE OR REPLACE FUNCTION "tabB_postinsert" () RETURNS TRIGGER AS '
> --
> -- Actions to take after inserting into tabB
> --
DECLARE
numrows int4;

> BEGIN
> -- Increment tabA.attachments
> UPDATE tabA SET Acol3 = Acol3 + 1 WHERE id = NEW.tabA_id;
GET DIAGNOSTICTS numrows = ROW_COUNT;
RAISE NOTICE ''Updated % rows with id = %'',numrows, NEW.tabA_id;
> -- done
> RETURN NEW;
> END; ' LANGUAGE 'plpgsql';

Insert into tabB from psql and you should see a NOTICE message telling you
what is happening.

--
Richard Huxton
Archonet Ltd