Update count mismatch - internal error - Mailing list pgsql-hackers

From Andres Freund
Subject Update count mismatch - internal error
Date
Msg-id 20150920001511.GB3844@alap3.anarazel.de
Whole thread Raw
Responses Re: Update count mismatch - internal error  (Peter Geoghegan <pg@heroku.com>)
List pgsql-hackers
Hi,

While working on polishing remaining upsert issues I found a, afaics
unrelated, issue:

postgres[14993][1]=# CREATE TABLE mismatch(a int, b int);
CREATE TABLE
postgres[14993][1]=# UPDATE mismatch SET a = mismatch.*;
ERROR:  XX000: UPDATE target count mismatch --- internal error
LOCATION:  transformUpdateTargetList, analyze.c:2103

Seems to be a longer standing thing, going at least back to 9.0.

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: ON CONFLICT issues around whole row vars,
Next
From: Peter Geoghegan
Date:
Subject: Re: Update count mismatch - internal error