Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ijA72-0005ri-NK for pgsql-bugs@arkaria.postgresql.org; Sun, 22 Dec 2019 22:54:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ijA70-0005GQ-3A for pgsql-bugs@arkaria.postgresql.org; Sun, 22 Dec 2019 22:54:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ijA6z-0005GJ-RH for pgsql-bugs@lists.postgresql.org; Sun, 22 Dec 2019 22:54:09 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ijA6u-0000u3-WC for pgsql-bugs@lists.postgresql.org; Sun, 22 Dec 2019 22:54:08 +0000 Content-Type: multipart/mixed; boundary="===============8571738417412661341==" MIME-Version: 1.0 Subject: BUG #16177: pg_event_trigger_ddl_commands() returns empty set for ddl_command_start and "drop table" To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: andrei.pozolotin@gmail.com Reply-To: andrei.pozolotin@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sun, 22 Dec 2019 22:53:04 +0000 Message-ID: <16177-053a34714817c3e1@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============8571738417412661341== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjE3NwpMb2dnZWQgYnk6ICAgICAgICAgIEFuZHJlaSBQb3pvbG90aW4K RW1haWwgYWRkcmVzczogICAgICBhbmRyZWkucG96b2xvdGluQGdtYWlsLmNvbQpQb3N0Z3JlU1FM IHZlcnNpb246IDExLjYKT3BlcmF0aW5nIHN5c3RlbTogICBsaW51eApEZXNjcmlwdGlvbjogICAg ICAgIAoKMS4gdXNlIGNhc2UgaXMgdG8gZGVsZXRlIHJvd3Mgd2l0aCBvaWQgcmVmZXJlbmNlcyAg dG8gdGhlIHRhYmxlIGJlZm9yZSAiZHJvcAp0YWJsZSINCg0KMi4gb25lIHdheSB0byBkbyB0aGF0 IGlzIHdpdGggZXZlbnRfdHJpZ2dlciwgc2VlIGNvZGUgc25pcHBldCBiZWxvdw0KDQozLiB0aGUg cHJvYmxlbSBpcyB0aGF0Og0KcGdfZXZlbnRfdHJpZ2dlcl9kZGxfY29tbWFuZHMoKSByZXR1cm5z IGVtcHR5IHNldCBmb3IgZGRsX2NvbW1hbmRfc3RhcnQgYW5kCiJkcm9wIHRhYmxlIg0KDQo0LiB0 aGlzIGlzc3VlIHdhcyBhbHJlYWR5IG1lbnRpb25lZCBiZWZvcmU6DQpodHRwczovL3Bvc3RncmVz cHJvLmNvbS9saXN0L3RocmVhZC1pZC8yMzk0NzcyDQoNCjUuIHNhbXBsZSBjb2RlOg0KDQogICAg ICAgIENSRUFURSBPUiBSRVBMQUNFIEZVTkNUSU9OIHBnbG9naWNhbF9hc3NpZ25fcmVwc2V0KCkN CiAgICAgICAgICAgIFJFVFVSTlMgZXZlbnRfdHJpZ2dlciBBUyAkJA0KICAgICAgICAgICAgREVD TEFSRSBvYmogcmVjb3JkOw0KICAgICAgICAgICAgQkVHSU4NCiAgICAgICAgICAgICAgICBSQUlT RSBOT1RJQ0UgJ3BnbG9naWNhbCBhc3NpZ246ICUgJScsIHRnX2V2ZW50LCB0Z190YWc7DQogICAg ICAgICAgICAgICAgRk9SIG9iaiBJTiBTRUxFQ1QgKiBGUk9NIHBnX2V2ZW50X3RyaWdnZXJfZGRs X2NvbW1hbmRzKCkNCiAgICAgICAgICAgICAgICBMT09QDQogICAgICAgICAgICAgICAgICAgIElG IG9iai5vYmplY3RfdHlwZSA9ICd0YWJsZScgVEhFTg0KICAgICAgICAgICAgICAgICAgICAgICAg SUYgb2JqLnNjaGVtYV9uYW1lID0gJ3B1YmxpYycgVEhFTg0KICAgICAgICAgICAgICAgICAgICAg ICAgICAgIElGIHRnX3RhZyBJTiAoJ0NSRUFURSBUQUJMRScpIFRIRU4NCiAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgUEVSRk9STQpwZ2xvZ2ljYWwucmVwbGljYXRpb25fc2V0X2FkZF90 YWJsZSgnZGVmYXVsdCcsIG9iai5vYmppZCk7DQogICAgICAgICAgICAgICAgICAgICAgICAgICAg RU5EIElGOw0KICAgICAgICAgICAgICAgICAgICAgICAgICAgIElGIHRnX3RhZyBJTiAoJ0RST1Ag VEFCTEUnKSBUSEVODQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFBFUkZPUk0KcGds b2dpY2FsLnJlcGxpY2F0aW9uX3NldF9yZW1vdmVfdGFibGUoJ2RlZmF1bHQnLCBvYmoub2JqaWQp Ow0KICAgICAgICAgICAgICAgICAgICAgICAgICAgIEVORCBJRjsNCiAgICAgICAgICAgICAgICAg ICAgICAgIEVORCBJRjsNCiAgICAgICAgICAgICAgICAgICAgRU5EIElGOw0KICAgICAgICAgICAg ICAgIEVORCBMT09QOw0KICAgICAgICAgICAgRU5EOw0KICAgICAgICAgICAgJCQgTEFOR1VBR0Ug cGxwZ3NxbDsNCiAgICAgICAgLS0tDQogICAgICAgIERST1AgRVZFTlQgVFJJR0dFUiBJRiBFWElT VFMNCiAgICAgICAgICAgIHBnbG9naWNhbF9hc3NpZ25fcmVwc2V0X2NyZWF0ZTsNCiAgICAgICAg Q1JFQVRFIEVWRU5UIFRSSUdHRVINCiAgICAgICAgICAgIHBnbG9naWNhbF9hc3NpZ25fcmVwc2V0 X2NyZWF0ZQ0KICAgICAgICAgICAgT04gZGRsX2NvbW1hbmRfZW5kDQogICAgICAgICAgICBXSEVO IFRBRyBJTiAoJ0NSRUFURSBUQUJMRScpDQogICAgICAgICAgICBFWEVDVVRFIEZVTkNUSU9OIHBn bG9naWNhbF9hc3NpZ25fcmVwc2V0KCk7DQogICAgICAgIC0tLQ0KICAgICAgICBEUk9QIEVWRU5U IFRSSUdHRVIgSUYgRVhJU1RTDQogICAgICAgICAgICBwZ2xvZ2ljYWxfYXNzaWduX3JlcHNldF9k ZWxldGU7DQogICAgICAgIENSRUFURSBFVkVOVCBUUklHR0VSDQogICAgICAgICAgICBwZ2xvZ2lj YWxfYXNzaWduX3JlcHNldF9kZWxldGUNCiAgICAgICAgICAgIE9OIGRkbF9jb21tYW5kX3N0YXJ0 DQogICAgICAgICAgICBXSEVOIFRBRyBJTiAoJ0RST1AgVEFCTEUnKQ0KICAgICAgICAgICAgRVhF Q1VURSBGVU5DVElPTiBwZ2xvZ2ljYWxfYXNzaWduX3JlcHNldCgpOw0KICAgICAgICAtLS0KCg== --===============8571738417412661341==--