Re: BEGIN/END in SQL generated by pgAdmin ERD command

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Marc Linster <marc(at)marclinster(dot)com>
Cc: pgadmin-support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: BEGIN/END in SQL generated by pgAdmin ERD command
Date: 2025-06-02 14:45:51
Message-ID: CA+OCxowm--WdiC3k57i3SiyX0uMExayF6Fsdrq+HSQ-EcEvkxA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi

On Mon, 2 Jun 2025 at 15:30, Marc Linster <marc(at)marclinster(dot)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

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Murali Raghu (CTR) 2025-06-02 20:57:55 cannot locate my pgadmin 4 folder on windows 10
Previous Message Marc Linster 2025-06-02 14:30:22 BEGIN/END in SQL generated by pgAdmin ERD command