Bug reference: 16028 Logged by: cd a Email address: cdalxndr@yahoo.com PostgreSQL version: 10.3 Operating system: Windows 10 Description:
Using a java spring app with connection: jdbc:postgresql://localhost:5433/postgres?currentSchema=dev,public&ApplicationName=myapp Schema 'dev' has fts configuration 'en'. Query (debugged PgPreparedStatement): select * from dev.category where category.language='en' the param 'en' is registered with oid (paramType) 3734 corresponding to 'regconfig' type
Query results in: ERROR: text search configuration "en" does not exist
The same error is shown when running the query in PgAdmin if search_path doesn't contain 'dev' schema. With 'dev' in search_path, the query is ok. I was expecting that 'currentSchema' connection parameter will be used to resolve fts configuration to 'dev' schema.