Re: [External] LIMIT not showing all results

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: [External] LIMIT not showing all results
Date: 2019-03-05 17:54:33
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andreas Kretschmer <andreas(at)a-kretschmer(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2019-03-05 18:06:07 Re: [External] LIMIT not showing all results
Previous Message Andreas Kretschmer 2019-03-05 17:37:40 Re: [External] LIMIT not showing all results