Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Hackers > Re: alter + pre...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 12 of 12 Topic 9306 of 10408
Post > Topic >>

Re: alter + preserving dependencies

by Kevin.Grittner@[EMAIL PROTECTED] ("Kevin Grittner") May 7, 2008 at 09:45 AM

>>> 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
 




 12 Posts in Topic:
alter + preserving dependencies
andrew@[EMAIL PROTECTED]   2008-05-06 13:14:16 
Re: alter + preserving dependencies
josh@[EMAIL PROTECTED] (  2008-05-06 10:27:46 
Re: alter + preserving dependencies
andrew@[EMAIL PROTECTED]   2008-05-06 13:35:40 
Re: alter + preserving dependencies
tgl@[EMAIL PROTECTED] (T  2008-05-06 13:44:02 
Re: alter + preserving dependencies
dim@[EMAIL PROTECTED] (D  2008-05-07 07:41:38 
Re: alter + preserving dependencies
tgl@[EMAIL PROTECTED] (T  2008-05-07 01:52:10 
Re: alter + preserving dependencies
dim@[EMAIL PROTECTED] (D  2008-05-07 08:22:38 
Re: alter + preserving dependencies
dfontaine@[EMAIL PROTECTE  2008-05-07 11:05:38 
Re: alter + preserving dependencies
dev@[EMAIL PROTECTED] (R  2008-05-07 10:23:44 
Re: alter + preserving dependencies
tgl@[EMAIL PROTECTED] (T  2008-05-07 10:26:50 
Re: alter + preserving dependencies
dim@[EMAIL PROTECTED] (D  2008-05-07 19:54:11 
Re: alter + preserving dependencies
Kevin.Grittner@[EMAIL PRO  2008-05-07 09:45:56 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Oct 14 6:07:01 CDT 2008.