On Thu, Jan 27, 2011 at 1:57 PM, Jon Hoffman <j...@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) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general