James Robinson <jlrobins@xxxxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
