Re: Slaves show different results for query

Поиск
Список
Период
Сортировка
От Musall Maik
Тема Re: Slaves show different results for query
Дата
Msg-id 9D8988B2-4D63-4514-981E-C5ECABD2CFEE@musall.de
обсуждение исходный текст
Ответ на Re: Slaves show different results for query  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: Slaves show different results for query
Список pgsql-general
> Am 20.05.2015 um 15:17 schrieb Adrian Klaver <adrian.klaver@aklaver.com>:
>
> On 05/19/2015 11:52 PM, Musall Maik wrote:
>> Hi,
>>
>> I have a strange case where a SELECT for a primary key returns 0 rows on one slave, while it returns the correct 1
rowon another slave and on the master. It does however return that row on all slaves when queried with LIKE and
trailingor leading wildcard. 
>>
>> […]

>> Does anyone have a hint?
>
> What are the encodings on the various machines and in the databases?

All encodings UTF8, all collate and ctype en_US.UTF-8. What do you mean by "machines" exactly? This is not dependent on
shellenvironment or something, I get this also via JDBC. 

Maik



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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Slaves show different results for query
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Slaves show different results for query