Hallo Markus,
Markus Schiltknecht wrote:
> Hallo Stefan,
>
> Stefan Sassenberg wrote:
>> Hello,
>>
>> I've got a failing sql-Script that I execute with the psql command.
>> The Script contains:
>
> I've been unable to reproduce the error with just that snippet (on
> debian with PostgreSQL 8.1.4). Can you provide a stripped down test case?
Reproduction is difficult. The script runs fine with the same db on
another server with a Linux derived from Knoppix, but also postgresql 8.1.4.
>
>> ----------------------------8<-----------------------------
>> PANIK: ERRORDATA_STACK_SIZE exceeded
>> server closed the connection unexpectedly
>> This probably means the server terminated abnormally
>> before or while processing the request.
>> ----------------------------8<-----------------------------
>
> 'Exceeding stack size' sound somewhat like an infinite loop of a
> recursive function... but that's just a very general guess. I think the
> root cause of problems is somewhere else.
As I see it, ERRORDATA_STACK_SIZE is a constant that is defined in the
code (pgsql/src/backend/utils/error/elog.c) as 5. 5 illegal bytecodes
that postgresql finds in my statement are enough to cause the panic.
Stefan