Re: [HACKERS] ALTER TABLE should change respective views

2009-05-05 Thread Archana Sundararam
views To: "Peter Eisentraut" Cc: pgsql-hackers@postgresql.org, "Archana Sundararam" Date: Tuesday, May 5, 2009, 8:10 AM Peter Eisentraut writes: > And this could then also change the return type of foo(), thus changing the > row type of the view and would thus propogate

[HACKERS] ALTER TABLE should change respective views

2009-05-04 Thread Archana Sundararam
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