Re: Partition with check constraint with "like"

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: Nagaraj Raj <nagaraj(dot)sf(at)yahoo(dot)com>
Cc: Michel SALAIS <msalais(at)msym(dot)fr>, Justin Pryzby <pryzby(at)telsasoft(dot)com>, Pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Partition with check constraint with "like"
Date: 2021-05-22 01:38:48
Message-ID: CAApHDvriy5vqSpDb_qzo=KCpi8kjgFbDEyOn=BkbUuZsmGRj8Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sat, 22 May 2021 at 10:59, Nagaraj Raj <nagaraj(dot)sf(at)yahoo(dot)com> wrote:
> ERROR: empty range bound specified for partition "mytable_z" DETAIL: Specified lower bound ('Z') is greater than or equal to upper bound ('['). SQL state: 42P17

It looks like '[' does not come after 'Z' in your collation.

David

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Michel SALAIS 2021-05-22 05:41:43 RE: Partition with check constraint with "like"
Previous Message David Rowley 2021-05-22 01:38:16 Re: Partition with check constraint with "like"