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 1n9e5q-0000rK-PK for pgsql-committers@arkaria.postgresql.org; Tue, 18 Jan 2022 02:19:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n9e5o-0003Nk-Ax for pgsql-committers@arkaria.postgresql.org; Tue, 18 Jan 2022 02:19:28 +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 1n9e5o-0003Na-3p for pgsql-committers@lists.postgresql.org; Tue, 18 Jan 2022 02:19:28 +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 1n9e5l-0005K9-4R for pgsql-committers@lists.postgresql.org; Tue, 18 Jan 2022 02:19:26 +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 1n9e5k-0003cR-9H for pgsql-committers@lists.postgresql.org; Tue, 18 Jan 2022 02:19:24 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n9e5j-0007PA-Ut for pgsql-committers@lists.postgresql.org; Tue, 18 Jan 2022 02:19:23 +0000 Content-Type: multipart/mixed; boundary="===============2198159866286411182==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix psql \d's query for identifying parent triggers. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 18 Jan 2022 02:19:23 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2198159866286411182== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHBzcWwgXGQncyBxdWVyeSBmb3IgaWRlbnRpZnlpbmcgcGFyZW50IHRyaWdnZXJzLgoKVGhl IG9yaWdpbmFsIGNvZGluZyAoZnJvbSBjMzM4NjljYzMpIGZhaWxlZCB3aXRoICJtb3JlIHRoYW4g b25lIHJvdwpyZXR1cm5lZCBieSBhIHN1YnF1ZXJ5IHVzZWQgYXMgYW4gZXhwcmVzc2lvbiIgaWYg dGhlcmUgd2VyZSB1bnJlbGF0ZWQKdHJpZ2dlcnMgb2YgdGhlIHNhbWUgdGduYW1lIG9uIHBhcmVu dCBwYXJ0aXRpb25lZCB0YWJsZXMuICAoVGhhdCdzCnBvc3NpYmxlIGJlY2F1c2Ugc3RhdGVtZW50 LWxldmVsIHRyaWdnZXJzIGRvbid0IGdldCBpbmhlcml0ZWQuKSAgRml4CmJ5IGFwcGx5aW5nIExJ TUlUIDEgYWZ0ZXIgc29ydGluZyB0aGUgY2FuZGlkYXRlcyBieSBpbmhlcml0YW5jZSBsZXZlbC4K CkFsc28sIHdyYXAgdGhlIHN1YnF1ZXJ5IGluIGEgQ0FTRSBzbyB0aGF0IHdlIGRvbid0IGhhdmUg dG8gZXhlY3V0ZSBpdCBhdAphbGwgd2hlbiB0aGUgdHJpZ2dlciBpcyB2aXNpYmx5IG5vbi1pbmhl cml0ZWQuICBBc2lkZSBmcm9tIHNhdmluZyBzb21lCmN5Y2xlcywgdGhpcyBhdm9pZHMgdGhlIG5l ZWQgZm9yIGEgY29uZnVzaW5nIGFuZCB1bmRvY3VtZW50ZWQgTlVMTElGKCkuCgpXaGlsZSBoZXJl LCB0d2VhayB0aGUgZm9ybWF0IG9mIHRoZSBlbWl0dGVkIHF1ZXJ5IHRvIGxvb2sgYSBiaXQKbmlj ZXIgZm9yICJwc3FsIC1FIiwgYW5kIGFkZCBzb21lIGV4cGxhbmF0aW9uIG9mIHRoaXMgc3VicXVl cnksCmJlY2F1c2UgaXQgYmFkbHkgbmVlZHMgaXQuCgpSZXBvcnQgYW5kIHBhdGNoIGJ5IEp1c3Rp biBQcnl6YnkgKHdpdGggc29tZSBlZGl0aW5nIGJ5IG1lKS4KQmFjay1wYXRjaCB0byB2MTMgd2hl cmUgdGhlIGZhdWx0eSBjb2RlIGNhbWUgaW4uCgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5l cy9tLzIwMjExMjE3MTU0MzU2LkdKMTc2MThAdGVsc2Fzb2Z0LmNvbQoKQnJhbmNoCi0tLS0tLQpS RUxfMTRfU1RBQkxFCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcv cGcvY29tbWl0ZGlmZi8zODg2Nzg1YjRjZTU5MTQ3YjkyMzE5ZTcyMDRhYjY0YTlkODgwMWNiCgpN b2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmluL3BzcWwvZGVzY3JpYmUuYyAgICAg ICAgICAgICAgICB8IDQ1ICsrKysrKysrKysrKysrKysrKysrKysrKystLS0tLS0tLS0Kc3JjL3Rl c3QvcmVncmVzcy9leHBlY3RlZC90cmlnZ2Vycy5vdXQgfCAxNCArKysrKysrKysrKwpzcmMvdGVz dC9yZWdyZXNzL3NxbC90cmlnZ2Vycy5zcWwgICAgICB8ICA1ICsrKysKMyBmaWxlcyBjaGFuZ2Vk LCA1MyBpbnNlcnRpb25zKCspLCAxMSBkZWxldGlvbnMoLSkKCg== --===============2198159866286411182==--