Re: Thus spoke SQL3 (on OO) - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: Thus spoke SQL3 (on OO)
Date
Msg-id 39290031.EFB912F7@tm.ee
Whole thread Raw
In response to Thus spoke SQL3 (on OO)  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Chris Bitmead wrote:
> 
> Hannu Krosing wrote:
> 
> > it would be hard to define RI by just saying that some field references "an
> > OID",
> > often you want to be able do define something more specific.
> >
> > It would be too much for most users to require that all primary and foreign
> > keys must be of type OID.
> 
> Since it would be object and relational, you could do either. But all
> pure object databases _always_ rely on oid to define relationships, and
> that is likely to be all an ODMG inteface would support.

Is the ODMG interface available on the net, or is the plan to do a Poet clone
?

> Unless we want to break new ground anyway.

We would need some syntax to distinguish between REFERENCES (primary key) and
REFERENCES (oid).

Of course we would also need fast lookups by oid and oid->object lookup
tables(s)/function(s) but that's another part of the story.

--------------
Hannu


pgsql-hackers by date:

Previous
From: Mike Mascari
Date:
Subject: Re: [GENERAL] Re: Postgresql OO Patch
Next
From: "Ragnar Hakonarson"
Date:
Subject: plperl