Inheritance and Defaults

From: Luis Quintano <ljcq(at)uevora(dot)pt>
To: pgsql-general(at)postgresql(dot)org
Subject: Inheritance and Defaults
Date: 2001-01-09 18:03:37
Message-ID: 20010109180337.C3021@beane
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-01-09 18:09:31 Re: Re: COPY error: pqReadData() -- backend closed the channel unexpectedly
Previous Message Tom Lane 2001-01-09 18:03:23 Re: trouble with db-restore