Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id DF6CF6329C0
	for <pgsql-bugs-postgresql.org@mail.postgresql.org>;
	Fri,  3 Sep 2010 14:54:00 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 65963-01 for
	<pgsql-bugs-postgresql.org@mail.postgresql.org>;
	Fri,  3 Sep 2010 17:53:53 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from cascavel.ensmp.fr (cascavel.ensmp.fr [194.214.158.227])
	by mail.postgresql.org (Postfix) with ESMTP id 9DFBF632C1D
	for <pgsql-bugs@postgresql.org>; Fri,  3 Sep 2010 14:53:53 -0300 (ADT)
Received: from cri.ensmp.fr (85.40.219-88.rev.gaoland.net [88.219.40.85] (may
	be forged)) (authenticated bits=0)
	by cascavel.ensmp.fr (8.14.3/8.14.3/JMMC-11/Mar/2010) with ESMTP id
	o83Hrm7M019326
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO);
	Fri, 3 Sep 2010 19:53:49 +0200 (MEST)
Date: Fri, 3 Sep 2010 19:53:48 +0200 (CEST)
From: Fabien COELHO <coelho@cri.ensmp.fr>
X-X-Sender: fabien@localhost.localdomain
Reply-To: Fabien COELHO <coelho@cri.ensmp.fr>
To: Alvaro Herrera <alvherre@commandprompt.com>
cc: PostgreSQL Bugs List <pgsql-bugs@postgresql.org>
Subject: Re: issue about information_schema REFERENTIAL_CONSTRAINTS
In-Reply-To: <1283535870-sup-2648@alvh.no-ip.org>
Message-ID: <alpine.DEB.2.00.1009031950390.2622@localhost.localdomain>
References: <alpine.DEB.2.00.1008311337530.2449@localhost.localdomain>
	<2683.1283266019@sss.pgh.pa.us>
	<alpine.DEB.2.00.1009011557480.2570@localhost.localdomain>
	<1283369900.15386.0.camel@vanquo.pezone.net>
	<alpine.DEB.2.00.1009020741380.2656@localhost.localdomain>
	<1283438419.23199.0.camel@vanquo.pezone.net>
	<alpine.DEB.2.00.1009021959070.2656@localhost.localdomain>
	<6462.1283454730@sss.pgh.pa.us>
	<alpine.DEB.2.00.1009031348321.2448@localhost.localdomain>
	<22801.1283525905@sss.pgh.pa.us>
	<alpine.DEB.2.00.1009031920460.2622@localhost.localdomain>
	<1283535870-sup-2648@alvh.no-ip.org>
User-Agent: Alpine 2.00 (DEB 1167 2008-08-23)
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
X-Miltered: at cascavel with ID 4C81362C.000 by Joe's j-chkmail (http : //
	j-chkmail dot ensmp dot fr)!
X-j-chkmail-Enveloppe: 4C81362C.000 from
	[88.219.40.85]/85.40.219-88.rev.gaoland.net/88.219.40.85/cri.ensmp.fr/<coelho@cri.ensmp.fr>
X-Scores-Stats: 4C81362C.000 B=0.02357 L=0.21565 G=0.00659 Agree    
X-j-chkmail-Score: MSGID : 4C81362C.000 on cascavel.ensmp.fr : j-chkmail score
	: . : R=. U=. O=. B=0.007 -> S=0.008
X-j-chkmail-Status: Ham
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.51 tagged_above=-5 required=5 tests=BAYES_05=-0.5,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201009/30
X-Sequence-Number: 27994


> Maybe you shouldn't be using the information_schema in the first place.

Sure, I could write non standard code for every database instead of trying 
to write a portable code which work on all of them directly:-)

I think that trying to do the portable way, under the assumption that the 
standard implementation would be okay, was a reasonnable choice, even if 
proved wrong afterwards.

-- 
Fabien.