SEO

#11 (**permalink**) 05-07-2008, 06:21 PM

>>> Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Dimitri Fontaine <dim@hi-media.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

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

#12 (**permalink**) 05-07-2008, 06:21 PM

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Le 7 mai 08 à 16:26, Tom Lane a écrit :
> 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.

Quite obviously, +1.

- --
dim
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (Darwin)

iEYEARECAAYFAkgh7MMACgkQlBXRlnbh1bnhzACeM9JSHFd/yBjIO+fFLz+SAFC6
eCgAn05/5y1E7eA/qz27ZsBY5+vxHvsn
=zroi
-----END PGP SIGNATURE-----

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

alter + preserving dependencies