En un mensaje anterior, Tom Lane escribió:
> PG versions before 8.2 don't handle very long IN lists particularly
> well. This query will take a fair amount of stack space to parse, not
> to mention an unreasonably long time to plan. (You should consider
> putting the 16000 values in a temp table
Fernando Schapachnik <[EMAIL PROTECTED]> writes:
> En un mensaje anterior, Tom Lane escribió:
>> Fernando Schapachnik <[EMAIL PROTECTED]> writes:
>>> I've stumbled upon what seems to be a core-dumping infinite recursion
>>> in transformExpr(), on 8.1.6.
>>
>> A test case would help.
> The culpri
En un mensaje anterior, Tom Lane escribió:
> Fernando Schapachnik <[EMAIL PROTECTED]> writes:
> > I've stumbled upon what seems to be a core-dumping infinite recursion
> > in transformExpr(), on 8.1.6.
>
> A test case would help.
The culprit query looks like:
SELECT ...
FROM
(SELECT ...
Fernando Schapachnik <[EMAIL PROTECTED]> writes:
> I've stumbled upon what seems to be a core-dumping infinite recursion
> in transformExpr(), on 8.1.6.
A test case would help.
regards, tom lane
---(end of broadcast)---
TIP
I've stumbled upon what seems to be a core-dumping infinite recursion
in transformExpr(), on 8.1.6.
Backtrace:
Core was generated by `postgres'.
Program terminated with signal 10, Bus error.
Reading symbols from /usr/lib/libssl.so.3...(no debugging symbols
found)...done.
Loaded symbols for /usr
