Bug 57: Add MERGE/ON CONFLICT - python-sql tracker

classification

Title:	Add MERGE/ON CONFLICT
Type:	rfe	Severity:	normal
Components:		Versions:

process

Status:	new	Resolution:
Dependencies:		Superseder:
Assigned To:		Nosy List:	ced
Priority:	low	Keywords:

Created on 2018-04-21 17:48 by ced, last changed 2021-09-10 16:17 by ced.

Messages
msg65	Author: [hidden] (ced)	Date: 2018-04-21 17:48
The new MERGE command will be available in PostgreSQL 11. https://www.depesz.com/2018/04/10/waiting-for-postgresql-11-merge-sql-command-following-sql2016/
msg144	Author: [hidden] (ced)	Date: 2021-09-10 16:17
Indeed MERGE is still not in PostgreSQL but any way its usage is not well defined against concurrency according to PG developers. So there is the non standard "ON CONFLICT" that PostgreSQL and SQLite implements: https://modern-sql.com/blog/2019-01/sqlite-in-2018#upsert

History
Date	User	Action	Args
2021-09-10 16:17:31	ced	set	title: Add MERGE -> Add MERGE/ON CONFLICT
2021-09-10 16:17:15	ced	set	messages: + msg144
2018-04-21 17:48:52	ced	create