MIME-Version: 1.0
References: 
 <CAKJANSAogEMmUKUHDA01LvQ2kV1YNvBbbU+oD9_edsoLBy4rDA@mail.gmail.com>
In-Reply-To: 
 <CAKJANSAogEMmUKUHDA01LvQ2kV1YNvBbbU+oD9_edsoLBy4rDA@mail.gmail.com>
From: Steve Midgley <science@misuse.org>
Date: Tue, 19 Dec 2023 08:50:34 -0800
Message-ID: 
 <CAJexoS+vv429_P78oEVjsEbdAqX85w9pyLzh3T7nkHv-2ptKFA@mail.gmail.com>
Subject: Re: Wich program generates "list index out of range" ? pgadmin or the
 server ?
To: intmail01 <intmail01@gmail.com>
Cc: pgsql-sql@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000d793be060cdfaace"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJexoS%2Bvv429_P78oEVjsEbdAqX85w9pyLzh3T7nkHv-2ptKFA%40mail.gmail.com>
Precedence: bulk

--000000000000d793be060cdfaace
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, Dec 19, 2023 at 12:23=E2=80=AFAM intmail01 <intmail01@gmail.com> wr=
ote:

> Hi,
>
> My db have some complex triggers and it failed when inserting line.
> I use Pgadmin and it display message "list index out of range".
> Could someone tell me which program is responsible of this message,
> pgadmin or the remote server ?
>
>
I'm not sure where it's coming from but it likely means that your query is
not returning any results, or a subquery is not returning results. Pgadmin
itself won't care if your resultset is zero rows, but something internal to
your query could be causing this. I'm guessing your complex triggers or
related insert statement is dependent on a value which is not being
returned as needed. But others here with deeper expertise may have better
input for you. For me, I'd recommend trying to examine the different pieces
of the trigger function and the insert function separately to try to locate
the source more precisely..

Steve

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

<div dir=3D"ltr"><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail=
_attr">On Tue, Dec 19, 2023 at 12:23=E2=80=AFAM intmail01 &lt;<a href=3D"ma=
ilto:intmail01@gmail.com">intmail01@gmail.com</a>&gt; wrote:<br></div><bloc=
kquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:=
1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">Hi,<br><br>My=
 db have some complex triggers and it failed when inserting line.<br>I use =
Pgadmin and it display message &quot;list index out of range&quot;.<br>Coul=
d someone tell me which program is responsible of this message, pgadmin or =
the remote server ?<br><br></div></blockquote><div><br></div><div>I&#39;m n=
ot sure where it&#39;s coming from but it likely means that your query is n=
ot returning any results, or a subquery is not returning results. Pgadmin i=
tself won&#39;t care if your resultset is zero rows, but something internal=
 to your query could be causing this. I&#39;m guessing your complex trigger=
s or related insert statement is dependent on a value which is not being re=
turned as needed. But others here with deeper expertise may have better inp=
ut for you. For me, I&#39;d recommend trying to examine the different piece=
s of the trigger function and the insert function separately to try to loca=
te the source more precisely..<br></div><div><br></div><div>Steve <br></div=
></div></div>

--000000000000d793be060cdfaace--