Inheritance and Defaults - Mailing list pgsql-general

From Luis Quintano
Subject Inheritance and Defaults
Date
Msg-id 20010109180337.C3021@beane
Whole thread Raw
List pgsql-general
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




pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: COPY error: pqReadData() -- backend closed the channel unexpectedly
Next
From: Heiko Irrgang
Date:
Subject: Re: trouble with db-restore