Greg Smith wrote:
> There is now is a discussion of the benefits of PostgreSQL's
> transactional DDL abilities on the otherwise deprecated page at
Somewhat related ALTER TABLE in MySQL is actually a copy+drop, which
obviously is quite costly and time consuming. This is why they can offer
the convenience of allowing you to decide where to place a column in an
existing table. This in turn is something that ActiveRecord
implementations love, because they default to using the column order in
their view presentation. Which means a lot of people perceive this as a
missing feature in PostgreSQL.
regards,
Lukas