Postgres Pro
Downloads
Home   >   mailing lists

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

From Dave Page
Subject Re: BEGIN/END in SQL generated by pgAdmin ERD command
Date
Msg-id CA+OCxowm--WdiC3k57i3SiyX0uMExayF6Fsdrq+HSQ-EcEvkxA@mail.gmail.com
Whole thread Raw
In response to BEGIN/END in SQL generated by pgAdmin ERD command  (Marc Linster <marc@marclinster.com>)
Responses Re: BEGIN/END in SQL generated by pgAdmin ERD command
List pgadmin-support
Tree view
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.


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

--

pgadmin-support by date:

Previous
From: Marc Linster
Date:
Subject: BEGIN/END in SQL generated by pgAdmin ERD command
Next
From: Marc Linster
Date:
Subject: Re: BEGIN/END in SQL generated by pgAdmin ERD command