Postgres Pro
Downloads
Home   >   mailing lists

pgsql: Fix ON CONFLICT DO UPDATE for tables with oids. - Mailing list pgsql-committers

From Andres Freund
Subject pgsql: Fix ON CONFLICT DO UPDATE for tables with oids.
Date
Msg-id E1ZgcGt-0001Te-BK@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
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
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/617db3a2d8ad6abc0d7be623f43edc943a6640a8

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(-)

pgsql-committers by date:

Previous
From: Robert Haas
Date:
Subject: pgsql: Use LOCKBIT_ON() instead of a bit shift in a few places.
Next
From: Alvaro Herrera
Date:
Subject: pgsql: COPY: use pg_plan_query() instead of planner()