[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: Empty Range Bound Specified for Partition
From: ramsiddu007 <ramsiddu007 () gmail ! com>
Date: 2018-11-22 9:22:19
Message-ID: CA+zEy7_w1RQdRSwsMxV_aWAjEuM-WKjbUH3qGzL3YrV5bX8JGg () mail ! gmail ! com
[Download RAW message or body]
Thank you for the clarification.
On Thu, 22 Nov 2018 at 13:30, Alban Hertroys <haramrae@gmail.com> wrote:
>
> > On 22 Nov 2018, at 7:21, ramsiddu007 <ramsiddu007@gmail.com> wrote:
> >
> > pgsql> create table test_upto_100 partition of test_parent_partition
> > for values from ('51') to ('100');
> >
> > It was showing error like this..
> >
> > ERROR: empty range bound specified for partition "test_upto_100"
> > DETAIL: Specified lower bound ('51') is greater than or equal to upper
> bound ('100').
> > SQL state: 42P17
> >
> >
> > I am not getting, please give me cause of this and
> solution.
>
> Alphabetically, '1' comes before '5', so '100' comes before '51'.
> Numerically, you would get what you intended, but you're not partitioning
> on numbers but on strings instead and those sort alphabetically: '1', '10',
> '100', '11', '2', '3', '51', etc.
>
> Alban Hertroys
> --
> If you can't see the forest for the trees,
> cut the trees and you'll find there is no forest.
>
>
--
*Best Regards:*
Ramanna Gunde
*Don't complain about the HEAT,*
*PLANT A .*
[Attachment #3 (text/html)]
<div dir="ltr">Thank you for the clarification. <br></div><br><div \
class="gmail_quote"><div dir="ltr">On Thu, 22 Nov 2018 at 13:30, Alban Hertroys \
<<a href="mailto:haramrae@gmail.com">haramrae@gmail.com</a>> \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex"><br> > On 22 Nov 2018, at 7:21, \
ramsiddu007 <<a href="mailto:ramsiddu007@gmail.com" \
target="_blank">ramsiddu007@gmail.com</a>> wrote:<br> > <br>
> pgsql> create table test_upto_100 partition of test_parent_partition<br>
> for values from ('51') to ('100');<br>
> <br>
> It was showing error like this..<br>
> <br>
> ERROR: empty range bound specified for partition "test_upto_100"<br>
> DETAIL: Specified lower bound ('51') is greater than or equal to upper \
bound ('100').<br> > SQL state: 42P17<br>
> <br>
> <br>
> I am not getting, please give me cause of this and \
solution.<br> <br>
Alphabetically, '1' comes before '5', so '100' comes before \
'51'.<br> Numerically, you would get what you intended, but you're not \
partitioning on numbers but on strings instead and those sort alphabetically: \
'1', '10', '100', '11', '2', '3', \
'51', etc.<br> <br>
Alban Hertroys<br>
--<br>
If you can't see the forest for the trees,<br>
cut the trees and you'll find there is no forest.<br>
<br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" \
class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div \
dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div \
dir="ltr"><div><div dir="ltr"><div><u><b>Best Regards:</b></u></div><div><span \
style="font-family:comic sans ms,sans-serif">Ramanna Gunde</span></div><div><p \
style="text-align:left;color:rgb(0,0,0);text-transform:none;text-indent:0px;letter-spa \
cing:normal;font-family:Calibri,Helvetica,sans-serif;font-size:16px;font-style:normal; \
font-variant:normal;font-weight:400;text-decoration:none;margin-top:0px;margin-bottom:0px;word-spacing:0px;white-space:normal;background-color:transparent"><b><span \
style="text-align:left;color:rgb(0,0,0);text-transform:none;text-indent:0px;letter-spa \
cing:normal;font-family:Calibri,Helvetica,sans-serif;font-size:16px;font-style:normal; \
font-variant:normal;font-weight:400;text-decoration:none;word-spacing:0px;display:inline;white-space:normal;float:none;background-color:transparent">Don't
complain about the <span \
style="color:rgb(255,0,0);background-color:rgb(255,255,255)"> \
HEAT</span>,</span></b></p><span \
style="text-align:left;color:rgb(0,0,0);text-transform:none;text-indent:0px;letter-spa \
cing:normal;font-family:Calibri,Helvetica,sans-serif;font-size:16px;font-style:normal; \
font-variant:normal;font-weight:400;text-decoration:none;word-spacing:0px;display:inline;white-space:normal;float:none;background-color:transparent">
</span><p style="text-align:left;color:rgb(0,0,0);text-transform:none;text-indent:0px \
;letter-spacing:normal;font-family:Calibri,Helvetica,sans-serif;font-size:16px;font-st \
yle:normal;font-variant:normal;font-weight:400;text-decoration:none;margin-top:0px;mar \
gin-bottom:0px;word-spacing:0px;white-space:normal;background-color:transparent"><b><span \
style="text-align:left;color:rgb(0,0,0);text-transform:none;text-indent:0px;letter-spa \
cing:normal;font-family:Calibri,Helvetica,sans-serif;font-size:16px;font-style:normal; \
font-variant:normal;font-weight:400;text-decoration:none;word-spacing:0px;display:inli \
ne;white-space:normal;float:none;background-color:transparent"></span></b><b><span \
style="text-align:left;color:rgb(75,165,36);text-transform:none;text-indent:0px;letter \
-spacing:normal;font-family:Calibri,Helvetica,sans-serif;font-size:16px;font-style:nor \
mal;font-variant:normal;font-weight:400;text-decoration:none;word-spacing:0px;display:inline;white-space:normal;float:none;background-color:rgb(255,255,255)">PLANT
A <img><img src="https://docs.google.com/uc?export=download&id=1XtyUgXy2e9M9hld \
Gc7xLWhIdhLbRtKst&revid=0ByK9d6MO7qSfQVBFQ3Rha2pTYVEveXE1NWM4Ylk2ZjhrWE9NPQ">.</sp \
an></b></p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic