Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 7132C6331F6
	for <pgsql-bugs-postgresql.org@mail.postgresql.org>;
	Fri,  3 Sep 2010 14:45:17 -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 34790-07 for
	<pgsql-bugs-postgresql.org@mail.postgresql.org>;
	Fri,  3 Sep 2010 17:45:10 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from spinlock.commandprompt.com (host-215.commandprompt.net
	[207.173.203.215])
	by mail.postgresql.org (Postfix) with ESMTP id 435F3632CD5
	for <pgsql-bugs@postgresql.org>; Fri,  3 Sep 2010 14:45:10 -0300 (ADT)
Received: from localhost (localhost [127.0.0.1])
	by spinlock.commandprompt.com (Postfix) with ESMTP id 312FB348013;
	Fri,  3 Sep 2010 10:45:09 -0700 (PDT)
X-Virus-Scanned: Debian amavisd-new at commandprompt.com
Received: from spinlock.commandprompt.com ([127.0.0.1])
	by localhost (spinlock.commandprompt.com.commandprompt.com [127.0.0.1])
	(amavisd-new, port 10024)
	with ESMTP id zUWXQ5icXxm9; Fri,  3 Sep 2010 10:45:05 -0700 (PDT)
Received: from perhan.alvh.no-ip.org (200-126-90-175.bk6-dsl.surnet.cl
	[200.126.90.175])
	by spinlock.commandprompt.com (Postfix) with ESMTPSA id 53E75348011;
	Fri,  3 Sep 2010 10:45:05 -0700 (PDT)
Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000)
	id 06A076E647; Fri,  3 Sep 2010 13:45:03 -0400 (CLT)
Content-Type: text/plain; charset=UTF-8
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Peter Eisentraut <peter_e@gmx.net>,
	PostgreSQL Bugs List <pgsql-bugs@postgresql.org>
Subject: Re: issue about information_schema REFERENTIAL_CONSTRAINTS
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Fabien COELHO <coelho@cri.ensmp.fr>
In-reply-to: <alpine.DEB.2.00.1009031920460.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>
Date: Fri, 03 Sep 2010 13:45:02 -0400
Message-Id: <1283535870-sup-2648@alvh.no-ip.org>
User-Agent: Sup/git
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201009/28
X-Sequence-Number: 27992

Excerpts from Fabien COELHO's message of vie sep 03 13:39:19 -0400 2010:

> I tried to explained that I'm analyzing other people's schemas. I cannot 
> ask all other people on the planet to rewrite their schemas, I pick them 
> as they are.

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

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support