git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 49ad32d) | patch
Remove the new UPSERT command tag and use INSERT instead.
2015年5月22日 22:49:27 +0000 (00:49 +0200)
2015年5月22日 22:58:45 +0000 (00:58 +0200)
commit 631d7490074cdaef8026db57a5f2772b8730f600
Remove the new UPSERT command tag and use INSERT instead.

Previously, INSERT with ON CONFLICT DO UPDATE specified used a new
command tag -- UPSERT. It was introduced out of concern that INSERT as
a command tag would be a misrepresentation for ON CONFLICT DO UPDATE, as
some affected rows may actually have been updated.

Alvaro Herrera noticed that the implementation of that new command tag
was incomplete; in subsequent discussion we concluded that having it
doesn't provide benefits that are in line with the compatibility breaks
it requires.

Catversion bump due to the removal of PlannedStmt->isUpsert.

Author: Peter Geoghegan
Discussion: 20150520215816.GI5885@postgresql.org
doc/src/sgml/protocol.sgml diff | blob | blame | history
doc/src/sgml/ref/insert.sgml diff | blob | blame | history
src/backend/nodes/copyfuncs.c diff | blob | blame | history
src/backend/nodes/outfuncs.c diff | blob | blame | history
src/backend/optimizer/plan/planner.c diff | blob | blame | history
src/backend/tcop/pquery.c diff | blob | blame | history
src/bin/psql/common.c diff | blob | blame | history
src/include/catalog/catversion.h diff | blob | blame | history
src/include/nodes/plannodes.h diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /