Re: Select where id in (LARGE LIST) ?
От
Oliver Jowett
Тема
Re: Select where id in (LARGE LIST) ?
Дата
Msg-id
42F038A9.2090100@opencloud.com
Ответ на
Re: Select where id in (LARGE LIST) ? (Oliver Jowett)
Список
Дерево обсуждения
Select where id in (LARGE LIST) ? Jasper Potts <jasper@jasperpotts.com>
Re: Select where id in (LARGE LIST) ? Csaba Nagy <nagy@ecircle-ag.com>
Re: Select where id in (LARGE LIST) ? Jasper Potts <jasper@jasperpotts.com>
Re: Select where id in (LARGE LIST) ? Csaba Nagy <nagy@ecircle-ag.com>
Re: Select where id in (LARGE LIST) ? Jasper Potts <jasper@jasperpotts.com>
Re: Select where id in (LARGE LIST) ? Csaba Nagy <nagy@ecircle-ag.com>
Re: Select where id in (LARGE LIST) ? Oliver Jowett <oliver@opencloud.com>
Re: Select where id in (LARGE LIST) ? Jasper Potts <jasper@jasperpotts.com>
Re: Select where id in (LARGE LIST) ? Oliver Jowett <oliver@opencloud.com>
Re: Select where id in (LARGE LIST) ? Tom Lane <tgl@sss.pgh.pa.us>
Re: Select where id in (LARGE LIST) ? Oliver Jowett <oliver@opencloud.com>
Re: Select where id in (LARGE LIST) ? Oliver Jowett <oliver@opencloud.com>
Re: Select where id in (LARGE LIST) ? Oliver Jowett <oliver@opencloud.com>
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 по дате отправления
