MIME-Version: 1.0
From: Pavel Stehule <pavel.stehule@gmail.com>
Date: Thu, 1 Jan 2026 08:10:13 +0100
Message-ID: <CAFj8pRCveWPR06bbad9GnMb0Kcr6jnXPttv9XOaOB+oFCD1Tsg@mail.gmail.com>
Subject: not fully correct error message
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000df586e06474e4a6d"
Archived-At: <https://www.postgresql.org/message-id/CAFj8pRCveWPR06bbad9GnMb0Kcr6jnXPttv9XOaOB%2BoFCD1Tsg%40mail.gmail.com>
Precedence: bulk

--000000000000df586e06474e4a6d
Content-Type: text/plain; charset="UTF-8"

Hi

I tested one use case, and maybe I found little bit possible error message

create procedure test()
as $$
begin
  vacuum;
end;
$$ language plpgsql;

(2026-01-01 08:04:05) postgres=# call test();
ERROR:  25001: VACUUM cannot be executed from a function
CONTEXT:  SQL statement "vacuum"
PL/pgSQL function test() line 3 at SQL statement
LOCATION:  PreventInTransactionBlock, xact.c:3695
(2026-01-01 08:09:18) postgres=#

should be "VACUUM cannot be executed from a function or a procedure"
instead ?

Regards

Pavel

--000000000000df586e06474e4a6d
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi</div><div><br></div><div>I tested one use case, an=
d maybe I found little bit possible error message</div><div><br></div><div>=
create procedure test()<br>as $$<br>begin<br>=C2=A0 vacuum;<br>end;<br>$$ l=
anguage plpgsql;</div><div><br></div><div>(2026-01-01 08:04:05) postgres=3D=
# call test();<br>ERROR: =C2=A025001: VACUUM cannot be executed from a func=
tion<br>CONTEXT: =C2=A0SQL statement &quot;vacuum&quot;<br>PL/pgSQL functio=
n test() line 3 at SQL statement<br>LOCATION: =C2=A0PreventInTransactionBlo=
ck, xact.c:3695<br>(2026-01-01 08:09:18) postgres=3D#</div><div><br></div><=
div>should be &quot;VACUUM cannot be executed from a function or a procedur=
e&quot; instead ?</div><div><br></div><div>Regards</div><div><br></div><div=
>Pavel</div></div>

--000000000000df586e06474e4a6d--