| From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
|---|---|
| To: | Lukas Eklund <lukas(at)eklund(dot)io> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Resize numeric column without changing data? |
| Date: | 2012-04-09 22:16:53 |
| Message-ID: | 1334009813.5289.57.camel@sussancws0025 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
Regards,
Jeff Davis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2012-04-09 22:20:20 | Re: Resize numeric column without changing data? |
| Previous Message | Merlin Moncure | 2012-04-09 22:13:41 | Re: Resize numeric column without changing data? |