Skip to main content

New answers tagged

3 votes
Accepted

Why must I commit after the ALTER TABLE DDL to make changes visible?

Some DBMS will commit automatically after ddl operations, but postgres is not one of them. Check the settings in dbeaver, you may have auto commit disabled. In the version of dbeaver I checked it is ...
Lennart - Slava Ukraini's user avatar
0 votes

Why must I commit after the ALTER TABLE DDL to make changes visible?

I thought DDL statements didn't have the concept of commit and rollback You were wrong. do I have to commit after every one in my flyway update scripts? You only need to commit when you want other ...
mustaccio's user avatar
  • 26.4k

Top 50 recent answers are included