Re: [HACKERS] ALTER TABLE should change respective views

2009-05-05 Thread Archana Sundararam
] ALTER TABLE should change respective views To: Peter Eisentraut pete...@gmx.net Cc: pgsql-hackers@postgresql.org, Archana Sundararam archn...@yahoo.com Date: Tuesday, May 5, 2009, 8:10 AM Peter Eisentraut pete...@gmx.net writes: And this could then also change the return type of foo(), thus changing

[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