Re: [HACKERS] TODO items: Alter view add column

2009-07-06 Thread Kevin Grittner
Bruce Momjian wrote: > The problem is that third item is an email subject, not text we can > typically modify. Is it really more important that the line in the TODO list reflect the subject line of the referenced email than that it accurately describe the work we want done? If so, perhaps so

Re: [HACKERS] TODO items: Alter view add column

2009-07-06 Thread Alvaro Herrera
Jaime Casanova wrote: > On Mon, Jul 6, 2009 at 3:15 PM, Bernd Helmle wrote: > > --On Montag, Juli 06, 2009 13:51:36 -0400 Bruce Momjian > > wrote: > > > >> I think we only completed this for 8.4: > >> > >>             * Allow "CREATE OR REPLACE VIEW" to add columns to the end > >>                o

Re: [HACKERS] TODO items: Alter view add column

2009-07-06 Thread Bruce Momjian
Jaime Casanova wrote: > On Mon, Jul 6, 2009 at 3:15 PM, Bernd Helmle wrote: > > --On Montag, Juli 06, 2009 13:51:36 -0400 Bruce Momjian > > wrote: > > > >> I think we only completed this for 8.4: > >> > >> ? ? ? ? ? ? * Allow "CREATE OR REPLACE VIEW" to add columns to the end > >> ? ? ? ? ? ? ? ?o

Re: [HACKERS] TODO items: Alter view add column

2009-07-06 Thread Jaime Casanova
On Mon, Jul 6, 2009 at 3:15 PM, Bernd Helmle wrote: > --On Montag, Juli 06, 2009 13:51:36 -0400 Bruce Momjian > wrote: > >> I think we only completed this for 8.4: >> >>             * Allow "CREATE OR REPLACE VIEW" to add columns to the end >>                of a view (Robert Haas) >> > > > Yes, t

Re: [HACKERS] TODO items: Alter view add column

2009-07-06 Thread Bernd Helmle
--On Montag, Juli 06, 2009 13:51:36 -0400 Bruce Momjian wrote: I think we only completed this for 8.4: * Allow "CREATE OR REPLACE VIEW" to add columns to the end of a view (Robert Haas) Yes, this is done, but we're still not able to drop or change column names

Re: [HACKERS] TODO items: Alter view add column

2009-07-06 Thread Bruce Momjian
Jaime Casanova wrote: > Hi, > > This one is still in the TODO (and marked as not done). but i think > this is partially done (at least the last entry should be removed), > right? > > Improve ability to modify views via ALTER TABLE >* Re: idea: storing view source in system catalogs >* mod

[HACKERS] TODO items: Alter view add column

2009-07-06 Thread Jaime Casanova
Hi, This one is still in the TODO (and marked as not done). but i think this is partially done (at least the last entry should be removed), right? Improve ability to modify views via ALTER TABLE * Re: idea: storing view source in system catalogs * modifying views * Re: patch: Add columns