Re: Assertion failure in HEAD and 13 after calling COMMIT in a stored proc - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Assertion failure in HEAD and 13 after calling COMMIT in a stored proc
Date
Msg-id 2050503.1624421231@sss.pgh.pa.us
Whole thread Raw
In response to Assertion failure in HEAD and 13 after calling COMMIT in a stored proc  (Jim Nasby <nasbyj@amazon.com>)
List pgsql-hackers
Justin Pryzby <pryzby@telsasoft.com> writes:
> This causes the server to crash during FETCH.

> ts=# begin; declare b cursor for VALUES(1); fetch 100 in b;
> BEGIN
> DECLARE CURSOR
> server closed the connection unexpectedly
>         This probably means the server terminated abnormally
>         before or while processing the request.
> The connection to the server was lost. Attempting reset: Failed.

Hm, works for me:

regression=# begin; declare b cursor for VALUES(1); fetch 100 in b;
BEGIN
DECLARE CURSOR
 column1 
---------
       1
(1 row)

            regards, tom lane



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: pgbench logging broken by time logic changes
Next
From: Amit Kapila
Date:
Subject: Re: Doc chapter for Hash Indexes