ALTER TABLE should change respective views

From: Archana Sundararam <archnasr(at)yahoo(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: ALTER TABLE should change respective views
Date: 2009-05-04 20:11:22
Message-ID: 695167.33964.qm@web33004.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2009-05-04 20:29:48 Re: windows shared memory error
Previous Message Chris Browne 2009-05-04 19:21:10 Re: conditional dropping of columns/constraints