Re: integrity and inherit - Mailing list pgsql-novice

From Bo Lorentsen
Subject Re: integrity and inherit
Date
Msg-id 3B85F673.F598F1FB@netgroup.dk
Whole thread Raw
In response to Re: integrity and inherit  ("Oliver Elphick" <olly@lfix.co.uk>)
List pgsql-novice
Oliver Elphick wrote:

> It's in the TODO list...

Are there any plans for whenever this will be fixed ? As fare as I can se, this is
an important feature if you need to use PostgreSQL as a real OO DB.

> There's an example below.  resources is the ancestor and has four
> descendants, all at the same level.  A resource key must occur only
> once in the whole hierarchy and needs to be available for RI. resource
> is a deferred class; that is, every resource must be a member of one of
> the four descendant classes, so resource itself should have no rows.

Sorry about the dumb question, but with this kind of knowledge, why haven't it
been fixed in the source code ?

The example you gave is somewhat complicated as I don't have much knowledge of the
internals in PosgreSQL. I hope someone will fix this soon, as this "tricker
solution" demands exact knowledge of the layout of postgresql.

If I need more of this hard core knowledge, where do I find this ? --- in the code
?

Thanks for taking you time to write this, I may be forced to use it later :-), but
as for now I will hope that I will be able to live with my non RI version, as I
will be using some kind for application server to access these.

/BL


pgsql-novice by date:

Previous
From: "Mark D. Leistner"
Date:
Subject: Date Type
Next
From: Bo Lorentsen
Date:
Subject: Identify an inherited table