Skip site navigation (1) Skip section navigation (2)

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

From: Artur Zakirov <a(dot)zakirov(at)postgrespro(dot)ru>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: [BUG?] pg_event_trigger_ddl_commands() error with ALTER TEXT SEARCH CONFIGURATION
Date: 2016-11-17 16:27:31
Message-ID: 57a71eba-f2c7-e7fd-6fc0-2126ec0b39bd@postgrespro.ru (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-hackers
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

Attachment: trigger_test.zip
Description: application/zip (1.7 KB)

Responses

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2016-11-17 16:37:57
Subject: Re: Avoiding pin scan during btree vacuum
Previous:From: Robert HaasDate: 2016-11-17 16:12:34
Subject: Re: Password identifiers, protocol aging and SCRAM protocol

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group