X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id CC713D1C4EB
	for <pgsql-docs-postgresql.org@localhost.postgresql.org>;
	Mon, 22 Mar 2004 16:21:15 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 72309-08
	for <pgsql-docs-postgresql.org@localhost.postgresql.org>;
	Mon, 22 Mar 2004 12:21:23 -0400 (AST)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by svr1.postgresql.org (Postfix) with ESMTP id 7AE07D1D153
	for <pgsql-docs@postgresql.org>; Mon, 22 Mar 2004 12:21:13 -0400 (AST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i2MGLNXn001344;
	Mon, 22 Mar 2004 11:21:24 -0500 (EST)
To: Patrick Samson <p_samson@yahoo.com>
Cc: pgsql-docs@postgresql.org
Subject: Re: CREATE TABLE LIKE 
In-reply-to: <20040315083218.60754.qmail@web60305.mail.yahoo.com> 
References: <20040315083218.60754.qmail@web60305.mail.yahoo.com>
Comments: In-reply-to Patrick Samson <p_samson@yahoo.com>
	message dated "Mon, 15 Mar 2004 00:32:18 -0800"
Date: Mon, 22 Mar 2004 11:21:23 -0500
Message-ID: <1343.1079972483@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200403/49
X-Sequence-Number: 2339

Patrick Samson <p_samson@yahoo.com> writes:
> Unlike INHERITS, the new table and inherited table ...
>                                              ^^^^^
> I don't understand this sentence (but english is not
> my language).

It doesn't seem to have been the language of the author of that paragraph,
either :-(

I've cleaned this up to read

      Unlike <literal>INHERITS</literal>, the new table and original table
      are completely decoupled after creation is complete.  Changes to the
      original table will not be applied to the new table, and it is not
      possible to include data of the new table in scans of the original
      table.

and added this to the description of INHERITS, just below:

     <para>
      Use of <literal>INHERITS</> creates a persistent relationship
      between the new child table and its parent table(s).  Schema
      modifications to the parent(s) normally propagate to children
      as well, and by default the data of the child table is included in
      scans of the parent(s).
     </para>

			regards, tom lane