not fully correct error message

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: not fully correct error message
Date: 2026-01-01 07:10:13
Message-ID: CAFj8pRCveWPR06bbad9GnMb0Kcr6jnXPttv9XOaOB+oFCD1Tsg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Lakhin 2026-01-01 08:00:00 Re: Typos in the code and README
Previous Message shveta malik 2026-01-01 07:02:14 Re: Proposal: Conflict log history table for Logical Replication