> On 28/02/2022, at 4:06 PM, Tom Lane wrote:
>
> 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?
You are correct. The view has an extra column.
Thanks!
Lucas 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 timest
>
> On 28/02/2022, at 3:44 PM, Lucas wrote:
>
> Hi,
>
> On PG 14.1, when trying to create a RULE [1], I get the following error:
>
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 inferre
Hi,
On PG 14.1, when trying to create a RULE [1], I get the following error:
ERROR: RETURNING list has too few entries
The same syntax works on PG 9.x (previous version of the DB). Any suggestions
on a fix, please?
Than
