Re: [SQL] force view column varchar(32) to varchar(128)

2010-11-19 Thread Richard Broersma
On Fri, Nov 19, 2010 at 7:02 AM, Emi Lu wrote: > Is there a way to force the view column change from varhcar(32) to > varchar(128)? > Instead of recreating all other 1000 views, is there a way postgresql 8.3 > can do/accept: Ouch! That stinks. I feel your pain (well my pain came from just chan

Re: [SQL] force view column varchar(32) to varchar(128)

2010-11-19 Thread Andreas Kretschmer
Emi Lu wrote: > Hello, > > Is there a way to force the view column change from varhcar(32) to > varchar(128)? No, you have to recreate the view ... Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Li

[SQL] force view column varchar(32) to varchar(128)

2010-11-19 Thread Emi Lu
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