Postgres Pro
Downloads
Home   >   mailing lists

Re: Partition with check constraint with "like" - Mailing list pgsql-performance

From David Rowley
Subject Re: Partition with check constraint with "like"
Date
Msg-id CAApHDvriy5vqSpDb_qzo=KCpi8kjgFbDEyOn=BkbUuZsmGRj8Q@mail.gmail.com
Whole thread Raw
In response to Re: Partition with check constraint with "like"  (Nagaraj Raj <nagaraj.sf@yahoo.com>)
List pgsql-performance
Tree view 
On Sat, 22 May 2021 at 10:59, Nagaraj Raj <nagaraj.sf@yahoo.com> wrote:
> ERROR: empty range bound specified for partition "mytable_z" DETAIL: Specified lower bound ('Z') is greater than or
equalto upper bound ('['). SQL state: 42P17
 

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

David

pgsql-performance by date:

Previous
From: David Rowley
Date:
Subject: Re: Partition with check constraint with "like"
Next
From: "Michel SALAIS"
Date:
Subject: RE: Partition with check constraint with "like"