Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-sql-owner+M37730=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
 id 1WPy0p-00072x-QN
 for pgsql-sql@arkaria.postgresql.org; Tue, 18 Mar 2014 17:41:15 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-sql-owner+M37730=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
 id 1WPy0p-0000dL-AI
 for pgsql-sql@arkaria.postgresql.org; Tue, 18 Mar 2014 17:41:15 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <emilu@encs.concordia.ca>) id 1WPy0o-0000dE-9l
 for pgsql-sql@postgresql.org; Tue, 18 Mar 2014 17:41:14 +0000
Received: from oldperseverance.encs.concordia.ca ([132.205.96.92])
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <emilu@encs.concordia.ca>) id 1WPy0k-00086V-PG
 for pgsql-sql@postgresql.org; Tue, 18 Mar 2014 17:41:14 +0000
Received: from cacao.encs.concordia.ca (emilu@cacao.encs.concordia.ca
 [132.205.47.225])
 by oldperseverance.encs.concordia.ca (envelope-from emilu@encs.concordia.ca)
 (8.13.7/8.13.7) with ESMTP id s2IHf7Su009059
 for <pgsql-sql@postgresql.org>; Tue, 18 Mar 2014 13:41:07 -0400
Message-ID: <53288533.4010805@encs.concordia.ca>
Date: Tue, 18 Mar 2014 13:41:07 -0400
From: Emi Lu <emilu@encs.concordia.ca>
Reply-To: emilu@encs.concordia.ca
User-Agent: Mozilla/5.0 (X11; Linux i686 on x86_64;
 rv:24.0) Gecko/20100101 Thunderbird/24.3.0
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Alter column with views depended on it without drop views
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Scanned-By: MIMEDefang 2.58 on oldperseverance.encs.concordia.ca at
 2014/03/18 13:41:07 EDT
X-Pg-Spam-Score: -1.9 (-)
List-Archive: <http://archives.postgresql.org/pgsql-sql>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-sql.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@postgresql.org>
List-Post: <mailto:pgsql-sql@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-sql>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
X-Mailing-List: pgsql-sql
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

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


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql