pgsql: Fix ON CONFLICT DO UPDATE for tables with oids.

Поиск
Список
Период
Сортировка
От Andres Freund
Тема pgsql: Fix ON CONFLICT DO UPDATE for tables with oids.
Дата
Msg-id E1ZgcGv-0001U0-2J@gemulon.postgresql.org
обсуждение исходный текст
Список 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(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: pgsql: Use LOCKBIT_ON() instead of a bit shift in a few places.
Следующее
От: Alvaro Herrera
Дата:
Сообщение: pgsql: COPY: use pg_plan_query() instead of planner()