[GENERAL] ALTER/DROP table/view assymmetry

2008-10-22 Thread George Pavlov
This is minor, but just curious about the reasons for the assymetry between ALTER and DROP with respect to tables vs. views. * ALTER TABLE seems to work on both tables and views (even though ALTER VIEW exists, albeit with a limited operation support). * DROP TABLE works only on tables, not on

Re: [GENERAL] ALTER/DROP table/view assymmetry

2008-10-22 Thread Tom Lane
George Pavlov [EMAIL PROTECTED] writes: Wouldn't it be cleaner if view operations worked only on views and table ones on tables? It's not worth the backwards-compatibility issues that would ensue. regards, tom lane -- Sent via pgsql-general mailing list