Re: Making a varchar bigger

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Derik Barclay <dbarclay(at)givex(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Making a varchar bigger
Date: 2004-12-31 18:46:25
Message-ID: 11214.1104518785@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Derik Barclay <dbarclay(at)givex(dot)com> writes:
> On December 30, 2004 11:03 pm, Tom Lane wrote:
>> If you have any indexes or views referencing this column, then it's a
>> bit harder. But for the table itself I believe that will work.

> It is combined with another field to form an index.
> Does that mean a re-indexing will be required? or are there other issues?

No, I'm just thinking you should update atttypmod for the index column.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2004-12-31 20:14:38 Re: postgresql 8.0 Rc1
Previous Message Tom Lane 2004-12-31 18:44:13 Re: pg_dump and pgpool