public inbox for [email protected]  

help / color / mirror / Atom feed

From: Steve Midgley <[email protected]>
To: intmail01 <[email protected]>
Cc: [email protected]
Subject: Re: Wich program generates "list index out of range" ? pgadmin or the server ?
Date: Tue, 19 Dec 2023 08:50:34 -0800
Message-ID: <CAJexoS+vv429_P78oEVjsEbdAqX85w9pyLzh3T7nkHv-2ptKFA@mail.gmail.com> (raw)
In-Reply-To: <CAKJANSAogEMmUKUHDA01LvQ2kV1YNvBbbU+oD9_edsoLBy4rDA@mail.gmail.com>
References: <CAKJANSAogEMmUKUHDA01LvQ2kV1YNvBbbU+oD9_edsoLBy4rDA@mail.gmail.com>

On Tue, Dec 19, 2023 at 12:23 AM intmail01 <[email protected]> wrote:

> 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

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Wich program generates "list index out of range" ? pgadmin or the server ?
  In-Reply-To: <CAJexoS+vv429_P78oEVjsEbdAqX85w9pyLzh3T7nkHv-2ptKFA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox