Re: BUG #15116: pg_recvlogical always fails - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: BUG #15116: pg_recvlogical always fails
Date
Msg-id c28a0c4f-e8e6-e618-2a6a-0915f38609b9@2ndquadrant.com
Whole thread Raw
In response to BUG #15116: pg_recvlogical always fails  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15116: pg_recvlogical always fails
List pgsql-bugs
On 3/16/18 11:34, PG Bug reporting form wrote:
> When run with correct arguments (working in previous versions)
> pg_recvlogical always fails with: 
> 
> pg_recvlogical: could not clear search_path: ERROR:  syntax error
> 
> I suspect it's trying to execute ALWAYS_SECURE_SEARCH_PATH_SQL on
> replication connection which is nonSQL.

I can confirm this problem.

I have copied the 030_pg_recvlogical.pl test from 10 into 9.6 to produce
a test failure with that same error message.

Haven't looked further yet.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15117: Duplicate Primary Key
Next
From: Michael Paquier
Date:
Subject: Re: BUG #15116: pg_recvlogical always fails