Date: Thu, 2 Sep 2010 07:54:46 +0200 (CEST)
From: Fabien COELHO <coelho@cri.ensmp.fr>
Reply-To: Fabien COELHO <coelho@cri.ensmp.fr>
To: Peter Eisentraut <peter_e@gmx.net>
cc: PostgreSQL Bugs List <pgsql-bugs@postgresql.org>
Subject: Re: issue about information_schema REFERENTIAL_CONSTRAINTS
In-Reply-To: <1283369900.15386.0.camel@vanquo.pezone.net>
Message-ID: <alpine.DEB.2.00.1009020741380.2656@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>
User-Agent: Alpine 2.00 (DEB 1167 2008-08-23)
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8BIT


Dear Peter,

>> I'm suggesting uniqueness in the "information_schema", which can be
>> provided independently by some tweaking in the view construction, I
>> think, for instance by adding the oid of the constraint or maybe the
>> table_name.
>
> The view is defined by the SQL standard.

No. The result of the view (the definition of the expected attributes) is 
defined in the standard. But it is really a view on top of "pg_catalog".

You are right that some views of the information_schema are defined in the 
standard, but they deal with restrictions of other relations, say the 
privileges for the current user...

> We cannot change it.

Yes we can!  It, it is 100% postgresql:

  \d information_schema.referential_constraints
   View "information_schema.referential_constraints"
   ...
    FROM pg_namespace ncon
    JOIN pg_constraint con ON ncon.oid = con.connamespace
    JOIN pg_class c ON con.conrelid = c.oid

-- 
Fabien Coelho - CRI, Maths & Systèmes, MINES ParisTech
From pgsql-bugs-owner@postgresql.org  Thu Sep  2 07:41:38 2010
Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 16994632AF0
	for <pgsql-bugs-postgresql.org@mail.postgresql.org>; Thu,  2 Sep 2010 07:41:38 -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 81079-04 for <pgsql-bugs-postgresql.org@mail.postgresql.org>;
 Thu,  2 Sep 2010 10:41:36 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from wwwmaster.postgresql.org (wwwmaster.postgresql.org [217.196.146.204])
	by mail.postgresql.org (Postfix) with ESMTP id 598D2632A2B
	for <pgsql-bugs@postgresql.org>; Thu,  2 Sep 2010 07:41:37 -0300 (ADT)
Received: from wwwmaster.postgresql.org (wwwmaster.postgresql.org [217.196.146.204])
	by wwwmaster.postgresql.org (8.14.3/8.14.3) with ESMTP id o82AfXM0085948
	for <pgsql-bugs@postgresql.org>; Thu, 2 Sep 2010 10:41:33 GMT
	(envelope-from www@wwwmaster.postgresql.org)
Received: (from www@localhost)
	by wwwmaster.postgresql.org (8.14.3/8.14.3/Submit) id o82AfX1n085947;
	Thu, 2 Sep 2010 10:41:33 GMT
	(envelope-from www)
Date: Thu, 2 Sep 2010 10:41:33 GMT
Message-Id: <201009021041.o82AfX1n085947@wwwmaster.postgresql.org>
To: pgsql-bugs@postgresql.org
Subject: BUG #5636: extra "(" or missing ")"
From: "KOIZUMI Satoru" <koizumistr@minos.ocn.ne.jp>
Content-Type: text/plain; charset=utf-8
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 201009/8
X-Sequence-Number: 27972


The following bug has been logged online:

Bug reference:      5636
Logged by:          KOIZUMI Satoru
Email address:      koizumistr@minos.ocn.ne.jp
PostgreSQL version: 9.0RC1
Operating system:   MacOS X
Description:        extra "(" or missing ")"
Details: 

At 33.8.5. The decimal type of PostgreSQL 9.0RC1 Documentation, "(" is
before "by means".
But there is no ")".
| the decimal type can be created either on the stack
| or on the heap (by means of the functions
| PGTYPESdecimal_new() and PGTYPESdecimal_free().

Maybe "(" is not needed or ")" is needed after "PGTYPESdecimal_free()".