public inbox for [email protected]help / color / mirror / Atom feed
BEGIN/END in SQL generated by pgAdmin ERD command 3+ messages / 2 participants [nested] [flat]
* BEGIN/END in SQL generated by pgAdmin ERD command @ 2025-06-02 14:30 Marc Linster <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Marc Linster @ 2025-06-02 14:30 UTC (permalink / raw) To: pgadmin-support 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? Thanks, Marc --------------------------------------- Marc Linster; [email protected]; https://www.linkedin.com/in/marclinster; https://marclinster.medium.com +352 621 430 156 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BEGIN/END in SQL generated by pgAdmin ERD command @ 2025-06-02 14:45 Dave Page <[email protected]> parent: Marc Linster <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Dave Page @ 2025-06-02 14:45 UTC (permalink / raw) To: Marc Linster <[email protected]>; +Cc: pgadmin-support 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BEGIN/END in SQL generated by pgAdmin ERD command @ 2025-06-03 09:18 Marc Linster <[email protected]> parent: Dave Page <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Marc Linster @ 2025-06-03 09:18 UTC (permalink / raw) To: Dave Page <[email protected]>; +Cc: pgadmin-support 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 > > ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-06-03 09:18 UTC | newest] Thread overview: 3+ messages (download: mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-06-02 14:30 BEGIN/END in SQL generated by pgAdmin ERD command Marc Linster <[email protected]> 2025-06-02 14:45 ` Dave Page <[email protected]> 2025-06-03 09:18 ` Marc Linster <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox