Re: BEGIN/END in SQL generated by pgAdmin ERD command
| От | Marc Linster |
|---|---|
| Тема | Re: BEGIN/END in SQL generated by pgAdmin ERD command |
| Дата | |
| Msg-id | CAPnyYmxS8rd-XRjhZdr4_YRndrBysY4-G9WXLHERe82nvYVjyA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: BEGIN/END in SQL generated by pgAdmin ERD command (Dave Page <dpage@pgadmin.org>) |
| Список | pgadmin-support |
Thanks Dave - I had an error message, but it turned out that was related to my code.
M.
---------------------------------------
Marc Linster; Marc@MarcLinster.com;
+352 621 430 156
On Mon, Jun 2, 2025 at 4:46 PM Dave Page <dpage@pgadmin.org> wrote:
HiOn 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.5Am 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.--Dave PagepgAdmin: https://www.pgadmin.orgPostgreSQL: https://www.postgresql.org
В списке pgadmin-support по дате отправления: