Re: [GENERAL] Need concrete "Why Postgres not MySQL"

> Can someone explain me why is it usefull if the table created in
> transaction disapears on rollback?

Because then you can write big scripts like we do at work to install a new
feature in the live database.  Such a script might create two new tables,
add columns to existing tables, drop and recreate some foreign keys, etc.
What you do is to test it you go 'begin;' and then execute the script.  If
it all worked, commit, else rollback and fix the script.  Repeat until you
get it right.

Chris