Re: order by

From: Kirk Wolak <wolakk(at)gmail(dot)com>
To: Marc Millas <marc(dot)millas(at)mokadb(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: order by
Date: 2023-05-11 22:42:34
Message-ID: CACLU5mRAtc6LW5QXOHnrhS3Vbd2Gf9Pf6SPvn0Mq7UfftTQPvw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, May 11, 2023 at 11:30 AM Marc Millas <marc(dot)millas(at)mokadb(dot)com> wrote:

> On Thu, May 11, 2023 at 5:23 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
> wrote:
>
>> On 5/11/23 08:00, Marc Millas wrote:
>> >
>> > On Thu, May 11, 2023 at 4:43 PM Adrian Klaver <
>> adrian(dot)klaver(at)aklaver(dot)com
>> > <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>> >
>> > On 5/11/23 07:29, Marc Millas wrote:
>> > > Hi,
>>
>
please from psql do:
\l+ (That a lower case L)

on both databases. I ran into this once because I had used the DEFAULT
COLLATION on one and a SPECIFIC Collation on the other machine.

That would explain it.

You set these things when you create the database.

Kirk...

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kirk Wolak 2023-05-11 23:00:03 Re: "PANIC: could not open critical system index 2662" - twice
Previous Message Ron 2023-05-11 21:12:59 Re: order by