Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: PG 14 Create Rule ERROR - RETURNING list has too few entries
From: Lucas <root@xxxxxxx>
Date: Mon, 28 Feb 2022 16:31:31 +1300
Cc: pgsql-general@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <2424741.1646017600@sss.pgh.pa.us>
References: <171636E4-4BAC-4440-A7FC-533C94719021@sud0.nz> <2F0E9E62-6F42-4AB2-B183-C22BDF0598A0@sud0.nz> <2424741.1646017600@sss.pgh.pa.us>

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- PG 14 Create Rule ERROR - RETURNING list has too few entries
  - From: Lucas
- Re: PG 14 Create Rule ERROR - RETURNING list has too few entries
  - From: Lucas
- Re: PG 14 Create Rule ERROR - RETURNING list has too few entries
  - From: Tom Lane

Prev by Date: Re: PG 14 Create Rule ERROR - RETURNING list has too few entries
Next by Date: Re: \set \e and newline
Previous by thread: Re: PG 14 Create Rule ERROR - RETURNING list has too few entries
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux