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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [BUGS] BUG #14457: Using hyphens/dashes in synchronous_standby_names fails with "invalid value"
Дата
Msg-id 21183.1481253534@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [BUGS] BUG #14457: Using hyphens/dashes in synchronous_standby_names failswith "invalid value"  (daff@ptmx.at)
Ответы Re: [BUGS] BUG #14457: Using hyphens/dashes insynchronous_standby_names fails with "invalid value"  (Andreas Ntaflos <daff@ptmx.at>)
Список pgsql-bugs
daff@ptmx.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


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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: daff@ptmx.at
Дата:
Сообщение: [BUGS] BUG #14457: Using hyphens/dashes in synchronous_standby_names failswith "invalid value"
Следующее
От: Andreas Ntaflos
Дата:
Сообщение: Re: [BUGS] BUG #14457: Using hyphens/dashes insynchronous_standby_names fails with "invalid value"