Skip to main content

New answers tagged

2 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.3k
1 vote

Create table that has a sequence column counting from 1 for every different foreign key

A serial (or IDENTITY) column is not the right tool for your purpose. Those are meant to handle concurrent write access gracefully, and expressly not to produce a gapless sequence of row numbers, much ...
Erwin Brandstetter's user avatar

Top 50 recent answers are included