Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bV2ux-0003Xx-Ko for pgsql-committers@arkaria.postgresql.org; Wed, 03 Aug 2016 20:37:31 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bV2ux-0008Fu-1s for pgsql-committers@arkaria.postgresql.org; Wed, 03 Aug 2016 20:37:31 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bV2ui-000824-Ue for pgsql-committers@postgresql.org; Wed, 03 Aug 2016 20:37:17 +0000 Received: from mahout.postgresql.org ([2001:4800:1501:1::227]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bV2ub-0001WE-Js for pgsql-committers@postgresql.org; Wed, 03 Aug 2016 20:37:15 +0000 Received: from gemulon.postgresql.org ([2001:4800:1501:1::198]) by mahout.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bV2ub-0000f6-CU for pgsql-committers@postgresql.org; Wed, 03 Aug 2016 20:37:09 +0000 Received: from git by gemulon.postgresql.org with local (Exim 4.84_2) (envelope-from ) id 1bV2ua-0007wK-TW for pgsql-committers@postgresql.org; Wed, 03 Aug 2016 20:37:08 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 To: pgsql-committers@postgresql.org From: Tom Lane Subject: pgsql: Make INSERT-from-multiple-VALUES-rows handle targetlist indirect Message-Id: Date: Wed, 03 Aug 2016 20:37:08 +0000 X-Pg-Spam-Score: -8.1 (--------) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-committers Precedence: bulk Sender: pgsql-committers-owner@postgresql.org TWFrZSBJTlNFUlQtZnJvbS1tdWx0aXBsZS1WQUxVRVMtcm93cyBoYW5kbGUg dGFyZ2V0bGlzdCBpbmRpcmVjdGlvbiBiZXR0ZXIuCgpQcmV2aW91c2x5LCBp ZiBhbiBJTlNFUlQgd2l0aCBtdWx0aXBsZSByb3dzIG9mIFZBTFVFUyBoYWQg aW5kaXJlY3Rpb24KKGFycmF5IHN1YnNjcmlwdGluZyBvciBmaWVsZCBzZWxl Y3Rpb24pIGluIGl0cyB0YXJnZXQtY29sdW1ucyBsaXN0LCB0aGUKcGFyc2Vy IGhhbmRsZWQgdGhhdCBieSBhcHBseWluZyB0cmFuc2Zvcm1Bc3NpZ25lZEV4 cHIoKSB0byBlYWNoIGVsZW1lbnQKb2YgZWFjaCBWQUxVRVMgcm93IGluZGVw ZW5kZW50bHkuICBUaGlzIGxlZCB0byBoYXZpbmcgQXJyYXlSZWYgYXNzaWdu bWVudApub2RlcyBvciBGaWVsZFN0b3JlIG5vZGVzIGluIGVhY2ggcm93IG9m IHRoZSBWQUxVRVMgUlRFLiAgVGhhdCB3b3JrcyBmb3IKc2ltcGxlIGNhc2Vz LCBidXQgaW4gYnVnICMxNDI2NSBOdXJpIEJvYXJkbWFuIHBvaW50cyBvdXQg dGhhdCBpdCBmYWlscwppZiB0aGVyZSBhcmUgbXVsdGlwbGUgYXNzaWdubWVu dHMgdG8gZWxlbWVudHMvZmllbGRzIG9mIHRoZSBzYW1lIHRhcmdldApjb2x1 bW4uICBGb3Igc3VjaCBjYXNlcyB0byB3b3JrLCByZXdyaXRlVGFyZ2V0TGlz dElVKCkgaGFzIHRvIG5lc3QgdGhlCkFycmF5UmVmcyBvciBGaWVsZFN0b3Jl cyB0b2dldGhlciB0byBwcm9kdWNlIGEgc2luZ2xlIGV4cHJlc3Npb24gdG8g YmUKYXNzaWduZWQgdG8gdGhlIGNvbHVtbi4gIEJ1dCBpdCBmYWlsZWQgdG8g ZmluZCB0aGVtIGluIHRoZSB0b3AtbGV2ZWwKdGFyZ2V0bGlzdCBhbmQgaXNz dWVkIGFuIGVycm9yIGFib3V0ICJtdWx0aXBsZSBhc3NpZ25tZW50cyB0byBz YW1lIGNvbHVtbiIuCgpXZSBjb3VsZCBwb3NzaWJseSBmaXggdGhpcyBieSB0 ZWFjaGluZyB0aGUgcmV3cml0ZXIgdG8gYXBwbHkKcmV3cml0ZVRhcmdldExp c3RJVSB0byBlYWNoIFZBTFVFUyByb3cgc2VwYXJhdGVseSwgYnV0IHRoYXQg d291bGQgYmUgbWVzc3kKKGl0IHdvdWxkIGNoYW5nZSB0aGUgb3V0cHV0IHJv d3R5cGUgb2YgdGhlIFZBTFVFUyBSVEUsIGZvciBleGFtcGxlKSBhbmQKaW5l ZmZpY2llbnQuICBJbnN0ZWFkLCBsZXQncyBmaXggdGhlIHBhcnNlciBzbyB0 aGF0IHRoZSBWQUxVRVMgUlRFIG91dHB1dHMKYXJlIGp1c3QgdGhlIHVzZXIt c3BlY2lmaWVkIHZhbHVlcywgY2FzdCB0byB0aGUgcmlnaHQgdHlwZSBpZiBu ZWNlc3NhcnksCmFuZCB0aGVuIHRoZSBBcnJheVJlZnMgb3IgRmllbGRTdG9y ZXMgYXJlIGFwcGxpZWQgaW4gdGhlIHRvcC1sZXZlbAp0YXJnZXRsaXN0IHRv IFZhcnMgcmVwcmVzZW50aW5nIHRoZSBSVEUncyBvdXRwdXRzLiAgVGhpcyBp cyB0aGUgc2FtZQpwYXJzZXRyZWUgcmVwcmVzZW50YXRpb24gYWxyZWFkeSB1 c2VkIGZvciBzaW1pbGFyIGNhc2VzIHdpdGggSU5TRVJUL1NFTEVDVApzeW50 YXgsIHNvIGl0IGFsbG93cyBzaW1wbGlmaWNhdGlvbnMgaW4gcnVsZXV0aWxz LmMsIHdoaWNoIG5vIGxvbmdlciBuZWVkcwp0byB0cmVhdCBJTlNFUlQtZnJv bS1tdWx0aXBsZS1WQUxVRVMgYXMgaXRzIG93biBzcGVjaWFsIGNhc2UuCgpU aGlzIGltcGxlbWVudGF0aW9uIHdvcmtzIGJ5IGFwcGx5aW5nIHRyYW5zZm9y bUFzc2lnbmVkRXhwciB0byB0aGUgVkFMVUVTCmVudHJpZXMgYXMgYmVmb3Jl LCBhbmQgdGhlbiBzdHJpcHBpbmcgb2ZmIGFueSBBcnJheVJlZnMgb3IgRmll bGRTdG9yZXMgaXQKYWRkcy4gIFdpdGggbG90cyBvZiBWQUxVRVMgcm93cyBp dCB3b3VsZCBiZSBub3RpY2VhYmx5IG1vcmUgZWZmaWNpZW50IHRvCm5vdCBh ZGQgdGhvc2Ugbm9kZXMgaW4gdGhlIGZpcnN0IHBsYWNlLiAgQnV0IHRoYXQn cyBqdXN0IGFuIG9wdGltaXphdGlvbgpub3QgYSBidWcgZml4LCBhbmQgdGhl cmUgZG9lc24ndCBzZWVtIHRvIGJlIGFueSBnb29kIHdheSB0byBkbyBpdCB3 aXRob3V0CnNpZ25pZmljYW50IHJlZmFjdG9yaW5nLiAgKEEgbm9uLWludmFz aXZlIGFuc3dlciB3b3VsZCBiZSB0byBhcHBseQp0cmFuc2Zvcm1Bc3NpZ25l ZEV4cHIgKyBzdHJpcHBpbmcgdG8ganVzdCB0aGUgZmlyc3QgVkFMVUVTIHJv dywgYW5kIHRoZW4KanVzdCBmb3JjaWJseSBjYXN0IHJlbWFpbmluZyByb3dz IHRvIHRoZSBzYW1lIGRhdGEgdHlwZXMgZXhwb3NlZCBpbiB0aGUKZmlyc3Qg cm93LiAgQnV0IHRoaXMgd2F5IHdvdWxkIGxlYWQgdG8gZGlmZmVyZW50LCBu b3QtSU5TRVJULXNwZWNpZmljCmVycm9ycyBiZWluZyByZXBvcnRlZCBpbiBj YXN0aW5nIGZhaWx1cmUgY2FzZXMsIHNvIGl0IGRvZXNuJ3Qgc2VlbSB2ZXJ5 Cm5pY2UuKSAgU28gbGVhdmUgdGhhdCBmb3IgbGF0ZXI7IHRoaXMgcGF0Y2gg YXQgbGVhc3QgaXNuJ3QgbWFraW5nIHRoZQpwZXItcm93IHBhcnNpbmcgd29y ayB3b3JzZSwgYW5kIGl0IGRvZXMgbWFrZSB0aGUgZmluaXNoZWQgcGFyc2V0 cmVlCnNtYWxsZXIsIHNhdmluZyByZXdyaXRlciBhbmQgcGxhbm5lciB3b3Jr LgoKQ2F0dmVyc2lvbiBidW1wIGJlY2F1c2Ugc3RvcmVkIHJ1bGVzIGNvbnRh aW5pbmcgc3VjaCBJTlNFUlRzIHdvdWxkIG5lZWQKdG8gY2hhbmdlLiAgQmVj YXVzZSBvZiB0aGF0LCBubyBiYWNrLXBhdGNoLCBldmVuIHRob3VnaCB0aGlz IGlzIGEgdmVyeQpsb25nLXN0YW5kaW5nIGJ1Zy4KClJlcG9ydDogPDIwMTYw NzI3MDA1NzI1Ljc0MzguMjYwMjFAd3JpZ2xleXMucG9zdGdyZXNxbC5vcmc+ CkRpc2N1c3Npb246IDw5NTc4LjE0Njk2NDUyNDVAc3NzLnBnaC5wYS51cz4K CkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cDov L2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmL2EzYzdhOTkzZDVl YjI5ZGY0ZDMzMDc1YjgzYzc1YWUyNWYyNTc4OTcKCk1vZGlmaWVkIEZpbGVz Ci0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL3BhcnNlci9hbmFseXplLmMg ICAgICAgICB8IDY1ICsrKysrKysrKysrKysrKysrKysrKysrKystLS0tCnNy Yy9iYWNrZW5kL3V0aWxzL2FkdC9ydWxldXRpbHMuYyAgICB8IDYwICsrKysr KysrKy0tLS0tLS0tLS0tLS0tLS0tLQpzcmMvaW5jbHVkZS9jYXRhbG9nL2Nh dHZlcnNpb24uaCAgICAgfCAgMiArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVj dGVkL2luc2VydC5vdXQgfCA3OSArKysrKysrKysrKysrKysrKysrKysrKysr KysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvaW5zZXJ0LnNxbCAg ICAgIHwgNDggKysrKysrKysrKysrKysrKysrKysrKwo1IGZpbGVzIGNoYW5n ZWQsIDIwNSBpbnNlcnRpb25zKCspLCA0OSBkZWxldGlvbnMoLSkKCgotLSAK U2VudCB2aWEgcGdzcWwtY29tbWl0dGVycyBtYWlsaW5nIGxpc3QgKHBnc3Fs LWNvbW1pdHRlcnNAcG9zdGdyZXNxbC5vcmcpClRvIG1ha2UgY2hhbmdlcyB0 byB5b3VyIHN1YnNjcmlwdGlvbjoKaHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9y Zy9tYWlscHJlZi9wZ3NxbC1jb21taXR0ZXJzCg==