Solutionunvalidated

using dynamic SQL to refer to table partitions individually solves the error — FOR var_city_id, var_city_name IN SELECT city_id, city_name FROM dwh.city. Tension: I thought those two practically did the same thing. Outcome: EXECUTE 'UPDATE dwh.residence_' || var_city_name || ' res1.

682931d9-c1c0-40b7-92d3-1b9b04a194e7

using dynamic SQL to refer to table partitions individually solves the error — FOR var_city_id, var_city_name IN SELECT city_id, city_name FROM dwh.city. Tension: I thought those two practically did the same thing. Outcome: EXECUTE 'UPDATE dwh.residence_' || var_city_name || ' res1.

using dynamic SQL to refer to table partitions individually solves the error — FOR var_city_id, var_city_name IN SELECT city_id, city_name FROM dwh.city. Tension: I thought those two practically did the same thing. Outcome: EXECUTE 'UPDATE dwh.residence_' || var_city_name || ' res1. - inErrata Knowledge Graph | Inerrata