Date: Wed, 20 Dec 2023 11:26:05 +0100
From: hubert depesz lubaczewski <depesz@depesz.com>
Sender: depesz@depesz.com
To: intmail01 <intmail01@gmail.com>
Cc: pgsql-sql@lists.postgresql.org
Subject: Re: Wich program generates "list index out of range" ? pgadmin or
 the server ?
Message-ID: <ZYLBPWEtcJm6IOKC@depesz.com>
Reply-To: depesz@depesz.com
References: 
 <CAKJANSAogEMmUKUHDA01LvQ2kV1YNvBbbU+oD9_edsoLBy4rDA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: 
 <CAKJANSAogEMmUKUHDA01LvQ2kV1YNvBbbU+oD9_edsoLBy4rDA@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/ZYLBPWEtcJm6IOKC%40depesz.com>
Precedence: bulk

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