>>> Tom Lane <[EMAIL PROTECTED]> wrote: > Dimitri Fontaine <[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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
