public inbox for [email protected]
help / color / mirror / Atom feedWich program generates "list index out of range" ? pgadmin or the server ?
5+ messages / 3 participants
[nested] [flat]
* Wich program generates "list index out of range" ? pgadmin or the server ?
@ 2023-12-19 08:26 intmail01 <[email protected]>
2023-12-19 16:50 ` Re: Wich program generates "list index out of range" ? pgadmin or the server ? Steve Midgley <[email protected]>
2023-12-20 10:26 ` Re: Wich program generates "list index out of range" ? pgadmin or the server ? hubert depesz lubaczewski <[email protected]>
0 siblings, 2 replies; 5+ messages in thread
From: intmail01 @ 2023-12-19 08:26 UTC (permalink / raw)
To: [email protected]
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 ?
Thanks
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Wich program generates "list index out of range" ? pgadmin or the server ?
2023-12-19 08:26 Wich program generates "list index out of range" ? pgadmin or the server ? intmail01 <[email protected]>
@ 2023-12-19 16:50 ` Steve Midgley <[email protected]>
1 sibling, 0 replies; 5+ messages in thread
From: Steve Midgley @ 2023-12-19 16:50 UTC (permalink / raw)
To: intmail01 <[email protected]>; +Cc: [email protected]
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Wich program generates "list index out of range" ? pgadmin or the server ?
2023-12-19 08:26 Wich program generates "list index out of range" ? pgadmin or the server ? intmail01 <[email protected]>
@ 2023-12-20 10:26 ` hubert depesz lubaczewski <[email protected]>
2023-12-21 11:46 ` Re: Wich program generates "list index out of range" ? pgadmin or the server ? intmail01 <[email protected]>
1 sibling, 1 reply; 5+ messages in thread
From: hubert depesz lubaczewski @ 2023-12-20 10:26 UTC (permalink / raw)
To: intmail01 <[email protected]>; +Cc: [email protected]
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Wich program generates "list index out of range" ? pgadmin or the server ?
2023-12-19 08:26 Wich program generates "list index out of range" ? pgadmin or the server ? intmail01 <[email protected]>
2023-12-20 10:26 ` Re: Wich program generates "list index out of range" ? pgadmin or the server ? hubert depesz lubaczewski <[email protected]>
@ 2023-12-21 11:46 ` intmail01 <[email protected]>
2023-12-21 12:13 ` Re: Wich program generates "list index out of range" ? pgadmin or the server ? hubert depesz lubaczewski <[email protected]>
0 siblings, 1 reply; 5+ messages in thread
From: intmail01 @ 2023-12-21 11:46 UTC (permalink / raw)
To: [email protected]; +Cc: [email protected]
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 PM hubert depesz lubaczewski <[email protected]>
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
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Wich program generates "list index out of range" ? pgadmin or the server ?
2023-12-19 08:26 Wich program generates "list index out of range" ? pgadmin or the server ? intmail01 <[email protected]>
2023-12-20 10:26 ` Re: Wich program generates "list index out of range" ? pgadmin or the server ? hubert depesz lubaczewski <[email protected]>
2023-12-21 11:46 ` Re: Wich program generates "list index out of range" ? pgadmin or the server ? intmail01 <[email protected]>
@ 2023-12-21 12:13 ` hubert depesz lubaczewski <[email protected]>
0 siblings, 0 replies; 5+ messages in thread
From: hubert depesz lubaczewski @ 2023-12-21 12:13 UTC (permalink / raw)
To: intmail01 <[email protected]>; +Cc: [email protected]
On Thu, Dec 21, 2023 at 02:46:53PM +0300, intmail01 wrote:
> 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.
That kinda answers the question about "which program generates...",
doesn't it?
Best regards,
depesz
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2023-12-21 12:13 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-12-19 08:26 Wich program generates "list index out of range" ? pgadmin or the server ? intmail01 <[email protected]>
2023-12-19 16:50 ` Steve Midgley <[email protected]>
2023-12-20 10:26 ` hubert depesz lubaczewski <[email protected]>
2023-12-21 11:46 ` intmail01 <[email protected]>
2023-12-21 12:13 ` hubert depesz lubaczewski <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox