Re: alter + preserving dependencies

>>> Tom Lane <tgl@[EMAIL PROTECTED]
> wrote: 
> Dimitri Fontaine <dim@[EMAIL PROTECTED]
> writes:
>> My 8.3.1 installation psql \h only gives me:
>> Syntax:
>> ALTER VIEW name RENAME TO newname
> 
> You're not the first person to think that ALTER VIEW covers
everything
> that can be done to a view.
> 
> I'm starting to think that we should just make ALTER VIEW be an
alias
> for ALTER TABLE (rather than a separate node type as now), and then
list
> in the ALTER VIEW reference page all of the ALTER TABLE variants
that
> will work on views.
 
From a DBA perspective, it reduces the risk of error if ALTER TABLE
only affects tables, not views, and ALTER VIEW only affects views, not
tables.
 
-Kevin
 


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers