Re: Changing the default value of an inherited column - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Changing the default value of an inherited column
Date
Msg-id Pine.LNX.4.30.0103282309350.821-100000@peter.localdomain
Whole thread Raw
In response to Changing the default value of an inherited column  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Re: Changing the default value of an inherited column
List pgsql-hackers
Tom Lane writes:

> It seems that in pre-7.0 Postgres, this works:
>
> create table one(id int default 1, descr text);
> create table two(id int default 2, tag text) inherits (one);
>
> with the net effect that table "two" has just one "id" column with
> default value 2.

Although the liberty to do anything you want seems appealing at first, I
would think that allowing this is not correct from an OO point of view.
But given that our inheritance system actually has conceivably little
resemblance to real OO, I don't really care.

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Re: [BUGS] Tests randomly failed
Next
From: Bruce Momjian
Date:
Subject: Re: [PORTS] pgmonitor and Solaris