| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql: Fix ON CONFLICT DO UPDATE for tables with oids. |
| Date: | 2015-09-28 17:31:29 |
| Message-ID: | E1ZgcGv-0001U0-2J@gemulon.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Fix ON CONFLICT DO UPDATE for tables with oids.
When taking the UPDATE path in an INSERT .. ON CONFLICT .. UPDATE tables
with oids were not supported. The tuple generated by the update target
list was projected without space for an oid - a simple oversight.
Reported-By: Peter Geoghegan
Author: Andres Freund
Backpatch: 9.5, where ON CONFLICT was introduced
Branch
------
REL9_5_STABLE
Details
-------
http://git.postgresql.org/pg/commitdiff/90586ef127c593002897ee0bcafdf2adb6a18c7d
Modified Files
--------------
src/backend/executor/nodeModifyTable.c | 2 +-
src/test/regress/expected/insert_conflict.out | 59 +++++++++++++++++++++++++
src/test/regress/sql/insert_conflict.sql | 22 +++++++++
3 files changed, 82 insertions(+), 1 deletion(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2015-09-28 18:16:50 | pgsql: COPY: use pg_plan_query() instead of planner() |
| Previous Message | Andres Freund | 2015-09-28 17:31:27 | pgsql: Fix ON CONFLICT DO UPDATE for tables with oids. |