pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
To: Stepan Yankevych <stepya@ukr.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #15724: Can't create foreign table as partition
Date: Mon, 01 Apr 2019 15:40:49 +0900
Message-ID: <5CA1B271.4040409@lab.ntt.co.jp> (raw)
In-Reply-To: <1553876622.668408412.24u6zti5@frv53.fwdcdn.com>
References: <20190329135519.GA21373@alvherre.pgsql>
	<21389.1553868091@sss.pgh.pa.us>
	<1553876622.668408412.24u6zti5@frv53.fwdcdn.com>

(2019/03/30 1:25), Stepan Yankevych wrote:
>>>  I'm not sure that just forcing the case to be a no-op is wise.
>>>  What if the index is supposed to be UNIQUE?
>
> Anyway it would be better to have no-op in 11.3 than having it not working.
>
> We just can put comment in the doc like.
>
> Foreign Server should take care about indexing foreign table as partition.

That might be OK, but before doing that, we would need to support eg, 
unique constraints on foreign tables, so this seems more like a feature 
than a fix to me.

Best regards,
Etsuro Fujita






view thread (23+ messages)  latest in thread

Message-ID: <5CA1B271.4040409@lab.ntt.co.jp>
Permalink:  ../5CA1B271.4040409@lab.ntt.co.jp/
Also on:    postgresql.org/message-id/5CA1B271.4040409@lab.ntt.co.jp

 · 

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-bugs@postgresql.org
  Cc: fujita.etsuro@lab.ntt.co.jp, stepya@ukr.net, tgl@sss.pgh.pa.us, alvherre@2ndquadrant.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: BUG #15724: Can't create foreign table as partition
  In-Reply-To: <5CA1B271.4040409@lab.ntt.co.jp>

* 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