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 1l7KjH-0004sd-RX for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Feb 2021 16:10:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l7KjG-0000J7-PY for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Feb 2021 16:10:06 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l7KjF-0000IR-Rg for pgsql-hackers@lists.postgresql.org; Wed, 03 Feb 2021 16:10:06 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l7KjD-00037n-Im for pgsql-hackers@postgresql.org; Wed, 03 Feb 2021 16:10:04 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id 5EE9C5C0216; Wed, 3 Feb 2021 11:10:02 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Wed, 03 Feb 2021 11:10:02 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:subject:to :x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; bh=3+KjmJ7DSAmVBulaj66MvyyBUmPRzHpfNFdn6bspg/E=; b=sxw4+zk8 qtGAc/ceOXZszZtp6/1OYxK2HYZvG6ZOliZk3OOFUSRjubkxUkA2W2F8dGOWBl+6 FTNEukE7ZSdBRIhBdbxK5VweUGfpGx51Nj/XRfpknKJQJvPcVAyyLuI22ojx5L3f 6XSNgpPmCOKXvgoy0zJMNA7w2Yfy3/Nt2q/fxnVloM4dnfDHwynEx1EHDkbcZSJu 6LNAalH1phwZV7dgO3FlGvUsWxIi70gsuG3eu8l6PFcpm2cXV5GNC6D7CA5QHpzB qvN6OPx2Bx4As88b5AKe3m/D4/pdpXnHVDuATt4TSwlnUMOADK374tRngvozvfmi K4n0ANQLiZjnFA== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrgedvgdekfecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpeffhffvuffkgggtugfgjggfsehtkeertddtredunecuhfhrohhmpeetlhhvrghr ohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhgqe enucggtffrrghtthgvrhhnpeduvedttdeuuddvjeektefghfduvdethedvhefhtefgieek tdefuddtvdekteehgeenucffohhmrghinhepshhlrghshhguohhtrdhorhhgnecukfhppe duledtrdelhedrudelrddujeejnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghm pehmrghilhhfrhhomheprghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh X-ME-Proxy: Received: from perhan.alvh.no-ip.org (unknown [190.95.19.177]) by mail.messagingengine.com (Postfix) with ESMTPA id 205BE24005E; Wed, 3 Feb 2021 11:10:01 -0500 (EST) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 92C212A0E0B; Wed, 3 Feb 2021 13:09:58 -0300 (-03) Date: Wed, 3 Feb 2021 13:09:58 -0300 From: Alvaro Herrera To: Tom Lane Cc: Heikki Linnakangas , pgsql-hackers Subject: Re: Removing support for COPY FROM STDIN in protocol version 2 Message-ID: <20210203160958.GA2341@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <3908079.1612368052@sss.pgh.pa.us> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2021-Feb-03, Tom Lane wrote: > I have a vague recollection that JDBC users still like to use > protocol 2 for some reason --- is that out of date? 2016: commit c3d8571e53cc5b702dae2f832b02c872ad44c3b7 Author: Vladimir Sitnikov AuthorDate: Sat Aug 6 12:22:17 2016 +0300 CommitDate: Sat Aug 13 11:27:16 2016 +0300 fix: support cases when user-provided queries have 'returning' This change includes: drop v2 protocol support, and query parsing refactoring. Currently query parse cache is still per-connection, however "returningColumNames" are part of cache key, thus the parse cache can be made global. This fixes #488 (see org.postgresql.test.jdbc3.GeneratedKeysTest) This commit does remove all files in pgjdbc/src/main/java/org/postgresql/core/v2/, leaving only "v3/". -- Álvaro Herrera Valdivia, Chile "Those who use electric razors are infidels destined to burn in hell while we drink from rivers of beer, download free vids and mingle with naked well shaved babes." (http://slashdot.org/comments.pl?sid=44793&cid=4647152)