Re: BUG #15428: "Inception" with recursive prepared statement causes infinite loop - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #15428: "Inception" with recursive prepared statement causes infinite loop
Date
Msg-id 1316.1539620501@sss.pgh.pa.us
Whole thread Raw
In response to BUG #15428: "Inception" with recursive prepared statement causesinfinite loop  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
> Using the extended query message flow, I prepare, bind and execute a query
> as a named statement.
> If I repeat this again with the query "execute <name>" – the backend crashes
> with a segmentation fault due to an infinite recursion (see excerpt
> below).

Hm, yeah.  I'm inclined to think that the right fix is a
check_stack_depth() call in standard_ProcessUtility.
That transforms the case into

$ ./test
PQexecPrepared failed: ERROR:  stack depth limit exceeded
HINT:  Increase the configuration parameter "max_stack_depth" (currently 2048kB), after ensuring the platform's stack
depthlimit is adequate. 

which seems like an adequate response, and would cover some
related scenarios as well.

            regards, tom lane


pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #15432: ddl logging includes password in plaintext
Next
From: Bart D
Date:
Subject: Re: BUG #15430: partition-wise join only works in combination withpruning on 1 partition