From: Tom Lane <tgl@sss.pgh.pa.us>
To: Christophe Courtois <christophe.courtois@dalibo.com>
cc: pgsql-docs@postgresql.org
Subject: Re: intagg.sgml: example wrongly named and does not compile
In-reply-to: <aa7cfd73-0d8d-596a-b684-39faa479afa5@dalibo.com>
References: <aa7cfd73-0d8d-596a-b684-39faa479afa5@dalibo.com>
Comments: In-reply-to Christophe Courtois <christophe.courtois@dalibo.com>
	message dated "Fri, 21 Apr 2017 17:12:58 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <15515.1492789516.1@sss.pgh.pa.us>
Date: Fri, 21 Apr 2017 11:45:16 -0400
Message-ID: <15516.1492789516@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

Christophe Courtois <christophe.courtois@dalibo.com> writes:
> I've found out that the example in intagg.sgml is wrongly named: the
> one-to-many table is a many-to-many.

Well, it'd depend on how it was used.  The example clearly intends that
it be one-to-many, and I'm not sure it still makes sense without that
restriction.  Maybe better to add a unique constraint on
one_to_many(left)?

> And my colleague Thibaut Madeleine has seen that the "CREATE TABLE
> right" and "CREATE TABLE left" examples cannot compile due to the
> reserved words.

Ouch.  Shows you how old this module is :-(

> I propose the attached patch to fix that.

Um, the attached file seems empty from here.

			regards, tom lane


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs