Re: [HACKERS] MERGE SQL Statement for PG11

Andreas Seltenreich <seltenreich@gmx.de>

From: Andreas Seltenreich <seltenreich@gmx.de>

To: Simon Riggs <simon@2ndquadrant.com>

Cc: Pavel Stehule <pavel.stehule@gmail.com>, Chapman Flack <chap@anastigmatix.net>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2018-02-04T12:15:44Z

Lists: pgsql-hackers

Attachments

TRAP-node-type-T_SubLink-prepunion.sql (application/x-sql)
TRAP-node-type-T_SubLink-clauses.sql (application/x-sql)
TRAP-node-type-T_Query.sql (application/x-sql)

Simon Riggs writes:

> It will likely take some time to work through these and the current
> work items but will fix.
>
> Do you have the DDL so we can recreate these easily?

Attached are testcases that trigger the assertions when run against an
empty database instead of the one left behind by make installcheck.  The
"unrecognized node type" one appears to be a known issue according to
the wiki, so I didn't bother doing the work for this one as well.

regards,
Andreas

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