demo.out

application/octet-stream

Filename: demo.out

Type: application/octet-stream

Part: 1

Message: Parsing error with begin atomic syntax used in a do block

                                                       version                                                       
---------------------------------------------------------------------------------------------------------------------
 PostgreSQL 16.1 (Debian 16.1-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
(1 row)

CREATE TABLE
Create the procedure outside of a DO block
The following line should print "CREATE PROCEDURE":
CREATE PROCEDURE
Create the procedure in a DO block, with the old syntax
The following line should print "DO":
DO
Create the procedure in a DO block, with the begin atomic syntax
The following line should print "DO":
psql:demo.sql:42: ERROR:  42601: syntax error at end of input
LINE 7:             insert into example (id) values (1);
                                                       ^
LOCATION:  scanner_yyerror, scan.l:1233