public inbox for [email protected]
help / color / mirror / Atom feedFrom: Marc Linster <[email protected]>
To: Dave Page <[email protected]>
Cc: pgadmin-support <[email protected]>
Subject: Re: BEGIN/END in SQL generated by pgAdmin ERD command
Date: Tue, 3 Jun 2025 11:18:04 +0200
Message-ID: <CAPnyYmxS8rd-XRjhZdr4_YRndrBysY4-G9WXLHERe82nvYVjyA@mail.gmail.com> (raw)
In-Reply-To: <CA+OCxowm--WdiC3k57i3SiyX0uMExayF6Fsdrq+HSQ-EcEvkxA@mail.gmail.com>
References: <CAPnyYmzMA4TU5i+3ZgTsbC7wfYy9wSMKz=+yjC9q9ZF47NBbnA@mail.gmail.com>
<CA+OCxowm--WdiC3k57i3SiyX0uMExayF6Fsdrq+HSQ-EcEvkxA@mail.gmail.com>
Thanks Dave - I had an error message, but it turned out that was related to
my code.
M.
---------------------------------------
Marc Linster; [email protected];
https://www.linkedin.com/in/marclinster;
https://marclinster.medium.com
+352 621 430 156
On Mon, Jun 2, 2025 at 4:46 PM Dave Page <[email protected]> wrote:
> Hi
>
> On Mon, 2 Jun 2025 at 15:30, Marc Linster <[email protected]> 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
>
>
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: BEGIN/END in SQL generated by pgAdmin ERD command
In-Reply-To: <CAPnyYmxS8rd-XRjhZdr4_YRndrBysY4-G9WXLHERe82nvYVjyA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox