[GENERAL] Resize numeric column without changing data?

2012-04-09 Thread Lukas Eklund
bout how numeric is stored on disk that I need be concerned about when altering the column in this method? Is it safe to just alter the metadata? Thanks, -- Lukas Eklund lu...@eklund.io -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Resize numeric column without changing data?

2012-04-09 Thread Lukas Eklund
On Mon, Apr 9, 2012 at 2:51 PM, Merlin Moncure wrote: > On Mon, Apr 9, 2012 at 9:57 AM, Lukas Eklund wrote: >> Is it safe to resize a numeric column using in pg_attribute without >> altering the table? >> > > One thing that's pretty weird is that dependent vi

Re: [GENERAL] Resize numeric column without changing data?

2012-04-10 Thread Lukas Eklund
On Mon, Apr 9, 2012 at 6:16 PM, Jeff Davis 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