Lucas <root@xxxxxxx> writes: > Ooops, I forgot to paste the CREATE RULE statement as an example: > The idea of these roles is a superimposed version of post-QBO ja_notes that exposes an inferred (from ja_jobs) "clientid" after the redundant column was removed from public.ja_notes. It also localizes timestamps in accordance to the legacy modification dates, and truncates start_time to whole seconds only > CREATE RULE r_di_ja_notes AS > ON DELETE TO doctrine.ja_notes DO INSTEAD DELETE FROM ja_notes r_1103088 WHERE (r_1103088.id = old.id) > RETURNING r_1103088.id, > r_1103088.mobiuserid, > [etc] The RETURNING list has to match the column list of the rule's target table or view (here, doctrine.ja_notes). Maybe you added some columns to that since this last worked? regards, tom lane
