Re: PG 14 Create Rule ERROR - RETURNING list has too few entries

Lucas <root(at)sud0(dot)nz> 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