| From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Jasper Potts <jasper(at)jasperpotts(dot)com>, pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Select where id in (LARGE LIST) ? |
| Date: | 2005-08-03 03:23:21 |
| Message-ID: | 42F038A9.2090100@opencloud.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Minal | 2005-08-03 06:05:27 | postgresql.stat.result |
| Previous Message | Oliver Jowett | 2005-08-03 03:13:42 | Re: Select where id in (LARGE LIST) ? |