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 1oWbAn-0006iT-2E for pgsql-committers@arkaria.postgresql.org; Fri, 09 Sep 2022 10:23:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oWbAl-0002ob-NR for pgsql-committers@arkaria.postgresql.org; Fri, 09 Sep 2022 10:23:43 +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 1oWbAl-0002Xt-71 for pgsql-committers@lists.postgresql.org; Fri, 09 Sep 2022 10:23:43 +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 1oWbAj-0007Gn-9Q for pgsql-committers@lists.postgresql.org; Fri, 09 Sep 2022 10:23:42 +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 1oWbAg-0006iX-T5 for pgsql-committers@lists.postgresql.org; Fri, 09 Sep 2022 10:23:38 +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 1oWbAf-0028Mx-JO for pgsql-committers@lists.postgresql.org; Fri, 09 Sep 2022 10:23:38 +0000 Content-Type: multipart/mixed; boundary="===============5940656734400925485==" MIME-Version: 1.0 From: Alvaro Herrera To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix GetForeignKey*Triggers for self-referential FKs X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 09 Sep 2022 10:23:38 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5940656734400925485== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IEdldEZvcmVpZ25LZXkqVHJpZ2dlcnMgZm9yIHNlbGYtcmVmZXJlbnRpYWwgRktzCgpCZWNh dXNlIG9mIGluYWRlcXVhdGUgZmlsdGVyaW5nLCB0aGUgY2hlY2sgdHJpZ2dlcnMgd2VyZSBjb25m dXNpbmcgdGhlCnNlYXJjaCBmb3IgYWN0aW9uIHRyaWdnZXJzIGluIEdldEZvcmVpZ25LZXlBY3Rp b25UcmlnZ2VycyBhbmQgdmljZS12ZXJzYQppbiBHZXRGb3JlaWduS2V5Q2hlY2tUcmlnZ2Vyczsg dGhpcyBjb25mdXNpb24gcmVzdWx0cyBpbiBzZWVtaW5nbHkKcmFuZG9tIGFzc2VydGlvbiBmYWls dXJlcywgYW5kIGNhbiBoYXZlIHJlYWwgaW1wYWN0IGluIG5vbi1hc3NlcnRpbmcKYnVpbGRzIGRl cGVuZGluZyBvbiBjYXRhbG9nIG9yZGVyLiAgQ2hhbmdlIHRoZXNlIGZ1bmN0aW9ucyBzbyB0aGF0 IHRoZXkKY29ycmVjdGx5IGlnbm9yZSB0cmlnZ2VycyB0aGF0IGFyZSBub3QgcmVsZXZhbnQgdG8g ZWFjaCBzaWRlLgoKVG8gcmVkdWNlIHRoZSBvZGRzIG9mIGZ1cnRoZXIgcHJvYmxlbXMsIGRvIG5v dCBicmVhayBvdXQgb2YgdGhlCnNlYXJjaGluZyBsb29wIGluIGFzc2VydGlvbiBidWlsZHMuICBU aGlzIGJyZWFrIGlzIGxpa2VseSB0byBoaWRlIGJ1Z3M7CndpdGhvdXQgaXQsIHdlIHdvdWxkIGhh dmUgZGV0ZWN0ZWQgdGhpcyBidWcgaW1tZWRpYXRlbHkuCgpUaGlzIHByb2JsZW0gd2FzIGludHJv ZHVjZWQgYnkgZjQ1NjYzNDVjZjQwLCBzbyBiYWNrcGF0Y2ggdG8gMTUgd2hlcmUKdGhhdCBjb21t aXQgZmlyc3QgYXBwZWFyZWQuCgpBdXRob3I6IEFtaXQgTGFuZ290ZSA8YW1pdGxhbmdvdGUwOUBn bWFpbC5jb20+CkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vMjAyMjA5MDgxNzIwMjku c2VqZnQycHBja2JvNm9oNUBhd29yazMuYW5hcmF6ZWwuZGUKRGlzY3Vzc2lvbjogaHR0cHM6Ly9w b3N0Z3IuZXMvbS80MTA0NjE5LjE2NjI2NjMwNTZAc3NzLnBnaC5wYS51cwoKQnJhbmNoCi0tLS0t LQpSRUxfMTVfU1RBQkxFCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5v cmcvcGcvY29tbWl0ZGlmZi82OGIwZGE2Nzc5NGU2MmRmNTNkMDc5NTY0ODI3NzBjYmZiYzVlNzg2 CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9jb21tYW5kcy90YWJs ZWNtZHMuYyB8IDEyICsrKysrKysrKysrKwoxIGZpbGUgY2hhbmdlZCwgMTIgaW5zZXJ0aW9ucygr KQoK --===============5940656734400925485==--