Re: Composite types as columns used in production?

James Robinson <jlrobins(at)socialserve(dot)com> writes:
> Hmm -- I see that if the composite type was created via a table
> definition, then you _can_ actually add and drop columns, and the
> tables using the composite type seem to get updated, as in
> http://archives.postgresql.org/pgsql-hackers/2005-03/msg00621.php .
> That's sweet, and if this is supportable functionality as opposed to an
> odd side-effect, then the 'ALTER TYPE' and 'CREATE TYPE' doc pages may
> well want to reference this feature.

My recollection is that there are some pretty serious limitations on
what you can do in this line, but basic cases do work. I think the lack
of an ALTER TYPE that can handle the same cases is just a matter of lack
of round tuits.

regards, tom lane