Forgotten to CC the list too, sorry. again.. >1073741818 is a bit less than 1GB and 1073741818+32 is a bit more. So >you are obviously hitting a 1GB limit here. >Given that 1GB is the maximum length of a character type value in >PostgreSQL and the error message mentions a "string buffer", I suspect >that your query tries to construct a very long string. Try to rewrite >the query so that it creates several shorter strings instead.> hp
Peter, Thank you for your answer.I understood tht some buffer limit is reached. But I do not see where.The output is 1513 rows and 78 kb. -- _ | Peter J. Holzer | we build much bigger, better disasters now |_|_) | | because we have much more sophisticated | | | h...@hjp.at | management tools. __/ | http://www.hjp.at/ | -- Ross Anderson <https://www.edge.org/>
