Overidding default values of inherited tables

From: Nico D <nico(at)mclink(dot)it>
To: pgsql-general(at)hub(dot)org
Subject: Overidding default values of inherited tables
Date: 2000-10-13 15:30:34
Message-ID: 0729.001013@mclink.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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...

Browse pgsql-general by date

  From Date Subject
Next Message Martin Gainty 2000-10-13 15:40:30 Re: not work in IE
Previous Message Marko Kreen 2000-10-13 15:26:21 Re: Postgres-7.0.2 optimization question