Allow column type to change without worrying about view dependencies - Mailing list pgsql-sql

From Emi Lu
Subject Allow column type to change without worrying about view dependencies
Date
Msg-id 4A16BCCD.1020508@encs.concordia.ca
Whole thread Raw
List pgsql-sql
Good morning,

When there are lots of views and complicated dependencies, it is not 
easy to alter column from varchar(a) to varchar(b).

Is it possible when defining a view, adding cascade or some other key 
word(s) to allow column type change?

When column1 is changed, all related views' column type is changed as well.

Thanks,
---
Lu Ying



pgsql-sql by date:

Previous
From: James Kitambara
Date:
Subject: Re: Need help combining 2 tables together
Next
From: "Oliveiros Cristina"
Date:
Subject: Re: Need help combining 2 tables together