Обсуждение: Overidding default values of inherited tables

Поиск
Список
Период
Сортировка

Overidding default values of inherited tables

От
Nico D
Дата:
Please let me know how to overide the DEFAULT value in
inherited tables?
(using PG 7.0.2)

create table objects (
       id serial,
       type name DEFAULT 'object'
       );

create table books (
       title name,
--     type name DEFAULT 'book'  <--- how to do?
       ) inherits(objects);

create table hats (
       color name,
--     type name DEFAULT 'hat'  <--- how to do?
       ) inherits(objects);


PG tells me I cannot redefine the attribute "type",
right, but how about redefining the default value...