Re: [BUG?] pg_event_trigger_ddl_commands() error with ALTER TEXT SEARCH CONFIGURATION

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