Home > mailing lists

ALTER TABLE should change respective views - Mailing list pgsql-hackers

From	Archana Sundararam
Subject	ALTER TABLE should change respective views
Date	May 4, 2009 20:23:15
Msg-id	695167.33964.qm@web33004.mail.mud.yahoo.com Whole thread Raw
Responses	Re: ALTER TABLE should change respective views (Peter Eisentraut <peter_e@gmx.net>)
List	pgsql-hackers

Tree view

hi,

I have many views dependent on a table. So whenever I do alter table and change the column type I have to drop and recreate all the views. Is there any other easy way to propagate the changes in the table to the views.

Any suggestion is welcome.

Thanks,

Archana

pgsql-hackers by date:

From: "K, Niranjan (NSN - IN/Bangalore)"
Date: 04 May 2009, 19:06:49
Subject: Synchronous replication: Admin command for replication_timeout_action

From: Magnus Hagander
Date: 04 May 2009, 20:29:54
Subject: Re: windows shared memory error

ALTER TABLE should change respective views - Mailing list pgsql-hackers

Previous

Next