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 1oxcyY-0003eA-VZ for pgsql-committers@arkaria.postgresql.org; Tue, 22 Nov 2022 23:46:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oxcyX-0001o9-3D for pgsql-committers@arkaria.postgresql.org; Tue, 22 Nov 2022 23:46:49 +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 1oxcyW-0001o0-Py for pgsql-committers@lists.postgresql.org; Tue, 22 Nov 2022 23:46:48 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oxcyP-0006JO-WB for pgsql-committers@lists.postgresql.org; Tue, 22 Nov 2022 23:46:47 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oxcyP-00077d-7S for pgsql-committers@lists.postgresql.org; Tue, 22 Nov 2022 23:46:41 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1oxcyN-000Q6h-3b for pgsql-committers@lists.postgresql.org; Tue, 22 Nov 2022 23:46:40 +0000 Content-Type: multipart/mixed; boundary="===============7474371048893706203==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Give better hints for ambiguous or unreferenceable columns. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 22 Nov 2022 23:46:40 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7474371048893706203== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 R2l2ZSBiZXR0ZXIgaGludHMgZm9yIGFtYmlndW91cyBvciB1bnJlZmVyZW5jZWFibGUgY29sdW1u cy4KCkV4YW1pbmUgUGFyc2VOYW1lc3BhY2VJdGVtIGZsYWdzIHRvIGRldGVjdCB3aGV0aGVyIGEg Y29sdW1uIG5hbWUKaXMgdW5yZWZlcmVuY2VhYmxlIGZvciBsYWNrIG9mIExBVEVSQUwsIG9yIGNv dWxkIGJlIHJlZmVyZW5jZWQgaWYKYSBxdWFsaWZpZWQgbmFtZSB3ZXJlIHVzZWQsIGFuZCBnaXZl IGJldHRlciBoaW50cyBmb3Igc3VjaCBjYXNlcy4KQWxzbywgZG9uJ3QgcGhyYXNlIHRoZSBtZXNz YWdlIHRvIGltcGx5IHRoYXQgdGhlcmUncyBvbmx5IG9uZQptYXRjaGluZyBjb2x1bW4gd2hlbiB0 aGVyZSBpcyByZWFsbHkgbW9yZSB0aGFuIG9uZS4KCk1hbnkgb2YgdGhlIHJlZ3Jlc3Npb24gdGVz dCBvdXRwdXQgY2hhbmdlcyBhcmUgbm90IHZlcnkgaW50ZXJlc3RpbmcsCmJ1dCBqdXN0IHJlZmxl Y3QgcmVjbGFzc2lmeWluZyB0aGUgIlRoZXJlIGlzIGEgY29sdW1uIC4uLiBidXQgaXQKY2Fubm90 IGJlIHJlZmVyZW5jZWQgZnJvbSB0aGlzIHBhcnQgb2YgdGhlIHF1ZXJ5IiBtZXNzYWdlcyBhcyBE RVRBSUwKcmF0aGVyIHRoYW4gSElOVC4gIFRoZXkgYXJlIGRldGFpbHMgcGVyIG91ciBzdHlsZSBn dWlkZSwgaW4gdGhlIHNlbnNlCm9mIGJlaW5nIGZhY3R1YWwgcmF0aGVyIHRoYW4gb2ZmZXJpbmcg YWR2aWNlOyBhbmQgdGhpcyBjaGFuZ2UgcHJvdmlkZXMKcm9vbSB0byBvZmZlciBhY3R1YWwgSElO VHMgYWJvdXQgd2hhdCB0byBkby4KCldoaWxlIGhlcmUsIGFkanVzdCB0aGUgZnV6enktbmFtZS1t YXRjaGluZyBjb2RlIHRvIGJlIGEgc2hhZGUgbGVzcwppbXBlbmV0cmFibGUuICBJdCB3YXMgb3Zl cmxvYWRpbmcgdGhlIG1lYW5pbmdzIG9mIEZ1enp5QXR0ck1hdGNoU3RhdGUKZmllbGRzIHdheSB0 b28gbXVjaCBJTU8sIHNvIHNwbGl0dGluZyB0aGVtIGludG8gbXVsdGlwbGUgZmllbGRzIHNlZW1z CnRvIG1ha2UgaXQgY2xlYXJlci4gIEl0J3Mgbm90IGxpa2Ugd2UgbmVlZCB0byBzaGF2ZSBieXRl cyBpbiB0aGF0CnN0cnVjdC4KClBlciBkaXNjdXNzaW9uIG9mIGJ1ZyAjMTcyMzMgZnJvbSBBbGV4 YW5kZXIgS29yb2xldi4KCkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vMTcyMzMtYWZi OWQ4MDZhYWE2NGIxN0Bwb3N0Z3Jlc3FsLm9yZwoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFp bHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzU2ZDBl ZDNiNzU2YjJlMzc5OWE3YmJjMGFjODliYzc2NTdjYTJjMzMKCk1vZGlmaWVkIEZpbGVzCi0tLS0t LS0tLS0tLS0tCnNyYy9iYWNrZW5kL3BhcnNlci9wYXJzZV9yZWxhdGlvbi5jICAgICAgICAgICB8 IDI5MSArKysrKysrKysrKysrKysrKystLS0tLS0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVk L2luc2VydF9jb25mbGljdC5vdXQgfCAgIDIgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9q b2luLm91dCAgICAgICAgICAgIHwgIDMxICsrLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL21l cmdlLm91dCAgICAgICAgICAgfCAgIDggKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9ydWxl cy5vdXQgICAgICAgICAgIHwgICAzICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvdW5pb24u b3V0ICAgICAgICAgICB8ICAgMiArLQpzcmMvdGVzdC9yZWdyZXNzL3NxbC9qb2luLnNxbCAgICAg ICAgICAgICAgICAgfCAgIDIgKwo3IGZpbGVzIGNoYW5nZWQsIDIzMyBpbnNlcnRpb25zKCspLCAx MDYgZGVsZXRpb25zKC0pCgo= --===============7474371048893706203==--