Overidding default values of inherited tables - Mailing list pgsql-general

From Nico D
Subject Overidding default values of inherited tables
Date
Msg-id 0729.001013@mclink.it
Whole thread Raw
List pgsql-general
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...



pgsql-general by date:

Previous
From: Nico D
Date:
Subject: Referential integrity and inheritance.
Next
From: "Sergio A. Kessler"
Date:
Subject: using cr/lf files in copy from