Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Tutorial

From: David Fetter <david(at)fetter(dot)org>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>,Joe Conway <mail(at)joeconway(dot)com>, elein <elein(at)varlena(dot)com>,pgsql-docs(at)postgresql(dot)org
Subject: Re: [HACKERS] Tutorial
Date: 2004-07-23 18:51:46
Message-ID: 20040723185146.GV7751@fetter.org (view raw or flat)
Thread:
Lists: pgsql-docspgsql-hackers
On Fri, Jul 23, 2004 at 09:03:30AM +0200, Peter Eisentraut wrote:
> Tom Lane wrote:
> > Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> writes:
> > > +1/2 (Since I don't like inheritence)
> > >
> > > IMHO we ought to try to keep the _tutorial_ free of things that
> > > are generally considered against relational design.
> >
> > Where is it written that inheritance is against relational design?
> 
> I would venture that it is nowhere written that it is part of
> relational design.  It is, however, unambiguously part of
> object-relational design, if that's what we're aiming for.

I see I have put my foot in it again.  Please bear with me here.
Object-relational in general is not broken and is being worked on.
Custom data-types, custom aggregates, etc., etc. are working just
great, and lots of people use them.

What *is* broken is table inheritance, and the docs need to reflect
this.

If the parent table has a foreign key to another table foo, CASCADEing
DELETEs on foo leave ghost entries in the tables with inheritance.
Please find enclosed a repro, which demonstrates the problem on CVS
tip and 7.4.3.

Just an FYI, I first discovered this problem in a payment system.

Cheers,
D
-- 
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

In response to

Responses

pgsql-docs by date

Next:From: Tom LaneDate: 2004-07-23 19:31:47
Subject: Re: [HACKERS] Tutorial
Previous:From: Peter EisentrautDate: 2004-07-23 07:03:30
Subject: Re: [HACKERS] Tutorial

pgsql-hackers by date

Next:From: Tony ReinaDate: 2004-07-23 18:52:14
Subject: Can I determine the server name from PGresult?
Previous:From: Bruce MomjianDate: 2004-07-23 18:45:36
Subject: Re: patch for allowing multiple -t options to pg_dump

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group