ALTER/DROP table/view assymmetry - Mailing list pgsql-general

From George Pavlov
Subject ALTER/DROP table/view assymmetry
Date
Msg-id 8C5B026B51B6854CBE88121DBF097A8602EF62C8@ehost010-33.exch010.intermedia.net
Whole thread Raw
Responses Re: ALTER/DROP table/view assymmetry  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Re: Shopping cart
Next
From: Alvaro Herrera
Date:
Subject: Re: How to get schema name which violates fk constraint