| From: | Dilip Kumar <dilipbalaut(at)gmail(dot)com> |
|---|---|
| To: | tushar <tushar(dot)ahuja(at)enterprisedb(dot)com> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: HINT message for "ALTER SUBSCRIPTION.. WITH" need to change with SET keyword |
| Date: | 2017-05-19 10:58:12 |
| Message-ID: | CAFiTN-uU-4+QA3upB-4spYCf8ek2ZnJovwmOHUEmdKnD=jij4A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, May 19, 2017 at 3:41 PM, tushar <tushar(dot)ahuja(at)enterprisedb(dot)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
| Attachment | Content-Type | Size |
|---|---|---|
| fix_subscription_hint.patch | application/octet-stream | 673 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2017-05-19 11:03:54 | Re: Preliminary results for proposed new pgindent implementation |
| Previous Message | Pierre-Emmanuel André | 2017-05-19 10:44:27 | Re: PostgreSQL 10beta1 - compilation fails on OpenBSD -current |