Thread: Inheritance and Defaults

Inheritance and Defaults

From
Luis Quintano
Date:
Hello

I'm trying to migrate a postgres db on version 6.4 to 7.0 but inexpectedly
I noticed that 7.0 doesn't allow default values on subclasses.

Example:

create table foo (x text default 'bar',y int4);
create table foo1 (x text default 'bar1', y int4) inherits (foo);

insert into foo1 (y) values (1);

this insert means no problem in 6.4 (and in 6.5) but is not possible in
7.0.

How can I pass through this problem?

Luis Quintano
-------------
Serviço de Computação
Universidade de Évora

http://lex.uevora.pt