Re: Trigger Update Issue

Richard

Thanks for the suggestion. I had tried something similar using FOUND but
that didnt not give me the number of rows touched.

According to the output, 1 row was updated, however when I select on the
row the value is still 0.

-b

> 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
>
>