| From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | Jeff Davis <pgsql(at)j-davis(dot)com> |
| Cc: | Lukas Eklund <lukas(at)eklund(dot)io>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Resize numeric column without changing data? |
| Date: | 2012-04-09 22:20:20 |
| Message-ID: | CAHyXU0ze-fVH9mqxKHK0bGTvJ8TTiinak2kaFRbi+Aa=dVFt0A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Apr 9, 2012 at 5:16 PM, Jeff Davis <pgsql(at)j-davis(dot)com> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | unclesam | 2012-04-10 05:50:40 | Instangram is powered by PostgreSQL |
| Previous Message | Jeff Davis | 2012-04-09 22:16:53 | Re: Resize numeric column without changing data? |