"BEFORE INSERT" was the problem here, "AFTER INSERT" works fine
Thanks for all answers.
--
Regards,
Grzegorz
W dniu 2012-08-31 20:41, Grzegorz Tańczyk pisze:
> Hello,
>
> W dniu 2012-08-31 20:25, David Johnston pisze:
>> The question becomes how do you update the "item id" on the "groups"
>> table when you add new records to "items".
>
> I have a trigger on items table:
>
> CREATE TRIGGER items_insert
> BEFORE INSERT
> ON items
> FOR EACH ROW
> EXECUTE PROCEDURE items_oninsert();
>
> CREATE OR REPLACE FUNCTION items_oninsert()
> RETURNS trigger AS
> $BODY$
> BEGIN
> UPDATE groups SET last_item = NEW.id WHERE id=NEW.group AND
> (last_item IS NULL OR last_item<NEW.id);
> RETURN NEW;
> END;
> $BODY$
> LANGUAGE 'plpgsql' VOLATILE;
>
> Thanks!
>
> --
> Regards,
> Grzegorz
