Re: [HACKERS] HINT message for "ALTER SUBSCRIPTION.. WITH" need tochange with SET keyword - Mailing list pgsql-hackers

On 5/19/17 06:58, Dilip Kumar wrote:
> On Fri, May 19, 2017 at 3:41 PM, tushar <tushar.ahuja@enterprisedb.com> wrote:
>> postgres=# drop subscription sub;
>> ERROR:  could not connect to publisher when attempting to drop the
>> replication slot "pub"
>> DETAIL:  The error was: could not connect to server: No such file or
>> directory
>>     Is the server running locally and accepting
>>     connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>> HINT:  Use ALTER SUBSCRIPTION ... WITH (slot_name = NONE) to disassociate
>> the subscription from the slot.
>>
>> expected = "HINT:  Use ALTER SUBSCRIPTION ... SET (slot_name = NONE) to
>> disassociate the subscription from the slot."
> 
> Seems like syntax got changed in
> b807f59828fbc02fea612e1cbc0066c6dfa3be9b commit but missed to change
> the hint. Attached patch fixes that.

Fixed, thanks.

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