Re: Smartest way to resize a column? - Mailing list pgsql-general

From Phoenix Kiula
Subject Re: Smartest way to resize a column?
Date
Msg-id e373d31e0902022237g7a4e6722m2c6692f9349c024e@mail.gmail.com
Whole thread Raw
In response to Re: Smartest way to resize a column?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Tue, Feb 3, 2009 at 1:30 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Phoenix Kiula <phoenix.kiula@gmail.com> writes:
>> Tom, this has worked, and a "\d TABLENAME" shows that the column is
>> varchar(35).
>
>> But I still have messages in my log saying:
>>   ERROR:  value too long for type character varying(20)
>
> Cached plans maybe?
>
>                        regards, tom lane
>



Could be. How should I circumvent them? The table is being vacuum
analyzed every hour. Why are the plans cached?

pgsql-general by date:

Previous
From: Owen Hartnett
Date:
Subject: libpq on iPhone?
Next
From: Alban Hertroys
Date:
Subject: Re: Smartest way to resize a column?