8.0 (and maybe newer releases also) throw dreaded "Stack lenght limit
exceeded"
message if IN contains large number or items.
Have y'all checked them there release notes? I'm sure they tell the
tale. (sorry too much True Blood...)
No. I need to support 8.0.
After those crashes I changed all IN clauses to
docid = ANY ({1,2,3,4,5,7,8,96,5445,.., 34534534})
this takes the same number of characters per id as IN clause.
I hope that this does not have any bad effects.
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
