On Thu, Aug 25, 2005 at 03:03:30PM -0700, CSN wrote: > For lack of a better term, but I was curious if there > is/was any thought about making PG's views > automatically "see" changes in underlying tables, as > opposed to currently having to drop/create all > corresponding views if a table's structure (add/delete > fields, etc.) is changed. There's not currently a TODO for this, no. http://www.postgresql.org/docs/faqs.TODO.html I'm not sure how hard it would be to do, since currently CREATE VIEW v AS SELECT * FROM t actually expands the * out at creation time. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
