On Thu, Jan 27, 2011 at 1:57 PM, Jon Hoffman <jon@foursquare.com> wrote:
> This was originally discussed on this list
> here: http://postgresql.1045698.n5.nabble.com/Smartest-way-to-resize-a-column-td1915892.html
> Tom Lane suggested doing the resize in a BEGIN block at least to verify that
> "\d tablename" reflects the catalog update.
> - Jon
Good point. Best practices are to do all DDL in a transaction if
possible. But a lot of folks come from databases that do stupid and
unpredictable things when you try to do DDL in a transaction (ok,
that's basically damned near all of them except a couple of odd
rarities like informix)