On Mon, Apr 9, 2012 at 5:16 PM, Jeff Davis <pgsql@xxxxxxxxxxx> wrote: > On Mon, 2012-04-09 at 16:06 -0400, Lukas Eklund wrote: >> Ah. I must have not noticed that the typmod for views is not inherited >> automatically. I'm okay with developing a script to recreate the 15 or >> so views the depend on that table. What I'm trying to avoid is locking >> that table for a substantial amount of time. Thanks for the advice! > > FYI, later versions of postgres try to avoid rewrites of the table when > possible for simple ALTERs like the one you're talking about. > > Are you using PostgreSQL 9.1? Try it out in a simple test case... maybe > the lock is only held for an instant anyway. Some of these optimizations > went in 9.2 (not released yet) but I think the one you need is in 9.1. nope -- see link upthread. numeric is 9.2+ merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
