Re: BUG #14457: Using hyphens/dashes in synchronous_standby_names fails with "invalid value"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: daff(at)ptmx(dot)at
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14457: Using hyphens/dashes in synchronous_standby_names fails with "invalid value"
Date: 2016-12-09 03:18:54
Message-ID: 21183.1481253534@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

daff(at)ptmx(dot)at writes:
> It seems that hyphens or dashes in the value of synchronous_standby_names
> are not accepted.

You would need to use double quotes, same as the rules for a SQL
identifier. Per the fine manual:

Each standby_name should have the form of a valid SQL identifier,
unless it is *. You can use double-quoting if necessary. But note
that standby_names are compared to standby application names
case-insensitively, whether double-quoted or not.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andreas Ntaflos 2016-12-09 04:04:13 Re: BUG #14457: Using hyphens/dashes in synchronous_standby_names fails with "invalid value"
Previous Message daff 2016-12-09 02:23:15 BUG #14457: Using hyphens/dashes in synchronous_standby_names fails with "invalid value"