Re: copy.sgml and partitioned tables

Поиск
Список
Период
Сортировка
Искать
От
Bruce Momjian
Тема
Re: copy.sgml and partitioned tables
Дата
Msg-id
20201216002059.GD14807@momjian.us
Ответ на
Список
Дерево обсуждения
copy.sgml and partitioned tables Justin Pryzby <pryzby@telsasoft.com>
Re: copy.sgml and partitioned tables Bruce Momjian <bruce@momjian.us>
On Thu, Dec  3, 2020 at 03:17:23PM -0600, Justin Pryzby wrote:
> https://www.postgresql.org/docs/current/sql-copy.html
> |. COPY FROM can be used with plain, foreign, or partitioned tables or with views that have INSTEAD OF INSERT triggers.
> |. COPY only deals with the specific table named; IT DOES NOT COPY DATA TO OR FROM CHILD TABLES. ...
> 
> That language in commit 854b5eb51 was never updated since partitioning was
> added, so I propose this.
> 
> I'm not sure, but maybe it should still say that "COPY TO does not copy data to
> child tables of inheritance hierarchies."

I reworded it slightly, attached, and applied it back to PG 10, where we
added the partition syntax.

-- 
  Bruce Momjian          https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

  The usefulness of a cup is in its emptiness, Bruce Lee

В списке pgsql-hackers по дате отправления
От: Bruce Momjian
Дата:
От: Michael Paquier
Дата:
Сообщение: Re: REINDEX backend filtering
FAQ