| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | emuser20140816(at)gmail(dot)com |
| Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: BUG #15435: Infinite-recursive SQL procedure can crash a database server |
| Date: | 2018-10-17 14:12:15 |
| Message-ID: | 30131.1539785535@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
=?utf-8?q?PG_Bug_reporting_form?= <noreply(at)postgresql(dot)org> writes:
> CREATE PROCEDURE proc1() LANGUAGE sql AS 'CALL proc1();';
> CALL proc1(); -- crash
Works for me in 11.0, no doubt as a result of this last-minute fix:
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=db9034bf7653fa527e2531e1a713dbbd37066a6b
=# CALL proc1();
ERROR: stack depth limit exceeded
HINT: Increase the configuration parameter "max_stack_depth" (currently 2048kB), after ensuring the platform's stack depth limit is adequate.
CONTEXT: SQL function "proc1" statement 1
SQL function "proc1" statement 1
SQL function "proc1" statement 1
SQL function "proc1" statement 1
SQL function "proc1" statement 1
SQL function "proc1" statement 1
... lots more ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | fn ln | 2018-10-17 14:30:30 | Re: BUG #15435: Infinite-recursive SQL procedure can crash a database server |
| Previous Message | neela | 2018-10-17 12:53:51 | Fwd: Fwd: Re: General: Unable to start the postgresql after copying postgresql.log |