Does PostgreSQL allow ddl and dml in the same transaction?

I

Introducer2018-04-26 11:48:23

SQL

Introducer, 2018-04-26 11:48:23

If yes, are there any restrictions?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

M

Melkij, 2018-04-26
@melkij

Yes, it does.
In some cases, it breaks transaction isolation, for example, truncate is immediately visible from concurrent transactions, but on rollback its effect will be rolled back normally.

Similar questions

T

twittoponchik2022-01-07 12:30:00

Can I withdraw money from AdSense to my IP if the application is posted on Google Play on behalf of an LLC? 5Reply

S

strelkovandreyv2019-09-10 07:09:07

What is the PHP file manager with the ability to connect via SMB to Windows share? 2Reply

A

Antoonio542019-09-13 12:46:26

Functionality, then layout, or vice versa? 7Reply

S

shdprogrammer2016-02-21 14:23:12

NEW and JOIN in BEFORE INSERT postgresql trigger? 1Reply

A

andrenos2020-07-06 12:07:23

How to display a list? 1Reply

Didn't find what you were looking for?

Ask your question