Re: Select where id in (LARGE LIST) ? - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Select where id in (LARGE LIST) ?
Date
Msg-id 42F038A9.2090100@opencloud.com
Whole thread Raw
In response to Re: Select where id in (LARGE LIST) ?  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
Oliver Jowett wrote:

> With a really big IN list (16384 triggered it, 8192 didn't) I get
> "ERROR: stack depth limit exceeded", though I guess this is more a limit
> in the handling of IN than a number-of-parameters limit per se.

And the end of the stack trace is this:

(... lots of transformExpr() recursion ...)
#11909 0x000000000048d4d2 in transformExpr ()
#11910 0x000000000048d4d2 in transformExpr ()
#11911 0x000000000048d4d2 in transformExpr ()
#11912 0x000000000048aa0e in transformWhereClause ()
#11913 0x0000000000479efc in transformStmt ()
#11914 0x000000000047b596 in do_parse_analyze ()
#11915 0x000000000047cad9 in parse_analyze_varparams ()
#11916 0x00000000005446f5 in exec_parse_message ()
#11917 0x0000000000545fc3 in PostgresMain ()
#11918 0x000000000051da0d in ServerLoop ()
#11919 0x000000000051ee6f in PostmasterMain ()
#11920 0x00000000004ee0af in main ()

-O

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Select where id in (LARGE LIST) ?
Next
From: Minal
Date:
Subject: postgresql.stat.result