Postgres Pro
Downloads
Home   >   mailing lists

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

From Emi Lu
Subject Alter column with views depended on it without drop views
Date
Msg-id 5329A94E.1020902@encs.concordia.ca
Whole thread Raw
Responses Re: Alter column with views depended on it without drop views  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
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-general by date:

Previous
From: Andy Colson
Date:
Subject: Re: High Level Committers Wanted
Next
From: Alvaro Herrera
Date:
Subject: Re: High Level Committers Wanted