Re: BUG #15724: Can't create foreign table as partition

From: Etsuro Fujita <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp>
To: Stepan Yankevych <stepya(at)ukr(dot)net>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15724: Can't create foreign table as partition
Date: 2019-04-01 06:01:50
Message-ID: 5CA1A94E.1070002@lab.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

(2019/03/29 23:21), Stepan Yankevych wrote:
> I think we need at least to mention it in the doc
> https://www.postgresql.org/docs/11/ddl-partitioning.html
>
>> > Partitions can also be foreign tables, although they have some
> limitations that normal tables do not; see CREATE FOREIGN TABLE
> <https://www.postgresql.org/docs/11/sql-createforeigntable.html>for more
> information
> For example
> Partitions can also be foreign tables*only in case main table is non
> indexed and doesn't contain PK,*although they have some limitations that
> normal tables do not; see CREATE FOREIGN TABLE
> <https://www.postgresql.org/docs/11/sql-createforeigntable.html>for more
> information

+1 for adding such notes, but I'm not sure if it's a good idea to put it
there because I think that would make the introductory documentation a
bit verbose. How about adding it to the reference pages of CREATE
FOREIGN TABLE and ALTER TABLE like the attached?

Best regards,
Etsuro Fujita

Attachment Content-Type Size
doc-foreign-partition.patch text/x-patch 1.4 KB

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Amit Langote 2019-04-01 06:23:15 Re: BUG #15724: Can't create foreign table as partition
Previous Message Etsuro Fujita 2019-04-01 05:35:28 Re: BUG #15724: Can't create foreign table as partition