PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16028
PG Version10.3
OSWindows 10
Opened2019-09-26 22:15:13+00
Reported bycd a
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16028
Logged by:          cd a
Email address:      (redacted)
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.

Messages

DateAuthorSubject
2019-09-26 22:15:13+00PG Bug reporting formBUG #16028: JDBC currentSchema connection parameter not working for text search configuration
2019-09-30 00:45:36+00Dave CramerRe: BUG #16028: JDBC currentSchema connection parameter not working for text search configuration
2019-09-30 10:13:03+00AlexRe: BUG #16028: JDBC currentSchema connection parameter not working for text search configuration
2019-09-30 10:56:24+00Dave CramerRe: BUG #16028: JDBC currentSchema connection parameter not working for text search configuration
2019-09-30 11:37:37+00AlexRe: BUG #16028: JDBC currentSchema connection parameter not working for text search configuration
2019-09-30 11:47:00+00Dave CramerRe: BUG #16028: JDBC currentSchema connection parameter not working for text search configuration
2019-09-30 12:24:23+00AlexRe: BUG #16028: JDBC currentSchema connection parameter not working for text search configuration
2019-09-30 12:27:05+00Dave CramerRe: BUG #16028: JDBC currentSchema connection parameter not working for text search configuration