> I am thinking that it might be a good idea for ALTER TABLE DROP COLUMN
> to reset atttypid to zero in the dropped column's pg_attribute row.
> This would help catch any other places that are depending on a dropped
> column's atttypid to still be valid. On the other hand, it would
> possibly confuse applications that are looking at pg_attribute.
> Comments anyone?
I think you should zero it - we keep finding these little places where we've
missed thinking about dropped columns and that should flush them out. Any
application looking at the type of a dropped column is confused anyway...
(Or they're doing a join...which could result in the dropped column not
appearing in their result set but hey...)
Chris