From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Artur Zakirov <a.zakirov@postgrespro.ru>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: [BUG?] pg_event_trigger_ddl_commands() error with ALTER TEXT SEARCH CONFIGURATION
Date: Thu, 17 Nov 2016 18:17:54 -0300
Message-ID: <20161117211754.6zdetsqtrmt552bz@alvherre.pgsql> (raw)
In-Reply-To: <57a71eba-f2c7-e7fd-6fc0-2126ec0b39bd@postgrespro.ru>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
Artur Zakirov wrote:
> 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?
It's a bug. You're right that we need to handle the object class
somewhere. Perhaps I failed to realize that tsconfigs could get
altered.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: alvherre@2ndquadrant.com, a.zakirov@postgrespro.ru
Subject: Re: [BUG?] pg_event_trigger_ddl_commands() error with ALTER TEXT SEARCH CONFIGURATION
In-Reply-To: <20161117211754.6zdetsqtrmt552bz@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox