python-sql

Bug 57

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:31cedsettitle: Add MERGE -> Add MERGE/ON CONFLICT
2021-09-10 16:17:15cedsetmessages: + msg144
2018-04-21 17:48:52cedcreate