Re: Smartest way to resize a column?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
Cc: Adrian Klaver <aklaver(at)comcast(dot)net>, Ian Barwick <barwick(at)gmail(dot)com>, PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Smartest way to resize a column?
Date: 2009-02-03 05:30:54
Message-ID: 19360.1233639054@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Owen Hartnett 2009-02-03 06:18:36 libpq on iPhone?
Previous Message Pavel Stehule 2009-02-03 05:23:29 Re: display array field as row