Database Design Theory?

Jonathan Ellis jonathan at
Tue Nov 8 20:30:04 MST 2005

On Tue, 08 Nov 2005 18:58:17 -0700, "Gabriel Gunderson" <gabe at>
> Ah, I was hoping I could bring up PostgreSQL (8.1 -just out- makes PG
> sweeter then ever)!
> Now, I'm not saying you should do this, but in many cases it works...
> (
>     name     VARCHAR(20) NOT NULL,
>     is_yummy BOOLEAN NOT NULL
> );
> CREATE TABLE oranges
> (
>     is_hard_to_peel BOOLEAN NOT NULL
> ) INHERITS(fruit);

I tried to use PG inheritance in a project earlier this year.  It
quickly became clear that it's not very useful except for toys.  Which
is unfortunate, because it has the potential to make life a lot easier
in some situations.


C++ is history repeated as tragedy. Java is history repeated as farce.  --Scott McKay

More information about the PLUG mailing list