Postgres Pro
Downloads
Home   >   mailing lists

Alter column with views depended on it without drop views - Mailing list pgsql-sql

From Emi Lu
Subject Alter column with views depended on it without drop views
Date
Msg-id 53288533.4010805@encs.concordia.ca
Whole thread Raw
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: ssylla
Date:
Subject: problem with update order (?)
Next
From: Jennifer Mackown
Date:
Subject: Table results format - should I use crosstab? If so, how?