| From: | Musall Maik <lists(at)musall(dot)de> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Subject: | Re: Slaves show different results for query |
| Date: | 2015-05-20 13:34:49 |
| Message-ID: | 9D8988B2-4D63-4514-981E-C5ECABD2CFEE@musall.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> Am 20.05.2015 um 15:17 schrieb Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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 row on another slave and on the master. It does however return that row on all slaves when queried with LIKE and trailing or 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 shell environment or something, I get this also via JDBC.
Maik
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2015-05-20 13:43:18 | Re: Slaves show different results for query |
| Previous Message | Adrian Klaver | 2015-05-20 13:17:40 | Re: Slaves show different results for query |