From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Adams <dpadams@gmail.com>
cc: pgsql-bugs@lists.postgresql.org
Subject: Re: psql 14.7/15.2 report a bogus syntax error on function and
 procedure files that use BEGIN ATOMIC
In-reply-to: 
 <CAPXPcQuSEWTCqVnoiVALpkdAM_HXXdAf8kYm0WYF8Z2htX6v-A@mail.gmail.com>
References: 
 <CAPXPcQuSEWTCqVnoiVALpkdAM_HXXdAf8kYm0WYF8Z2htX6v-A@mail.gmail.com>
Comments: In-reply-to David Adams <dpadams@gmail.com>
	message dated "Mon, 13 Mar 2023 15:20:28 +1100"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1666632.1678682081.1@sss.pgh.pa.us>
Date: Mon, 13 Mar 2023 00:34:41 -0400
Message-ID: <1666633.1678682081@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1666633.1678682081%40sss.pgh.pa.us>
Precedence: bulk

David Adams <dpadams@gmail.com> writes:
> CREATE OR REPLACE FUNCTION tools.tell_me_how_atomic()
> RETURNS text
> LANGUAGE SQL
> BEGIN ATOMIC
> return 'atomic';
> END;
> [ throws a syntax error ]

This works for me.  I wonder if you have some issues with bogus
invisible characters in your actual input file.  Copying and
pasting from your mail (but removing the schema name for
convenience), I got

regression=# CREATE OR REPLACE FUNCTION tell_me_how_atomic()
regression-# 
regression-# RETURNS text
regression-# 
regression-# LANGUAGE SQL
regression-# 
regression-# BEGIN ATOMIC
regression-# 
regression-# return 'atomic';
regression-# 
regression-# END;
CREATE FUNCTION
regression=# select * from tell_me_how_atomic()
regression-# ;
 tell_me_how_atomic 
--------------------
 atomic
(1 row)

			regards, tom lane