Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi

po 13. 9. 2021 v 13:23 odesílatel Herwig Goemans <herwig.goemans@xxxxxxxxx> napsal:
Hi Support,


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. Now
I cannot give all of the stored procedures involved but I can simulate
te problem with a very simple block:



DO
$BODY$
<<simple_block>>
BEGIN
begin
                exit simple_block;
          -- for demo purposes
               raise notice '%', 'unreachable!';
    end;
    raise notice '%', 'End of block';
end;
$BODY$

This will return the error on Postgres version 13, Version 12 and 9.


Now I thought this was text-book behaviour of exiting a code block. I do
not like programming this way but it is part of a migration project of
Oracle to PG.

What do I miss ?

This is Postgres's bug

You can use an just workaround - extra outer block BEGIN END;

Regards

Pavel



Kind regards,


If you put this code snippet in a file and execute like:

postgres@herwig-NUC10i7FNH:~$ psql -f  do_test.sql
psql:do_test.sql:12: ERROR:  control reached end of function without RETURN
CONTEXT:  PL/pgSQL function inline_code_block

Herwig




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux