Alter column with views depended on it without drop views

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Alter column with views depended on it without drop views
Date: 2014-03-18 17:41:07
Message-ID: 53288533.4010805@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello list,

Is there a way to change a table column from varchar(n) to varchar with
views depended on it.

The problem is that I do not want to drop and re-create all views
dependencies. I am looking for a way/command that can change the column
type and all views will be auto updated as well.

Thanks a lot!
Emi
--
PostgreSQL 8.3.18 on x86_64-unknown-linux-gnu

Browse pgsql-sql by date

  From Date Subject
Next Message Jennifer Mackown 2014-03-19 14:58:57 Table results format - should I use crosstab? If so, how?
Previous Message ssylla 2014-03-18 12:22:39 problem with update order (?)