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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
