Re: ALTER composite type does not work, but ALTER TABLE which ROWTYPE is used as a type - works fine

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>, dmitry(at)koterov(dot)ru, pgsql-hackers(at)postgresql(dot)org
Subject: Re: ALTER composite type does not work, but ALTER TABLE which ROWTYPE is used as a type - works fine
Date: 2008-12-10 13:00:01
Message-ID: 200812101300.mBAD01f11814@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Robert Haas wrote:
> Allow ALTER TYPE to add, rename, change the type of, and drop columns?

That seems kind of vague because my first reaction is that a type
doesn't have columns, but you are talking about composite types, right?

I have added this TODO item:

Allow ALTER TYPE on composite types to perform operations similar to
ALTER TABLE

* http://archives.postgresql.org/pgsql-hackers/2008-12/msg00245.php

---------------------------------------------------------------------------

>
> ...Robert
>
> On Wed, Dec 10, 2008 at 6:36 AM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> > Robert Haas wrote:
> >> > Well, new features that have a perfectly acceptable and usable
> >> > workaround typically have a fairly low priority of fixing :-)
> >>
> >> Putting something in the TODO list doesn't make it a priority. But it
> >> indicates that it's something that the community would like to see
> >> fixed, if anyone is interested in doing the work. There is a lot more
> >> consensus for this item than many that have been added to the TODO
> >> list in the past.
> >
> > OK, so what should the TODO item be?
> >
> > --
> > Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
> > EnterpriseDB http://enterprisedb.com
> >
> > + If your life is a hard drive, Christ can be your backup. +
> >

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2008-12-10 13:16:16 Re: PostgreSQL 8.3.4 reproducible crash
Previous Message Merlin Moncure 2008-12-10 12:59:42 Re: ALTER composite type does not work, but ALTER TABLE which ROWTYPE is used as a type - works fine