Home > mailing lists

Re: psql 14.7/15.2 report a bogus syntax error on function and procedure files that use BEGIN ATOMIC - Mailing list pgsql-bugs

From	David G. Johnston
Subject	Re: psql 14.7/15.2 report a bogus syntax error on function and procedure files that use BEGIN ATOMIC
Date	March 13, 2023 07:47:26
Msg-id	CAKFQuwZVTWrjeh+a-7k8zgb2EhpMBHezFYE47odMdSZUZUPaKQ@mail.gmail.com Whole thread Raw
In response to	psql 14.7/15.2 report a bogus syntax error on function and procedure files that use BEGIN ATOMIC (David Adams <dpadams@gmail.com>)
Responses	Re: psql 14.7/15.2 report a bogus syntax error on function and procedure files that use BEGIN ATOMIC (David Adams <dpadams@gmail.com>)
List	pgsql-bugs

Tree view

On Sunday, March 12, 2023, David Adams <dpadams@gmail.com> wrote:


DROP FUNCTION IF EXISTS tools.tell_me_how_atomic();
CREATE OR REPLACE FUNCTION tools.tell_me_how_atomic()

RETURNS text

LANGUAGE SQL

BEGIN ATOMIC

return 'atomic';

END;

Not a bug, user-error.

https://www.postgresql.org/docs/current/sql-createfunction.html

There are two valid function body forms defined under “sql_body”. Yours is neither of those. Rewrite your body using one of those forms. Removing being/end would make sense for this example.

David J.

pgsql-bugs by date:

From: Tom Lane
Date: 13 March 2023, 07:34:41
Subject: Re: psql 14.7/15.2 report a bogus syntax error on function and procedure files that use BEGIN ATOMIC

From: David Adams
Date: 13 March 2023, 07:49:26
Subject: Re: psql 14.7/15.2 report a bogus syntax error on function and procedure files that use BEGIN ATOMIC

Re: psql 14.7/15.2 report a bogus syntax error on function and procedure files that use BEGIN ATOMIC - Mailing list pgsql-bugs

Previous

Next