MIME-Version: 1.0
References: <7bc2cd63-dff7-46bf-9cca-ee950463f13a@quadratum-braccas.com>
In-Reply-To: <7bc2cd63-dff7-46bf-9cca-ee950463f13a@quadratum-braccas.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Tue, 22 Oct 2024 07:47:32 -0700
Message-ID: 
 <CAKFQuwbOfs-vtxODz9o8_mHWOu2=kfYjL17NUTO7pp6C+Wo1kQ@mail.gmail.com>
Subject: Re: ERROR Inserting into partition
To: Sbob <sbob@quadratum-braccas.com>
Cc: "pgsql-performance@lists.postgresql.org"
 <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000093976c062511db12"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwbOfs-vtxODz9o8_mHWOu2%3DkfYjL17NUTO7pp6C%2BWo1kQ%40mail.gmail.com>
Precedence: bulk

--00000000000093976c062511db12
Content-Type: text/plain; charset="UTF-8"

>
>
> INSERT INTO part_schema.cust_info_5
> ( cust_last_name)
> SELECT l_name from public.global_addr WHERE l_name = 'NELL';
> ERROR:  new row for relation "cust_info_5" violates partition constraint
> DETAIL:  Failing row containd (null, null, null, null, null, 'NELL',
> null, null, null, null, null,null).
>
>
Your to: address for this email is so confusing...and this really isn't
either a performance issue (meaning speed, not failure to perform at all)
or admin issue (general advice for running the server).  It seems like a
bug report, though one missing the most critical piece of information, the
version.

David J.

--00000000000093976c062511db12
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_quote"><blockquote class=3D"gmail_quot=
e" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204)=
;padding-left:1ex"><br>
INSERT INTO part_schema.cust_info_5<br>
( cust_last_name)<br>
SELECT l_name from public.global_addr WHERE l_name =3D &#39;NELL&#39;;<br>
ERROR:=C2=A0 new row for relation &quot;cust_info_5&quot; violates partitio=
n constraint<br>
DETAIL:=C2=A0 Failing row containd (null, null, null, null, null, &#39;NELL=
&#39;, <br>
null, null, null, null, null,null).<br>
<br></blockquote><div><br></div><div><div class=3D"gmail_default" style=3D"=
font-family:arial,helvetica,sans-serif">Your to: address for this email is =
so confusing...and this really isn&#39;t either a performance issue (meanin=
g speed, not failure to perform at all) or admin issue (general advice for =
running the server).=C2=A0 It seems like a bug report, though one missing t=
he most critical piece of information, the version.</div><div class=3D"gmai=
l_default" style=3D"font-family:arial,helvetica,sans-serif"><br></div><div =
class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif">Da=
vid J.</div></div><div class=3D"gmail_default" style=3D"font-family:arial,h=
elvetica,sans-serif"><br></div></div></div>

--00000000000093976c062511db12--