TODO items: Alter view add column

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
* modifying views
* Re: patch: Add columns via CREATE OR REPLACE VIEW

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)

so I think those links are all still relevant.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

--On Montag, Juli 06, 2009 13:51:36 -0400 Bruce Momjian <bruce@momjian.us>
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
of a view.

--
Thanks

Bernd

On Mon, Jul 6, 2009 at 3:15 PM, Bernd Helmle<mailings@oopsware.de> wrote:

--On Montag, Juli 06, 2009 13:51:36 -0400 Bruce Momjian <bruce@momjian.us>
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
of a view.

Then the 3rd point on that item should be removed or reworded...

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

Jaime Casanova wrote:

On Mon, Jul 6, 2009 at 3:15 PM, Bernd Helmle<mailings@oopsware.de> wrote:

--On Montag, Juli 06, 2009 13:51:36 -0400 Bruce Momjian <bruce@momjian.us>
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
of a view.

Then the 3rd point on that item should be removed or reworded...

The problem is that third item is an email subject, not text we can
typically modify.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

Jaime Casanova wrote:

On Mon, Jul 6, 2009 at 3:15 PM, Bernd Helmle<mailings@oopsware.de> wrote:

--On Montag, Juli 06, 2009 13:51:36 -0400 Bruce Momjian <bruce@momjian.us>
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
of a view.

Then the 3rd point on that item should be removed or reworded...

I think the main text of the item should be reworded or made more
verbose, to make more explicit what is it about. I think vague
descriptions of TODO items are a bad idea in general because you can
never close them. If an item is too big, perhaps it should be split in
multiple, more manageable items.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

Bruce Momjian <bruce@momjian.us> 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 someone should start a new
thread which references back to the old one from which work is already
done, committed, and released.

-Kevin