ALTER/DROP table/view assymmetry

From: "George Pavlov" <gpavlov(at)mynewplace(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: ALTER/DROP table/view assymmetry
Date: 2008-10-22 16:49:58
Message-ID: 8C5B026B51B6854CBE88121DBF097A8602EF62C8@ehost010-33.exch010.intermedia.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 views (dropping those requires
DROP VIEW).

Wouldn't it be cleaner if view operations worked only on views and table
ones on tables? At the very least maybe the docs for ALTER TABLE
probably should mention that it works on views too.

George

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Osvaldo Kussama 2008-10-22 16:55:31 Resp.: text array accumulate to multidimensional text array
Previous Message Ivan Sergio Borgonovo 2008-10-22 16:26:33 gin index and same query misteriously slowing down on a nearly-readonly DB