overriding default value in inherited column

Started by Matt Magoffinabout 25 years ago1 messagesgeneral
Jump to latest
#1Matt Magoffin
mmagoffin@proxicom.com

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@