Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1c7Pbq-0004cV-6K for pgsql-hackers@arkaria.postgresql.org; Thu, 17 Nov 2016 16:32:22 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1c7Pbp-0003Va-Mm for pgsql-hackers@arkaria.postgresql.org; Thu, 17 Nov 2016 16:32:21 +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_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1c7PaQ-0001xB-Dj for pgsql-hackers@postgresql.org; Thu, 17 Nov 2016 16:30:54 +0000 Received: from mail.postgrespro.ru ([93.174.131.138]) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1c7PaM-0005oz-Rq for pgsql-hackers@postgresql.org; Thu, 17 Nov 2016 16:30:53 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.postgrespro.ru (Postfix) with ESMTP id 879DD21C22C7 for ; Thu, 17 Nov 2016 19:30:49 +0300 (MSK) X-Virus-Scanned: Debian amavisd-new at postgrespro.ru Received: from mail.postgrespro.ru ([127.0.0.1]) by localhost (mail.postgrespro.ru [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id nabOkpYrkm-7 for ; Thu, 17 Nov 2016 19:30:49 +0300 (MSK) Received: from [192.168.27.237] (unknown [192.168.27.1]) by mail.postgrespro.ru (Postfix) with ESMTPSA id 58EEE21C02E0 for ; Thu, 17 Nov 2016 19:30:49 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1479400249; bh=Cv0GWqyWAvKLf6ewzWZinWji4aAL2qJTYaJrCCrePDY=; h=To:From:Subject:Date; b=S3DLfQkYQ+wk9YTI9T7GwQFoaEjvAGB35dBhfP3CGAK2CNsfFekbyEG5UG658vO3B 2Z7LnHKFT0ZLmectVDcuOhR1+iN2qYNVeSHrRSJUiLI4OthZR/jkNEUTrwR+19KlXf aD556QY/nf5/iW5PN+ocEHyAWoUCZjh1PM6vmirY= To: PostgreSQL Hackers From: Artur Zakirov Subject: [BUG?] pg_event_trigger_ddl_commands() error with ALTER TEXT SEARCH CONFIGURATION Message-ID: <57a71eba-f2c7-e7fd-6fc0-2126ec0b39bd@postgrespro.ru> Date: Thu, 17 Nov 2016 19:27:31 +0300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.4.0 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="------------ACC82E0908BDCDAE8C4F4E40" X-Pg-Spam-Score: -4.9 (----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org This is a multi-part message in MIME format. --------------ACC82E0908BDCDAE8C4F4E40 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Hello hackers, I attached the test extension. It just creates event trigger on ddl_command_end. And pg_catalog.pg_event_trigger_ddl_commands() is executed from extension's C-function handler. The pg_event_trigger_ddl_commands() returns the error: ERROR: unrecognized object class: 3603 if I try to execute the following commands: => create text search CONFIGURATION en (copy=english); => alter text search CONFIGURATION en ALTER MAPPING for host, email, url, sfloat with simple; ERROR: unrecognized object class: 3603 CONTEXT: SQL statement "SELECT objid, UPPER(object_type), object_identity, UPPER(command_tag) FROM pg_catalog.pg_event_trigger_ddl_commands()" This error is raised from getObjectClass() function. It seems that we need new OCLASS_TSCONFIG_MAP object class. Is this a bug? Or it wasn't added intentionally? Thanks in advance. -- Artur Zakirov Postgres Professional: http://www.postgrespro.com Russian Postgres Company --------------ACC82E0908BDCDAE8C4F4E40 Content-Type: application/zip; name="trigger_test.zip" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="trigger_test.zip" UEsDBBQDAAAAAK6YcUkAAAAAAAAAAAAAAAANAAAAdHJpZ2dlcl90ZXN0L1BL AwQUAwAACAD3lnFJBKscnuwAAACEAQAAFQAAAHRyaWdnZXJfdGVzdC9NYWtl ZmlsZV2Oy27CMBRE9/crLNRFs7DTx64SC0pMlAoSVIOanYXjRy3cJI0TqZ9f FwoKWV1p5tyZ2RTJfk25sAbNUd9ZY1THe+V7KF7f2EQjDbq7/8jy56d3yiIA Wu5ozrIin/4mi91iomH8SB6I/3awTVfZmiaULQMyGzMzAKul0mjPKN+mJQss Xxb5KksD2hpeNbW2Bv4s9DIPY/ynci7cKxchjFvz4yOwdeUGqU5mGdYq5xX4 QUjbhbCQFJpFfDO7b1ouBuvkmSEkJmSUM7aj2HdVvDkclbZOEeMacXATNhAn 8r/rcvEZJl9HULW0Gn4BUEsDBBQDAAAIADOXcUlGmalBkQAAAAMBAAAiAAAA dHJpZ2dlcl90ZXN0L3RyaWdnZXJfdGVzdC0tMS4wLnNxbIWPQQrCMBBF15lT zC4K3qCrkI6x0KZlmoi7ICYUwVaowfPbRXdCu/18Hu9pJuUIz95qV7UW8/wc hjSHnD45xPgKj/c43qcY0hQPRxBMzrPtMX3TlMP6BlEra7wyhBqE6lE2belr Cp1yF6sakieUW2RZAKwmdCXr0HFlDPGmDojF92+jG2m/cDpuNZWeaSepgB9Q SwMEFAMAAAgAeZhxSSxoSdnFAQAAewMAABsAAAB0cmlnZ2VyX3Rlc3QvdHJp Z2dlcl90ZXN0LmOVks2OmzAUhdfwFHeoKkGEJtNt0y4iQhAqgYjArCpZDFyI K7CpMVWjqu9eA64m00gdzQru37mfj/2OsrIdKwSr54NsBA73Z8t8ztZdI6bM VarkXVewaljjD2SSSEGbBsXLMfyJ5Si5WA89ncePATkkuzzyyWEbhN5mzuzz 2MvCJCZhvE/I4wdbaxGJgyRV1RK9iyCrHDWzK+TYmf/rsq9lt2lwcsxfplFy Nkgoz4WA1fcRxWVjGpRJwzDUgcdWbkwV12Dfedso8ndkeyL+ox9nJEvDIPBT uy4pq7njmIaBLW9sP02T1AWLcQk1FVjB0wVmP0DTgSIq1NdyJvF5KXwG6+RH vpcBf/pGKxfy41GJqwBLZeSlR8cFHdFKiVF5cb8yS201LNDdfw8ri8Z5ru3T 5AB9Q8pCFgrwXv2+uJ5rnwbbsSao9Qq2UmLXK2gOyiOmFsNqbWpXFO/pGBJd sJ3NYpIufoKHGzv6phgrenMpH691QKAcBVOWva8sd8KHRdHRTP78dhDkGWH2 7RYJlxZ7LrvK8hFdePgH8G7pTb6QxfS30eoVr9J6vOtbvMGdJGrK6HC25071 LFM/y9OYxHkUTbnffwBQSwMEFAMAAAgADZdxSfV6KNZlAAAAhgAAACEAAAB0 cmlnZ2VyX3Rlc3QvdHJpZ2dlcl90ZXN0LmNvbnRyb2xVzUEOhCAQRNE9pyCZ SdjN6AE8C2mlVJIGTNsYj6/sdFt5qf+xKnFZIF6xq8WpyHss2UwlJWS1g3VP 4UzATJXVH5AGG+h/nTOphMrwG+maKaHtX45jiPJ/Hwi4TKQ08o3ufIW5AFBL AQI/AxQDAAAAAK6YcUkAAAAAAAAAAAAAAAANACQAAAAAAAAAEIDtQQAAAAB0 cmlnZ2VyX3Rlc3QvCgAgAAAAAAABABgAgL1IaexA0gGAvUhp7EDSAYC9SGns QNIBUEsBAj8DFAMAAAgA95ZxSQSrHJ7sAAAAhAEAABUAJAAAAAAAAAAggKSB KwAAAHRyaWdnZXJfdGVzdC9NYWtlZmlsZQoAIAAAAAAAAQAYAICWYg7rQNIB gMOTD+tA0gGAlmIO60DSAVBLAQI/AxQDAAAIADOXcUlGmalBkQAAAAMBAAAi ACQAAAAAAAAAIICkgUoBAAB0cmlnZ2VyX3Rlc3QvdHJpZ2dlcl90ZXN0LS0x LjAuc3FsCgAgAAAAAAABABgAgG4kUetA0gEABb1R60DSAYBuJFHrQNIBUEsB Aj8DFAMAAAgAeZhxSSxoSdnFAQAAewMAABsAJAAAAAAAAAAggKSBGwIAAHRy aWdnZXJfdGVzdC90cmlnZ2VyX3Rlc3QuYwoAIAAAAAAAAQAYAIAg3y7sQNIB ALd3L+xA0gGAIN8u7EDSAVBLAQI/AxQDAAAIAA2XcUn1eijWZQAAAIYAAAAh ACQAAAAAAAAAIICkgRkEAAB0cmlnZ2VyX3Rlc3QvdHJpZ2dlcl90ZXN0LmNv bnRyb2wKACAAAAAAAAEAGACAGjom60DSAQCx0ibrQNIBgBo6JutA0gFQSwUG AAAAAAUABQAaAgAAvQQAAAAA --------------ACC82E0908BDCDAE8C4F4E40 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers --------------ACC82E0908BDCDAE8C4F4E40--