Search Postgresql Archives

Re: resizing a varchar column on 8.3.8

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 01/15/2011 04:22 PM, Jon Hoffman wrote:
Hi,

I found a post with some instructions for resizing without locking up
the table, but would like to get some re-assurance that this is the best
way:

http://sniptools.com/databases/resize-a-column-in-a-postgresql-table-without-changing-data

How does that affect data storage and future updates on existing rows?

I did not see any feedbacks about this topic.

I need confirmation that it is safe to do this! Personally, I feel that it is specially useful when there are many view dependencies. Update from data dictionary, all views will be updated automatically, right?

Thanks a lot!
--
Lu Ying

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux