Postgres Pro
Downloads
Home   >   mailing lists

Altering a column type w/o dropping views - Mailing list pgsql-general

From Ow Mun Heng
Subject Altering a column type w/o dropping views
Date
Msg-id 1215424438.4952.46.camel@neuromancer.home.net
Whole thread Raw
Responses Re: Altering a column type w/o dropping views
List pgsql-general
Tree view 
I'm going to alter a bunch a tables columns's data type and I'm being
forced to drop a view which depends on the the colum.

eg: ALTER TABLE xs.d_trh ALTER m_dcm TYPE character varying;
ERROR:  cannot alter type of a column used by a view or rule
DETAIL:  rule _RETURN on view v_hpp depends on column "m_dcm"

Is there an alternative method of doing this w/o dropping the existing
view?

pgsql-general by date:

Previous
From: Dushyanth
Date:
Subject: Re: [Postgresql 8.2.3] autovacuum starting up even after disabling ?
Next
From: Jack Brown
Date:
Subject: Re: creating "a perfect sequence" column