"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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
