Allow column type to change without worrying about view dependencies

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: PostgreSQL SQL List <pgsql-sql(at)postgresql(dot)org>
Subject: Allow column type to change without worrying about view dependencies
Date: 2009-05-22 14:55:09
Message-ID: 4A16BCCD.1020508@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Oliveiros Cristina 2009-05-22 15:31:38 Re: Need help combining 2 tables together
Previous Message James Kitambara 2009-05-22 14:47:27 Re: Need help combining 2 tables together