Re: BEGIN/END in SQL generated by pgAdmin ERD command - Mailing list pgadmin-support

Hi

On Mon, 2 Jun 2025 at 15:30, Marc Linster <marc@marclinster.com> wrote:

When I ask pgAdmin 9.4 to generate SQL from the ERD window, it wraps 'BEGIN;' and 'END;' around the set of statements, instead of 'BEGIN;/COMMIT;'.

This is for pgAdmin 9.4 on Sequoia 15.5

Am I missing something?

END is the same as COMMIT, albeit PostgreSQL specific and not part of the SQL standard.

https://www.postgresql.org/docs/17/sql-end.html

It would probably be nice to change it to COMMIT if someone felt inclined, but it's not a bug. 

--

Dave Page

pgAdmin: https://www.pgadmin.org

PostgreSQL: https://www.postgresql.org

pgEdge: https://www.pgedge.com