| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | "Dimitri Fontaine" <dim(at)hi-media(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Josh Berkus" <josh(at)agliodbs(dot)com>, "Andrew Dunstan" <andrew(at)dunslane(dot)net>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: alter + preserving dependencies |
| Date: | 2008-05-07 14:45:56 |
| Message-ID: | 48217A50.EE98.0025.0@wicourts.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
>>> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Dimitri Fontaine <dim(at)hi-media(dot)com> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2008-05-07 14:47:36 | Re: Posting to hackers and patches lists |
| Previous Message | Magnus Hagander | 2008-05-07 14:41:56 | pgsql: Make the pg_stat_activity view call a SRF |