Re: [HACKERS] MERGE SQL Statement for PG11
Bruce Momjian <bruce@momjian.us>
From: Bruce Momjian <bruce@momjian.us>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Robert Haas <robertmhaas@gmail.com>, Alvaro Herrera <alvherre@alvh.no-ip.org>, Andrew Dunstan <andrew.dunstan@2ndquadrant.com>, Pavan Deolasee <pavan.deolasee@2ndquadrant.com>, Peter Geoghegan <pg@bowt.ie>, Stephen Frost <sfrost@snowman.net>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2018-01-29T16:44:22Z
Lists: pgsql-hackers
On Mon, Jan 29, 2018 at 04:34:48PM +0000, Simon Riggs wrote: > I agree with all of the above. > > In terms of timing of commits, I have marked the patch Ready For > Committer. To me that signifies that it is ready for review by a > Committer prior to commit. > > In case of doubt, I would not even suggest committing this if it had > any concurrency issues. That would be clearly unacceptable. > > The only discussion would be about the word "unfinished". I'm not > clear why this patch, which has current caveats all clearly indicated > in the docs, differs substantially from other projects that have > committed their work ahead of having everything everybody wants, such > as replication, materialized views, parallel query, partitioning, > logical decoding etc.. All of those features had caveats in the first > release in which they were included and many of them were committed > prior to the last CF. We are working now to remove those caveats. Why > is this different? It shouldn't be. If unfinished means it has caveats > that is different to unfinished meaning crappy, risky, contentious > etc.. I think the question is how does it handle cases it doesn't support? Does it give wrong answers? Does it give a helpful error message? Can you summarize that? -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +
Commits
-
Add support for MERGE SQL command
- 7103ebb7aae8 15.0 landed
-
Add API of sorts for transition table handling in trigger.c
- 3a46a45f6f00 15.0 landed
-
Revert MERGE patch
- 08ea7a2291db 11.0 cited
-
Fix several bugs related to ON CONFLICT's EXCLUDED pseudo relation.
- ad2278379244 9.6.0 cited