Re: transactional DDL

From: Lukas Kahwe Smith <smith(at)pooteeweet(dot)org>
To: pgsql-advocacy(at)postgresql(dot)org
Subject: Re: transactional DDL
Date: 2007-08-15 06:03:25
Message-ID: f9u500$2253$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-www

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

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Simon Riggs 2007-08-15 12:08:02 Re: 12 Silver Bullets
Previous Message Greg Smith 2007-08-15 05:18:31 Re: 12 Silver Bullets

Browse pgsql-www by date

  From Date Subject
Next Message Brian Gough 2007-08-15 08:44:20 Re: Printed Doc
Previous Message Josh Tolley 2007-08-15 03:10:14 Re: L