alter column from varchar(32) to varchar(255) without view re-creation

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: alter column from varchar(32) to varchar(255) without view re-creation
Date: 2009-02-24 15:27:18
Message-ID: 49A411D6.8080909@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Good morning,

I am using PostgreSQL 8.0.15.

Is there a way that I can easily alter column type from varchar(32) to
varchar(255) but do not have to worry about views dependent on it?

If Psql could support column alter without views' dependencies, that
will be great!

Thanks a lot,
-
Lu Ying

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Marcin Stępnicki 2009-02-24 16:09:08 Re: alter column from varchar(32) to varchar(255) without view re-creation
Previous Message Tarlika Elisabeth Schmitz 2009-02-23 15:48:44 Re: JOIN and aggregate problem