create or replace function archive_offers_on_release_archiving()
returns trigger as $$
begin
    update offers set status_id = 3 where item_id = new.id;
    return new;
end
$$language plpgsql;

create trigger archive_offers_on_release_archiving_trigger
after update on releases
for each row
when (NEW.active_id = 4)
execute procedure archive_offers_on_release_archiving();

update releases set active_id = 4 where id = 80;