pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: David BOURIAUD <david.bouriaud@ac-rouen.fr>
To: pgsql-sql@postgresql.org
Subject: Re: About referential integrity.
Date: Tue, 26 Feb 2002 13:08:28 -0800
Message-ID: <web-810826@davinci.ethosmedia.com> (raw)
In-Reply-To: <200202260753.g1Q7rdx22057@necker.ac-rouen.fr>

David,

> Anyway, couldn't it be an extention to postgreSQL ? If you have heard
>  about 
> Business Objects, you should know that it can do it very well
>  provided you 
> draw the relationchips between the tables of your database. And it's
>  of much 
> use, since you just have to concentrate on the fields you want to
>  fetch and 
> the program takes care of the relations and handles group by, order
>  by and 
> where clause.

Certainly it could.  However, the project needs a really persuasive
 reason to transgress the SQL standard.  That is, substantial
 funcitonality needs to be gained from the extension, sufficient to
 offset the issues raised with porting applications to and from
 Postgresql. 

However, there appears to be a way to give you what you want without
 violating the standard:  we could make Natural Join work for
 foriegn-keyed columns, not just columns with similar names. This would
 give us some useful funcitionality without breaking the standard.

I understand from Stephan that there is some technical problem with
 this, but we could add it to the TODO list, yes?

-Josh Berkus



view thread (9+ messages)  latest in thread

Message-ID: <web-810826@davinci.ethosmedia.com>
Permalink:  ../web-810826@davinci.ethosmedia.com/
Also on:    postgresql.org/message-id/web-810826@davinci.ethosmedia.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: josh@agliodbs.com, david.bouriaud@ac-rouen.fr
  Subject: Re: About referential integrity.
  In-Reply-To: <web-810826@davinci.ethosmedia.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox