Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query). - Mailing list pgsql-hackers

From jian he
Subject Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query).
Date
Msg-id CACJufxGZgh4oNV_8TqBwRoL+WFB2n3EqN97aMcuEmjuG+qm0qw@mail.gmail.com
Whole thread Raw
In response to Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query).  (jian he <jian.universality@gmail.com>)
List pgsql-hackers
hi.

about this issue,
last email in 2012 (https://postgr.es/m/8967.1353167301@sss.pgh.pa.us)
"""
Even if it happens to be trivial in the current patch, it's an added
functional requirement that we might later regret having cavalierly
signed up for. And, as noted upthread, relations that support only
one direction of COPY don't exist at the moment; that would be adding
an asymmetry that we might later regret, too.

regards, tom lane
"""

but now we have numerous COPY options that work solely in a single
direction of COPY.
I think now we can make some kind of relation (pg_class.relkind) that
only works in one direction of COPY.



pgsql-hackers by date:

Previous
From: wenhui qiu
Date:
Subject: Re: [RFC] Lock-free XLog Reservation from WAL
Next
From: Julien Rouhaud
Date:
Subject: Re: RFC: Allow EXPLAIN to Output Page Fault Information