Postgres Pro
Downloads
Home   >   mailing lists

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

From Dilip Kumar
Subject Re: [HACKERS] HINT message for "ALTER SUBSCRIPTION.. WITH" need tochange with SET keyword
Date
Msg-id CAFiTN-uU-4+QA3upB-4spYCf8ek2ZnJovwmOHUEmdKnD=jij4A@mail.gmail.com
Whole thread Raw
In response to [HACKERS] HINT message for "ALTER SUBSCRIPTION.. WITH" need to change with SETkeyword  (tushar <tushar.ahuja@enterprisedb.com>)
Responses Re: [HACKERS] HINT message for "ALTER SUBSCRIPTION.. WITH" need tochange with SET keyword  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
Tree view 
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.

-- 
Regards,
Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Attachment

pgsql-hackers by date:

Previous
From: Pierre-Emmanuel André
Date:
Subject: Re: [HACKERS] PostgreSQL 10beta1 - compilation fails on OpenBSD-current
Next
From: Stephen Frost
Date:
Subject: Re: [HACKERS] Preliminary results for proposed new pgindentimplementation