Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sbHJZ-00FOht-WF for pgsql-bugs@arkaria.postgresql.org; Tue, 06 Aug 2024 10:21:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sbHJY-00Cfkq-Fw for pgsql-bugs@arkaria.postgresql.org; Tue, 06 Aug 2024 10:21:12 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sbFxH-00A9qO-G4 for pgsql-bugs@lists.postgresql.org; Tue, 06 Aug 2024 08:54:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sbFxF-003R2O-TP for pgsql-bugs@lists.postgresql.org; Tue, 06 Aug 2024 08:54:06 +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=PhmgJg1pW98+0vfA4cIvnwPdeJ8X6cu/LCM2SIJocyo=; b=7ZbdACy6as8AJ3X6Hzo2WOrrE9 op8hkuFPGwie0OE+i9LLj9mqt4qSc7H38so3C5vyNLW8VijleRKcFGQLD3+Wh4/a+0nhcR6hgJcOT fWq1dS/iukc5/dYhq9pJSdjw7NcN4E6DadiJBbgzHzUTK2EaNaOu+s9fH0oC1Vyyfx3XEczLZh8Jl oWvkj29UMN2kHCC6JSRRkA57/zlmjzv5/XVf9ge1vTBIw9Po15Q/+SmrbJLhuXntkPu+Zv0AZSJig zrabdvKj+9Ao8TybgIscbOZ87R55QEd97shImkYyyWwaaBn5EzIkX45uMPncwxwJfLiI8hyqSZsy0 V71ANgKg==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sbFxE-00AQR2-FL for pgsql-bugs@lists.postgresql.org; Tue, 06 Aug 2024 08:54:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sbFxB-00GeoO-VV for pgsql-bugs@lists.postgresql.org; Tue, 06 Aug 2024 08:54:02 +0000 Content-Type: multipart/mixed; boundary="===============3619916952023561723==" MIME-Version: 1.0 Subject: BUG #18570: Drop event trigger for DDL finishes successfully but trigger still executed on DDL To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: p2wap3@gmail.com Reply-To: p2wap3@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 06 Aug 2024 08:53:19 +0000 Message-ID: <18570-43bc1b85bebd2572@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3619916952023561723== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODU3MApMb2dnZWQgYnk6ICAgICAgICAgIFBhdWwgUApFbWFpbCBhZGRy ZXNzOiAgICAgIHAyd2FwM0BnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAxNi4xCk9wZXJh dGluZyBzeXN0ZW06ICAgQVdTIFJEUwpEZXNjcmlwdGlvbjogICAgICAgIAoKSSBjcmVhdGVkIGEg ZnVuY3Rpb24gYW5kIGFuIGV2ZW50IHRyaWdnZXIgYnV0IHRoZW4gZGVjaWRlZCB0byBkcm9wIHRo ZSBldmVudAp0cmlnZ2VyICh3L28gZHJvcHBpbmcgdGhlIGZ1bmN0aW9uIHlldCkuDQoNCkNyZWF0 aW9uIHNjcmlwdDoNCg0KYGBgDQpDUkVBVEUgT1IgUkVQTEFDRSBGVU5DVElPTiBwdWJsaWMuYXdz ZG1zX2ludGVyY2VwdF9kZGwoKQ0KIFJFVFVSTlMgZXZlbnRfdHJpZ2dlcg0KIExBTkdVQUdFIHBs cGdzcWwNCkFTICRmdW5jdGlvbiQNCiAgZGVjbGFyZSBfcXJ5IHRleHQ7DQpCRUdJTg0KICBpZiAo dGdfdGFnPSdDUkVBVEUgVEFCTEUnIG9yIHRnX3RhZz0nQUxURVIgVEFCTEUnIG9yIHRnX3RhZz0n RFJPUCBUQUJMRScKb3IgdGdfdGFnID0gJ0NSRUFURSBUQUJMRSBBUycpIHRoZW4NCgkgICAgU0VM RUNUIGN1cnJlbnRfcXVlcnkoKSBpbnRvIF9xcnk7DQoJICAgIGluc2VydCBpbnRvIHB1YmxpYy5h d3NkbXNfZGRsX2F1ZGl0DQoJICAgIHZhbHVlcw0KCSAgICAoDQoJICAgIGRlZmF1bHQsY3VycmVu dF90aW1lc3RhbXAsY3VycmVudF91c2VyLGNhc3QoVFhJRF9DVVJSRU5UKClhcwp2YXJjaGFyKDE2 KSksdGdfdGFnLDAsJycsY3VycmVudF9zY2hlbWEsX3FyeQ0KCSAgICApOw0KCSAgICBkZWxldGUg ZnJvbSBwdWJsaWMuYXdzZG1zX2RkbF9hdWRpdDsNCiBlbmQgaWY7DQpFTkQ7DQokZnVuY3Rpb24k DQo7DQoNCkNSRUFURSBFVkVOVCBUUklHR0VSIGF3c2Rtc19pbnRlcmNlcHRfZGRsIE9OIGRkbF9j b21tYW5kX2VuZA0KRVhFQ1VURSBGVU5DVElPTiBwdWJsaWMuYXdzZG1zX2ludGVyY2VwdF9kZGwo KQ0KYGBgDQoNCkFmdGVyIHNvbWUgdGltZSBJIGRlY2lkZWQgdG8gZHJvcCB0aGUgZXZlbnQgdHJp Z2dlci4gVGhlIGNvbW1hbmQgaXMgZXhlY3V0ZWQKc3VjY2Vzc2Z1bGx5IChEUk9QIEVWRU5UIFRS SUdHRVIgPG5hbWU+IENBU0NBREUpIA0KSSBkb3VibGUgY2hlY2tlZCBieSBxdWVyeWluZyB0aGUg aW5mb3JtYXRpb25fc2NoZW1hLnRyaWdnZXJzICh0aGUgbGlzdCBpcwplbXB0eSkNCg0KQnV0IGV2 ZXJ5IHRpbWUgSSB0cnkgdG8gZXhlY3V0ZSBhIERETCBvcGVyYXRpb24sIEkgZW5jb3VudGVyIGFu IGVycm9yIHNheWluZwp0aGF0IERETCBmdW5jdGlvbiB3YXMgY2FsbGVkLg0KVGhlIGVycm9yIHdh cyBzYXlpbmcgdGhlIG9wZXJhdGlvbiBmYWlsZWQgYmVjYXVzZSBhd3NkbXNfaW50ZXJjZXB0X2Rk bCgpCmZ1bmN0aW9uLiANCldoeSB0aGUgZnVuY3Rpb24gaXMgY2FsbGVkIGlmIHRoZSBldmVudCB0 cmlnZ2VyIGlzIHN1cHBvc2VkbHkgZHJvcHBlZC4gDQpZb3VyIGRvY3VtZW50YXRpb24gc2F5cyBu b3RoaW5nIGFib3V0IGNhY2hpbmcgZXZlbnQgdHJpZ2dlcnMgLCBlc3BlY2lhbGx5IGlmCmluZm9y bWF0aW9uX3NjaGVtYS50cmlnZ2VycyB3YXMgdXBkYXRlZC4NCg0KRXZlbnR1YWxseSwgdGhlIHNv bHV0aW9uIHRoYXQgd29ya2VkIGZvciBtZSB3YXMgdG8gZHJvcCB0aGUgZnVuY3Rpb24uDQoNCkJ0 dywgYXQgZmlyc3Qgd2hlbiBJIHRyaWVkIHRvIGRyb3AgdGhlIGZ1bmN0aW9uLCBJIGhhdmUgZ290 IHRoaXMgZXJyb3I6DQpgYGANCkRST1AgZnVuY3Rpb24gSUYgRVhJU1RTIGF3c2Rtc19pbnRlcmNl cHRfZGRsOw0KRVJST1I6ICBjYW5ub3QgZHJvcCBmdW5jdGlvbiBhd3NkbXNfaW50ZXJjZXB0X2Rk bCgpIGJlY2F1c2Ugb3RoZXIgb2JqZWN0cwpkZXBlbmQgb24gaXQgDQpERVRBSUw6ICBldmVudCB0 cmlnZ2VyIGF3c2Rtc19pbnRlcmNlcHRfZGRsIGRlcGVuZHMgb24gZnVuY3Rpb24KYXdzZG1zX2lu dGVyY2VwdF9kZGwoKQ0KSElOVDogIFVzZSBEUk9QIC4uLiBDQVNDQURFIHRvIGRyb3AgdGhlIGRl cGVuZGVudCBvYmplY3RzIHRvby4NCmBgYA0KDQpJIHRoaW5rIHRoaXMgaXMgdW5kZXNpcmFibGUg YmVoYXZpb3IgLCBpZiB1c2VyIGp1c3Qgd2FudHMgdG8gZHJvcCB0aGUKdHJpZ2dlciB3L28gcmVt b3ZpbmcgdGhlIGZ1bmN0aW9uIGl0IHNlbGYuCgo= --===============3619916952023561723==--