Postgres Pro
Downloads
Home   >   mailing lists

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

From Lucas
Subject Re: PG 14 Create Rule ERROR - RETURNING list has too few entries
Date
Msg-id 99834C7B-2C78-4D08-85C0-3FA2F1336B94@sud0.nz
Whole thread Raw
In response to Re: PG 14 Create Rule ERROR - RETURNING list has too few entries  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view

On 28/02/2022, at 4:06 PM, Tom Lane <tgl@sss.pgh.pa.us> 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!

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PG 14 Create Rule ERROR - RETURNING list has too few entries
Next
From: Wim Bertels
Date:
Subject: Re: \set \e and newline