Database Design Theory?

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


On Tue, 08 Nov 2005 18:58:17 -0700, "Gabriel Gunderson" <gabe at gundy.org>
said:
> 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...
> 
> CREATE TABLE fruits
> (
>     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.

See http://archives.postgresql.org/pgsql-advocacy/2004-06/msg00236.php

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




More information about the PLUG mailing list