Обсуждение: overriding default value in inherited column

Is there an easy way to override the defined default value of a column in an
inherited table? For example:

CREATE table foo (
 "type"    int2 DEFAULT 0
);

CREATE table bar (
 "type"    int2 DEFAULT 1
) INHERITS (foo);

This gives the error:

ERROR: CREATE TABLE: attribute "type" already exists in inherited schema

which is understandable. In essence what I want to do is have each table
schema default to a different value.

-- m@