PostgreSQL Trigger and rows updated
От | Albert |
---|---|
Тема | PostgreSQL Trigger and rows updated |
Дата | |
Msg-id | 1333190350056-5608591.post@n5.nabble.com обсуждение исходный текст |
Ответы |
Re: PostgreSQL Trigger and rows updated
Re: PostgreSQL Trigger and rows updated |
Список | pgsql-general |
am trying to update a table according to this trigger : CREATE TRIGGER alert AFTER UPDATE ON cars FOR EACH ROW EXECUTE PROCEDURE update_cars(); Trigger Function : CREATE FUNCTION update_cars() RETURNS 'TRIGGER' AS $BODY$ BEGIN IF (TG_OP = 'UPDATE') THEN UPDATE hello_cars SET status = new.status WHERE OLD.ID = NEW.ID; END IF; RETURN NULL; END; $$ LANGUAGE plpgsql; the trigger works fine. when cars table updated, the hello_cars table updated but status column in each row is updated and contains same new status ! it must be updated according to car ID. i think my problem is in condition : WHERE OLD.ID = NEW.ID; but can't tell what's wrong exactly Thanks in advanced -- View this message in context: http://postgresql.1045698.n5.nabble.com/PostgreSQL-Trigger-and-rows-updated-tp5608591p5608591.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
В списке pgsql-general по дате отправления: