Search Postgresql Archives

Re: resizing a varchar column on 8.3.8

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

 



This was originally discussed on this list here: http://postgresql.1045698.n5.nabble.com/Smartest-way-to-resize-a-column-td1915892.html

Tom Lane suggested doing the resize in a BEGIN block at least to verify that "\d tablename" reflects the catalog update.

- Jon

On Thu, Jan 27, 2011 at 3:39 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote:
It's one of those "It's perfectly safe, as long as nothing goes wrong"
types of things.  It should work, but I'd certainly play on a test
server first.  And if something goes wrong in the right way, you might
not even know it for a while.  But generally, it's pretty common to do
this one hackish thing with the catalogs.

On Thu, Jan 27, 2011 at 1:25 PM, Jon Hoffman <jon@xxxxxxxxxxxxxx> wrote:
> Hi,
> I was able to do this without any issues, though I don't have any views.
> - Jon
>
> On Thu, Jan 27, 2011 at 9:52 AM, Emi Lu <emilu@xxxxxxxxxxxxxxxxx> wrote:
>>
>> 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
>
>



--
To understand recursion, one must first understand recursion.


[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 Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux