"Herbert R. Ambos" <hrambos(at)transco(dot)ph> writes:
> [ drops only column of a table ]
> Is this allowed in SQL?
The SQL spec forbids that. We deliberately decided to ignore the spec
restriction, because it creates too many unpleasant boundary cases for
tools that want to manipulate table definitions. "DROP COLUMN foo"
shouldn't depend on whether there are other columns besides foo.
In short, yes, it's a feature.
regards, tom lane