Re: [BUGS] BUG #14759: insert into foreign data partitions fail
| От | David G. Johnston |
|---|---|
| Тема | Re: [BUGS] BUG #14759: insert into foreign data partitions fail |
| Дата | |
| Msg-id | CAKFQuwbDLnwd7U2v6rmTP_W3GwsG16SNWRa570XXM5dMo0qpLA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: [BUGS] BUG #14759: insert into foreign data partitions fail (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>) |
| Ответы |
Re: [BUGS] BUG #14759: insert into foreign data partitions fail
|
| Список | pgsql-bugs |
On 2017/07/25 6:28, mtuncer@gmail.com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 14759
> Logged by: Murat Tuncer
> Email address: mtuncer@gmail.com
> PostgreSQL version: 10beta2
> Operating system: Mac 10.12.6
> Description:
>
> I got
>
> ERROR: cannot route inserted tuples to a foreign table
Inserting tuples into a partitioned table that will route to one of its
foreign table partitions is unsupported in PG 10. The limitation is
mentioned on the following page:
https://www.postgresql.org/docs/devel/static/ddl- partitioning.html
It would be nice to also note this limitation here:
Also, the ddl-partitioning.html page has a section "5.10.2.3. Limitations". Moving (or duplicating maybe) the existing comment on that page in that section would make finding out about this limitation a bit easier.
I'd probably move (and rework) the "limitation wording" to the limitation sections and do something like the following in the main section.
"Foreign Tables can be added to a partitioning structure but inserts to the partitioned table will fail if they are routed to a foreign table partition. Direct writes to the foreign table, and partition reads, work normally."
I'm curious what the other limitations are...
David J.
В списке pgsql-bugs по дате отправления: