Re: Making a varchar bigger - Mailing list pgsql-general

From Tom Lane
Subject Re: Making a varchar bigger
Date
Msg-id 11214.1104518785@sss.pgh.pa.us
Whole thread Raw
In response to Re: Making a varchar bigger  (Derik Barclay <dbarclay@givex.com>)
List pgsql-general
Derik Barclay <dbarclay@givex.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump and pgpool
Next
From: Jeff Davis
Date:
Subject: Re: postgresql 8.0 Rc1