Postgres Pro
Downloads
Home   >   mailing lists

Re: [External] LIMIT not showing all results - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: [External] LIMIT not showing all results
Date
Msg-id 2A58A390-A362-41EF-99AB-0A5036189050@a-kretschmer.de
Whole thread Raw
In response to Re: [External] LIMIT not showing all results  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
On 5 March 2019 18:54:33 CET, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>Andreas Kretschmer <andreas@a-kretschmer.de> writes:
>> the other thing is, it would be nice to to know why the index is
>corrupt.
>
>Given that (a) this was triggered by a server migration and (b)
>the leading column of the index looks like it's probably varchar,
>I'm suspicious that the new server has different collation behavior.
>
>            regards, tom lane


yes, sounds reasonable.



Regards, Andreas.



--
2ndQuadrant - The PostgreSQL Support Company
--
2ndQuadrant - The PostgreSQL Support Company

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [External] LIMIT not showing all results
Next
From: Matthew Pounsett
Date:
Subject: Re: [External] LIMIT not showing all results