MIME-Version: 1.0
References: 
 <CAKJANSAogEMmUKUHDA01LvQ2kV1YNvBbbU+oD9_edsoLBy4rDA@mail.gmail.com>
 <ZYLBPWEtcJm6IOKC@depesz.com>
In-Reply-To: <ZYLBPWEtcJm6IOKC@depesz.com>
From: intmail01 <intmail01@gmail.com>
Date: Thu, 21 Dec 2023 14:46:53 +0300
Message-ID: 
 <CAKJANSAvF2reW5P8idG3VCuQF7aRxnnb+NZ8GsPjWsxaskif2g@mail.gmail.com>
Subject: Re: Wich program generates "list index out of range" ? pgadmin or the
 server ?
To: depesz@depesz.com
Cc: pgsql-sql@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000050313f060d039c67"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKJANSAvF2reW5P8idG3VCuQF7aRxnnb%2BNZ8GsPjWsxaskif2g%40mail.gmail.com>
Precedence: bulk

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

Hi,

I try an insert clause with psql command and there is no error.
I use also libreoffice base interface and it works.
The Pgadmin command line works fine too.
The only failed interface is the Pgadmin array.  It shows "list index out
of range" for insertion in the array.

Best regards.

On Wed, Dec 20, 2023 at 1:26=E2=80=AFPM hubert depesz lubaczewski <depesz@d=
epesz.com>
wrote:

> On Tue, Dec 19, 2023 at 11:26:46AM +0300, intmail01 wrote:
> > 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 ?
>
> Connect with psql, and generate the same problem (same inserts).
>
> And you will know if the server is returning it.
>
> For what it's worth, in pg sources there is just one please where the
> phrase "list index out of range" exists, and it's in tests of plpython
> code. So, perhaps you have some trigger in plpython?
>
> Best regards,
>
> depesz
>
>

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

<div dir=3D"ltr"><div>Hi,</div><div><br></div><div>I try an insert clause w=
ith psql command and there is no error.</div><div>I use also libreoffice ba=
se interface and it works.</div><div>The Pgadmin command line works fine to=
o.</div><div>The only failed interface is the Pgadmin array.=C2=A0 It shows=
 &quot;list index out of range&quot; for insertion in the array.<br></div><=
div><br></div><div>Best regards.<br></div></div><br><div class=3D"gmail_quo=
te"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Dec 20, 2023 at 1:26=E2=
=80=AFPM hubert depesz lubaczewski &lt;<a href=3D"mailto:depesz@depesz.com"=
>depesz@depesz.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote=
" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);=
padding-left:1ex">On Tue, Dec 19, 2023 at 11:26:46AM +0300, intmail01 wrote=
:<br>
&gt; My db have some complex triggers and it failed when inserting line.<br=
>
&gt; I use Pgadmin and it display message &quot;list index out of range&quo=
t;.<br>
&gt; Could someone tell me which program is responsible of this message, pg=
admin<br>
&gt; or the remote server ?<br>
<br>
Connect with psql, and generate the same problem (same inserts).<br>
<br>
And you will know if the server is returning it.<br>
<br>
For what it&#39;s worth, in pg sources there is just one please where the<b=
r>
phrase &quot;list index out of range&quot; exists, and it&#39;s in tests of=
 plpython<br>
code. So, perhaps you have some trigger in plpython?<br>
<br>
Best regards,<br>
<br>
depesz<br>
<br>
</blockquote></div>

--00000000000050313f060d039c67--