Re: BUG #15116: pg_recvlogical always fails

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: kotlarski(dot)krzysztof(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15116: pg_recvlogical always fails
Date: 2018-03-16 22:37:04
Message-ID: c28a0c4f-e8e6-e618-2a6a-0915f38609b9@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2018-03-17 00:20:26 Re: BUG #15116: pg_recvlogical always fails
Previous Message PG Bug reporting form 2018-03-16 20:49:29 BUG #15117: Duplicate Primary Key