pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Stephen Frost <sfrost@snowman.net>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Noah Misch <noah@leadboat.com>
Cc: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Cc: Pg Hackers <pgsql-hackers@postgresql.org>
Subject: Re: pg_dump emits ALTER TABLE ONLY partitioned_table
Date: Mon, 10 Apr 2017 10:30:43 -0400
Message-ID: <11853.1491834643@sss.pgh.pa.us> (raw)
In-Reply-To: <20170410141251.GJ9812@tamriel.snowman.net>
References: <7682253a-6f79-6a92-00aa-267c4c412870@lab.ntt.co.jp>
	<CA+TgmoYAWqUukz-Q6GOnv=D82bokRbsohYrRj_gJYkwBBz79-Q@mail.gmail.com>
	<9599c3b3-87d4-39d1-1f75-d205a726b863@lab.ntt.co.jp>
	<CA+TgmoYpVps0dH_Nj7At5yonKJZ-Qzezq4Z_3ZnYLPwZgGgBZg@mail.gmail.com>
	<9c6a9a7d-684f-bb8b-b972-ee20445a9e6d@lab.ntt.co.jp>
	<20170409235057.GA2842536@tornado.leadboat.com>
	<CA+Tgmoba3SDoSyPJ5b4-n1S8fd+_vhKmKBpfwUenH_+=PUgQDg@mail.gmail.com>
	<7227.1491790247@sss.pgh.pa.us>
	<20170410141251.GJ9812@tamriel.snowman.net>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>

Stephen Frost <sfrost@snowman.net> writes:
> * Tom Lane (tgl@sss.pgh.pa.us) wrote:
>> While I admit that I've not been paying close attention to the whole
>> table partitioning business, I wonder whether we have any clearly written
>> down specification about (a) how much partition member tables are allowed
>> to deviate schema-wise from their parent, and (b) how DDL semantics on
>> partitioned tables differ from DDL semantics for traditional inheritance.

> Right.  I thought I had understood that partition child tables really
> can't deviate from the parent table in terms of columns or constraints
> but might be allowed to differ with regard to indexes (?).

Well, there's an awful lot of logic that's only of interest if partition
children can have different column orders from their parents.  I really
fail to understand what's the point of allowing that.

			regards, tom lane


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



view thread (64+ messages)  latest in thread

Message-ID: <11853.1491834643@sss.pgh.pa.us>
Permalink:  ../11853.1491834643@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/11853.1491834643@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: tgl@sss.pgh.pa.us, sfrost@snowman.net, robertmhaas@gmail.com, noah@leadboat.com, Langote_Amit_f8@lab.ntt.co.jp
  Subject: Re: pg_dump emits ALTER TABLE ONLY partitioned_table
  In-Reply-To: <11853.1491834643@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox