Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nT3na-00037I-DV for pgsql-hackers@arkaria.postgresql.org; Sat, 12 Mar 2022 15:36:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nT3nY-0003zX-Gz for pgsql-hackers@arkaria.postgresql.org; Sat, 12 Mar 2022 15:36:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nT3nX-0003zO-Cv for pgsql-hackers@lists.postgresql.org; Sat, 12 Mar 2022 15:36:52 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nT3nT-00085n-MW for pgsql-hackers@lists.postgresql.org; Sat, 12 Mar 2022 15:36:51 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id 112875C010F; Sat, 12 Mar 2022 10:36:45 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Sat, 12 Mar 2022 10:36:45 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:date:date:from:from:in-reply-to:in-reply-to :message-id:mime-version:reply-to:sender:subject:subject:to:to :x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; bh=dSQ3UtnEDtK8IZL8KhfTYOrrmuhGL/4GIjH1+OvvN84=; b=Fxu7W8Zc HD0V1CzBLLd/MNUw3LNpAT0+rXajKY+Mp+GQ7jALpUCl8hrk378tM8XkBlBLNBmD BZNBtUfuyQgev1G6c7aRt/xCSme9CSSyIkh10bGRAB4njkztDD5f0h6isgAIWoF1 IdovviET2THrfHffweAiAQkYVsIg9wEefkeI/fla9nBm4K3axMypGdkrAKw3gO41 V7h3v78Kopjnv9Oe5KUHWhmROUiczyQfg2MTvpECMERh2mnGvCo/cF0OErnIrX3O lC82PIsVogtnetqkBFtg7MmZeOoXadqhW2HM7d1cuRektTJcON/UMAA1Xx63DtdV Dc4u2w6IJbAT2Q== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvvddruddvgedgjeekucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvffukfggtggugfgjsehtkeertddttdejnecuhfhrohhmpeetlhhvrghr ohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhgqe enucggtffrrghtthgvrhhnpedujeevjeffjeevuddutedvkeeiueeitddvieelfeekveej udefgeeuvdejhfeuleenucffohhmrghinhepvghnthgvrhhprhhishgvuggsrdgtohhmne cuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhh vghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 12 Mar 2022 10:36:43 -0500 (EST) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id B0C0B2A5491; Sat, 12 Mar 2022 12:36:39 -0300 (-03) Date: Sat, 12 Mar 2022 12:36:39 -0300 From: Alvaro Herrera To: Zhihong Yu , Simon Riggs Cc: Pg Hackers , Tomas Vondra , Daniel Westermann , Amit Langote , Justin Pryzby , Japin Li , Erik Rijkers , Jaime Casanova , Andres Freund Subject: Re: support for MERGE Message-ID: <202203121536.dznsztdtsx6h@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <202203120353.sdof7mld5qfc@alvherre.pgsql> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk FYI I intend to get the ModifyTable split patch (0001+0003) pushed hopefully on Tuesday or Wednesday next week, unless something really ugly is found on it. As for MERGE proper, I'm aiming at getting that one pushed on the week starting March 21st, though of course I'll spend some more time on it and will probably post further versions of it before that. -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/ Thou shalt check the array bounds of all strings (indeed, all arrays), for surely where thou typest "foo" someone someday shall type "supercalifragilisticexpialidocious" (5th Commandment for C programmers)