force view column varchar(32) to varchar(128)

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: force view column varchar(32) to varchar(128)
Date: 2010-11-19 15:02:25
Message-ID: 4CE69181.1050803@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

Is there a way to force the view column change from varhcar(32) to
varchar(128)?

Example:
===================
v1 (id varchar(32) ... )

There are more than 1000 other views depend on v1.

Instead of recreating all other 1000 views, is there a way postgresql
8.3 can do/accept:

create or replace v1 AS

select id::varchar(128), ......

Thanks a lot!
--
Lu Ying

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Kretschmer 2010-11-19 16:54:56 Re: force view column varchar(32) to varchar(128)
Previous Message Oliveiros d'Azevedo Cristina 2010-11-18 10:09:11 Re: obtaining difference between minimum value and next in size