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 1kMtBm-0005Jp-MO for pgsql-bugs@arkaria.postgresql.org; Mon, 28 Sep 2020 13:27:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kMtBl-0003nX-Js for pgsql-bugs@arkaria.postgresql.org; Mon, 28 Sep 2020 13:27:33 +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 1kMtAO-0003mf-OH for pgsql-bugs@lists.postgresql.org; Mon, 28 Sep 2020 13:26:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kMtAL-0006PJ-6l for pgsql-bugs@lists.postgresql.org; Mon, 28 Sep 2020 13:26:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=o9udI/zPEjLeY9xxGCP2+QRBsreynujRctgHrIG6PQs=; b=yGyq2UBrQtSoZ1pj+fMsAvo+6f ea+/BsfVUx5iUV1lJAPMHTH0ZatX5JZGShfR+iXVRIQqWMKbP/IqKnp9rnPvIGipdRDv/WNDnj9xQ a6U77L9TzBgyw3WuGjhQ0IhADFpLw5HS0hdMg+Vg2ycfIkh0hCWhrdgRuyVkctLcn5QIxq+kT7WtM cwmuC/LCu8kvIiI/3jwYZ/EulTwr+cNnKSE0qpX5P49Wm9LL931Ex77IA0WljvsMfFRgPQ/xdGOXH m3J6SjrA55BRn11Lrv51sCG53BlWnCk915KTKNI48J4DaB20cqXcdNQ/DaIy7QnUUoJqBulW+sAph sKAYw1+Q==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kMtAJ-0000cC-JF for pgsql-bugs@lists.postgresql.org; Mon, 28 Sep 2020 13:26:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kMtAI-00024a-CP for pgsql-bugs@lists.postgresql.org; Mon, 28 Sep 2020 13:26:02 +0000 Content-Type: multipart/mixed; boundary="===============8439586383722141610==" MIME-Version: 1.0 Subject: BUG #16639: Syntax error in pgsql when executing local \copy instead of SQL copy To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: buschmann@nidsa.net Reply-To: buschmann@nidsa.net, pgsql-bugs@lists.postgresql.org Date: Mon, 28 Sep 2020 13:25:08 +0000 Message-ID: <16639-ec6ab8b4776f64b2@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============8439586383722141610== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjYzOQpMb2dnZWQgYnk6ICAgICAgICAgIEhhbnMgQnVzY2htYW5uCkVt YWlsIGFkZHJlc3M6ICAgICAgYnVzY2htYW5uQG5pZHNhLm5ldApQb3N0Z3JlU1FMIHZlcnNpb246 IDEzLjAKT3BlcmF0aW5nIHN5c3RlbTogICBMaW51eCB4NjQgb3IgV2luZG93cyA2NGJpdApEZXNj cmlwdGlvbjogICAgICAgIAoKRGVyaXZpbmcgZnJvbSBhIG11Y2ggbG9uZ2VyIHF1ZXJ5IGluIG91 ciBhcHBsaWNhdGlvbiBJIG1hbmFnZWQgdG8gZXh0cmFjdCBhCnNob3J0IHF1ZXJ5IHdoaWNoIHNo b3dzIHRoZSBlcnJvciBmb3IgJHN1YmplY3Q6DQoNCg0KXGNvcHkgKA0Kd2l0aA0KcWN1c3QgKGN0 cnlfbmFtZSxjbGlfbm9tYnJlKSBhcyAoDQp2YWx1ZXMgDQogKCdERScsJ0NVUzEnKQ0KLCgnREUn LCdDVVMyJykNCiwoJ0RFJywnQ1VTMycpDQosKCdGUicsJ0NVUzYnKQ0KLCgnRlInLCdDVVM4JykN CikNCi0tIHNlbGVjdCAqIGZyb20gcWN1c3Q7DQoscWN0cnkgKGN0cnlfbmFtZSxjbGlfbm9tYnJl KSBhcyAoDQp2YWx1ZXMgDQogKCdERScsJ3p6eiBTVU1NJykNCiwoJ0ZSJywnenp6IFNVTU0nKQ0K KQ0KLS0gc2VsZWN0ICogZnJvbSBxY3RyeTsNCnNlbGVjdCAqIGZyb20gcWN1c3QNCnVuaW9uIGFs bA0Kc2VsZWN0ICogZnJvbSBxY3RyeQ0Kb3JkZXIgYnkgY3RyeV9uYW1lLGNsaV9ub21icmUNCikg dG8gc3Rkb3V0IHdpdGggKGZvcm1hdCBjc3YsZGVsaW1pdGVyICc7JywgaGVhZGVyIDEpDQo7DQoN ClRoaXMgZ2l2ZXMgdGhlIGVycm9yIGluIHBnc3FsOg0KRVJST1I6ICBzeW50YXggZXJyb3IgYXQg b3IgbmVhciAiKSINCkxJTkUgMjE6ICkgdG8gc3Rkb3V0IHdpdGggKGZvcm1hdCBjc3YsZGVsaW1p dGVyICc7JywgaGVhZGVyIDEpDQogICAgICAgICBeDQoNCndoZW4gZXhlY3V0aW5nIHRoZSBTUUwg Y29weSBjb21tYW5kIChzYW1lIGFzIGFib3ZlIHdpdGhvdXQgXCApIHRoZSBxdWVyeQpzdWNjZWVk czoNCg0KZGI9IyBjb3B5ICgNCmRiKCMgd2l0aA0KZGIoIyBxY3VzdCAoY3RyeV9uYW1lLGNsaV9u b21icmUpIGFzICgNCmRiKCMgdmFsdWVzDQpkYigjICAoJ0RFJywnQ1VTMScpDQpkYigjICwoJ0RF JywnQ1VTMicpDQpkYigjICwoJ0RFJywnQ1VTMycpDQpkYigjICwoJ0ZSJywnQ1VTNicpDQpkYigj ICwoJ0ZSJywnQ1VTOCcpDQpkYigjICkNCmRiKCMgLS0gc2VsZWN0ICogZnJvbSBxY3VzdDsNCmRi KCMgLHFjdHJ5IChjdHJ5X25hbWUsY2xpX25vbWJyZSkgYXMgKA0KZGIoIyB2YWx1ZXMNCmRiKCMg ICgnREUnLCd6enogU1VNTScpDQpkYigjICwoJ0ZSJywnenp6IFNVTU0nKQ0KZGIoIyApDQpkYigj IC0tIHNlbGVjdCAqIGZyb20gcWN0cnk7DQpkYigjIHNlbGVjdCAqIGZyb20gcWN1c3QNCmRiKCMg dW5pb24gYWxsDQpkYigjIHNlbGVjdCAqIGZyb20gcWN0cnkNCmRiKCMgb3JkZXIgYnkgY3RyeV9u YW1lLGNsaV9ub21icmUNCmRiKCMgKSB0byBzdGRvdXQgd2l0aCAoZm9ybWF0IGNzdixkZWxpbWl0 ZXIgJzsnLCBoZWFkZXIgMSkNCmRiLSMgOw0KY3RyeV9uYW1lO2NsaV9ub21icmUNCkRFO0NVUzEN CkRFO0NVUzINCkRFO0NVUzMNCkRFO3p6eiBTVU1NDQpGUjtDVVM2DQpGUjtDVVM4DQpGUjt6enog U1VNTQ0KDQpUaGlzIG9jY3VyZWQgZmlyc3Qgb24gcHNxbCAodjEzLjAsIFdpbjY0KSBjb25uZWN0 ZWQgdG8gc2VydmVyICh2MTMuMCwKTGludXg2NCkuDQoNCkJ1dCBpdCBpcyBhbHNvIHByZXNlbnQg b24gTGludXg2NCBvbmx5IGFuZCBhbHNvIG9uIFBHIDEyLjQgV2luNjQgKG90aGVyCnZlcnNpb25z IG5vdCB0ZXN0ZWQpLg0KDQpUaGUgZXJyb3Igc2VlbXMgdG8gYmUgaW5kZXBlbmRhbnQgb2YgcGxh dGZvcm0gYW5kIHZlcnNpb24uDQoNCg0KRW52aXJvbm1lbnQgKG9mZmljaWFsIHJlbGVhc2VzIG9m IFBHMTMpOg0KDQpkYj0jIHNlbGVjdCB2ZXJzaW9uICgpOw0KICAgICAgICAgICAgICAgICAgICAg ICAgICB2ZXJzaW9uDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0NCiBQb3N0Z3JlU1FMIDEyLjQsIGNvbXBpbGVkIGJ5IFZpc3VhbCBD KysgYnVpbGQgMTkxNCwgNjQtYml0DQooMSByb3cpDQoNCmRiPSMgXHNldA0KLi4uDQpWRVJTSU9O ID0gJ1Bvc3RncmVTUUwgMTMuMCwgY29tcGlsZWQgYnkgVmlzdWFsIEMrKyBidWlsZCAxOTE0LCA2 NC1iaXQnDQpWRVJTSU9OX05BTUUgPSAnMTMuMCcNCg0KYW5kDQoNCmRiPSMgc2VsZWN0IHZlcnNp b24gKCk7DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg dmVyc2lvbg0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LQ0KIFBvc3RncmVTUUwgMTMuMCBvbiB4ODZfNjQtcGMtbGludXgtZ251LCBjb21waWxlZCBieSBn Y2MgKEdDQykgMTAuMi4xCjIwMjAwNzIzIChSZWQgSGF0IDEwLjIuMS0xKSwgNjQtYml0DQooMSBa ZWlsZSkKCg== --===============8439586383722141610==--