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 1kkbxX-0003DG-SV for pgsql-hackers@arkaria.postgresql.org; Wed, 02 Dec 2020 23:54:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kkbxW-0006cf-LG for pgsql-hackers@arkaria.postgresql.org; Wed, 02 Dec 2020 23:54:54 +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 1kkbxV-0006Z3-8M for pgsql-hackers@lists.postgresql.org; Wed, 02 Dec 2020 23:54:54 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kkbxR-0007xF-CV for pgsql-hackers@postgresql.org; Wed, 02 Dec 2020 23:54:52 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.nyi.internal (Postfix) with ESMTP id 0F3EF5C0170; Wed, 2 Dec 2020 18:54:46 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute1.internal (MEProxy); Wed, 02 Dec 2020 18:54:46 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=vRL5SiVQjHXKRO5CtaJX04T6xsO tlKp7KJiZvAW+c/A=; b=ufBhhaZ5el/s63yXAotFa2ouOU1LfEBwuZiz05ZPAna ZUsL/sDq+GWelCFOpOocxYRWHDHWyAZ//7FWw2jebf/DZs9TbVhZODedJ9HhTf5+ u3juHp8JLT0EJK5SPJFPAAjigVMbF/TmADwk9X/iiaBXJ6r3erTS6vVAArIXJDkQ 2Dse3XQ6L1TPBzJE0bYCagrQa3auZlM8AuZeNQpqYCbM3y3A4Moa6gaByrdGg+jd OF2LqHsqa2PwrDxW0FtJTvfyTs1qO+ydeUdGSwui+yHM2eG5zcoSuZUDL7CS7rV6 uhqnriQMKoqvQbDmTgo6+wtU6/brf6Fu1Eyh4sCfOHQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=vRL5Si VQjHXKRO5CtaJX04T6xsOtlKp7KJiZvAW+c/A=; b=TQIcOQ8TfukolXab8qgq73 Ng1xDsO8+QOYJVnRnfsNJLDHARAJV8pZyUbjDWqjFijVxMUhLnUQGbT7byerDxLf BrGqz37Fo+Fp7HzhTnrA2TP8SFVmBxyO5/DFXhIyGrHI+uELB4kNKbAjkEBM8snX m5BsXrow/JKPDYxr6jkjc8ElhjculKshsHLSEfEMZbPPeM568UesaHjV99aTDF9I gVdQcysM+7EdbV0y7m/SYTPmDf7vHhjTw59l3wuH6zh+95s5ysrYo+oLaIRo48wI 50/xbA2cHSWOB2Xq/1MonRih0S0ocBa0+NHDzGRIlLADBD6aLRHlb0IUn630Mzdw == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedujedrudeihedgudegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpedvgeduuefhtdeuleettdevjeeh heeiveeuieegleetgeeljeelieeuieehgeevhfenucfkphepudduuddruddtvddrudektd drudekheenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhm pehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id 8F2CC1080059; Wed, 2 Dec 2020 18:54:43 -0500 (EST) Date: Thu, 3 Dec 2020 08:54:39 +0900 From: Michael Paquier To: Tom Lane Cc: Stephen Frost , Peter Eisentraut , pgsql-hackers Subject: Re: SELECT INTO deprecation Message-ID: References: <96dc0df3-e13a-a85d-d045-d6e2c85218da@enterprisedb.com> <20201202175836.GX16415@tamriel.snowman.net> <1672926.1606941346@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="wUn/v6iWV7pGXgfE" Content-Disposition: inline In-Reply-To: <1672926.1606941346@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --wUn/v6iWV7pGXgfE Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, Dec 02, 2020 at 03:35:46PM -0500, Tom Lane wrote: > Yeah, if we want to kill it let's just do so. The negative language in > the reference page has been there since (at least) 7.1, so people can > hardly say they didn't see it coming. +1. I got to wonder about the impact when migrating applications though. SELECT INTO has a different meaning in Oracle, but SQL server creates a new table like Postgres. -- Michael --wUn/v6iWV7pGXgfE Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl/IKT8ACgkQnvQgOdby QH0r/xAAlgRzM+Grkr6hkovCLs1DCnYC4Z+eRV82zpObtG99r4XFvrMPtn7fWmm9 N2YR/lY5MjM++XkFXhEeNGleW6q49p0rbToqUl/GTzVZk548xYQKR/fSeYoW+zJ9 jzg7ERqAHGfPB+z8AUi3g6OQ1mXmApASaDCg2DO9bH5xzkDpaZcEe3f3sTQmrHEp gHbBRu4zNgV5FIb/nmegJkza271v8r9FJ+miGaW3SsPBfPexD1c45VzvFJ132o3H TaagsWB2i4ngDc/wxQDGTGFHG3heTBQul0phh9MTpvX9rsGP3KGIUmuiNpKu/r5W AOr3AWvZa0qqMsQr7jyl9/5HedlmQYuf9TRe88pSdXEW9qqVmgRZd1l7wve9TJFN JmXxpcN3mMING1d5RGdiPhe7DBSk7+RQ+4K8zXE8jSGoN4JT/bTP90SwcY4S5rw7 CnjTndS7rs3qLzbeZ37giNGjqVfzwVOD+H3WFaLXTqscnbLurL67tcdSEHGVgdm4 FUdkQLHWh+2GwnHkWHDduSTIE/XA6zRNOq5kxgmwMzwEB48rEo18ZcY7I8c9C4u9 1qYgEqDToNilx/GDvQxfureheFhxcP0dpLfTLpdhDRM0UFFmKWu4BsQtGUlttmGp 8coO1bN9PKu4G/jIUAz1Y5Q5cy1JBYTUPLn5iKAW0HhOxct6WXw= =TAvt -----END PGP SIGNATURE----- --wUn/v6iWV7pGXgfE--