Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: control reached end of function without RETURN, except, it is not a function it is a procedure or a nameless block. - Mailing list pgsql-general

From Tom Lane
Subject Re: ERROR: control reached end of function without RETURN, except, it is not a function it is a procedure or a nameless block.
Date
Msg-id 423907.1631549088@sss.pgh.pa.us
Whole thread Raw
In response to Re: ERROR: control reached end of function without RETURN, except, it is not a function it is a procedure or a nameless block.  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view 
Pavel Stehule <pavel.stehule@gmail.com> writes:
> po 13. 9. 2021 v 13:23 odesílatel Herwig Goemans <herwig.goemans@gmail.com>
> napsal:
>> I get an error in a stored procedure - not a stored function mind you -
>> control reached end of function without RETURN
>> The error occurs when doing an exit <label> in  a stored procedure.

> This is Postgres's bug

Yeah, agreed.  Looks reasonably simple to fix, though.

            regards, tom lane

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: ERROR: control reached end of function without RETURN, except, it is not a function it is a procedure or a nameless block.
Next
From: Israel Brewster
Date:
Subject: Fastest option to transfer db?