Re: [HACKERS] HINT message for "ALTER SUBSCRIPTION.. WITH" need to change with SET keyword

2017-05-19 Thread Peter Eisentraut
On 5/19/17 06:58, Dilip Kumar wrote: > On Fri, May 19, 2017 at 3:41 PM, tushar 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

Re: [HACKERS] HINT message for "ALTER SUBSCRIPTION.. WITH" need to change with SET keyword

2017-05-19 Thread Dilip Kumar
On Fri, May 19, 2017 at 3:41 PM, tushar 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 >

[HACKERS] HINT message for "ALTER SUBSCRIPTION.. WITH" need to change with SET keyword

2017-05-19 Thread tushar
Hi, There is small issue in the HINT message which we provide at the time of dropping subscription ,where we are saying -WITH (slot_name) which need to change with SET (slot_name). postgres=# drop subscription sub; ERROR: could not connect to publisher when attempting to drop the