Thom Brown <t...@linux.com> wrote: > On 16 February 2013 01:01, Kevin Grittner <kgri...@ymail.com> wrote: >> Unless something else comes up in review or I get feedback to >> the contrary I plan to deal with the above-mentioned issues and >> commit this within a week or two. > > At the moment it's not possible to rename a column without using > ALTER TABLE on an MV. > > Also, shouldn't we have the ability to set the collation on a > column of the MV?
Will fix. > And the inconsistency between regular views and MVs is still > present, where MVs always dump with column parameters in their > definition, and views never do. Not a show-stopper, but curious > nonetheless. I haven't worried about this because current behavior generates correct results -- this seems like a micro-optimization. The explanation for why it wound up that way is that creating a materialized view is in many ways more like creating a table than like creating a view -- it seemed safer and less invasive to modify the CREATE TABLE code than the CREATE VIEW code, and specifying column names just fell out of that as part of the minimal change. In looking at the pg_dump output, though, I see that the CMV AS clause also is getting the names right with column-level aliases, so it should be pretty simple and safe to leave off the column-list section for MVs. I guess it's worth it just to forestall further questions on the topic. Thanks! -Kevin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers