MIME-Version: 1.0
References: <CACJufxHVxnyRYy67hiPePNCPwVBMzhTQ6FaL9_Te5On9udG=yg@mail.gmail.com>
 <Z2Sz7LU1akdewn5U@paquier.xyz> <CACJufxGvy6QNMwZ5xd=L31F+4Rr6aXCASeMFyLZS+TVssK5+vA@mail.gmail.com>
 <CACJufxGZgh4oNV_8TqBwRoL+WFB2n3EqN97aMcuEmjuG+qm0qw@mail.gmail.com>
In-Reply-To: <CACJufxGZgh4oNV_8TqBwRoL+WFB2n3EqN97aMcuEmjuG+qm0qw@mail.gmail.com>
From: jian he <jian.universality@gmail.com>
Date: Tue, 28 Jan 2025 10:48:25 +0800
Message-ID: <CACJufxHnyH4Zv+RtOABn8-1PjxkKch9R58dGhr+hCnV0LmNxSQ@mail.gmail.com>
Subject: Re: in BeginCopyTo make materialized view using COPY TO instead of
 COPY (query).
To: PostgreSQL-development <pgsql-hackers@postgresql.org>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Michael Paquier <michael@paquier.xyz>
Content-Type: multipart/mixed; boundary="0000000000003e89b2062cbb3c9c"
Archived-At: <https://www.postgresql.org/message-id/CACJufxHnyH4Zv%2BRtOABn8-1PjxkKch9R58dGhr%2BhCnV0LmNxSQ%40mail.gmail.com>
Precedence: bulk

--0000000000003e89b2062cbb3c9c
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Mon, Jan 6, 2025 at 5:34=E2=80=AFPM jian he <jian.universality@gmail.com=
> wrote:
>
> 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.

hi.
patch attached.
also cc to Tom,
since at that time, you are against the idea of ``COPY matview TO``.

--0000000000003e89b2062cbb3c9c
Content-Type: text/x-patch; charset="US-ASCII"; 
	name="v1-0001-COPY-materialized_view-TO.patch"
Content-Disposition: attachment; 
	filename="v1-0001-COPY-materialized_view-TO.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_m6fvn3cm0>
X-Attachment-Id: f_m6fvn3cm0

RnJvbSBhNjE4ZTcyYWUzM2I2Njg4ZTc1ZGJjZmQ1Njc0YjU1OGUxN2VlMjY5IE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBqaWFuIGhlIDxqaWFuLnVuaXZlcnNhbGl0eUBnbWFpbC5jb20+
CkRhdGU6IFR1ZSwgMjggSmFuIDIwMjUgMTA6NDY6MDMgKzA4MDAKU3ViamVjdDogW1BBVENIIHYx
IDEvMV0gQ09QWSBtYXRlcmlhbGl6ZWRfdmlldyBUTwoKY29udGV4dDogaHR0cHM6Ly9wb3N0Z3Iu
ZXMvbS84OTY3LjEzNTMxNjczMDFAc3NzLnBnaC5wYS51cwpjb250ZXh0OiBodHRwczovL3d3dy5w
b3N0Z3Jlc3FsLm9yZy9tZXNzYWdlLWlkL2ZsYXQvMjAxMjExMTYxNjI1NTguOTAxNTAlNDBnbXgu
Y29tCmRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vQ0FDSnVmeEhWeG55Ull5NjdoaVBl
UE5DUHdWQk16aFRRNkZhTDlfVGU1T245dWRHPXlnQG1haWwuZ21haWwuY29tCi0tLQogc3JjL2Jh
Y2tlbmQvY29tbWFuZHMvY29weXRvLmMgfCAxMiArKysrKysrLS0tLS0KIDEgZmlsZSBjaGFuZ2Vk
LCA3IGluc2VydGlvbnMoKyksIDUgZGVsZXRpb25zKC0pCgpkaWZmIC0tZ2l0IGEvc3JjL2JhY2tl
bmQvY29tbWFuZHMvY29weXRvLmMgYi9zcmMvYmFja2VuZC9jb21tYW5kcy9jb3B5dG8uYwppbmRl
eCA5OWNiMjNjYjM0Li4xMzUwNjAyM2Y4IDEwMDY0NAotLS0gYS9zcmMvYmFja2VuZC9jb21tYW5k
cy9jb3B5dG8uYworKysgYi9zcmMvYmFja2VuZC9jb21tYW5kcy9jb3B5dG8uYwpAQCAtMzgwLDEx
ICszODAsMTMgQEAgQmVnaW5Db3B5VG8oUGFyc2VTdGF0ZSAqcHN0YXRlLAogCQkJCQkJCVJlbGF0
aW9uR2V0UmVsYXRpb25OYW1lKHJlbCkpLAogCQkJCQkgZXJyaGludCgiVHJ5IHRoZSBDT1BZIChT
RUxFQ1QgLi4uKSBUTyB2YXJpYW50LiIpKSk7CiAJCWVsc2UgaWYgKHJlbC0+cmRfcmVsLT5yZWxr
aW5kID09IFJFTEtJTkRfTUFUVklFVykKLQkJCWVyZXBvcnQoRVJST1IsCi0JCQkJCShlcnJjb2Rl
KEVSUkNPREVfV1JPTkdfT0JKRUNUX1RZUEUpLAotCQkJCQkgZXJybXNnKCJjYW5ub3QgY29weSBm
cm9tIG1hdGVyaWFsaXplZCB2aWV3IFwiJXNcIiIsCi0JCQkJCQkJUmVsYXRpb25HZXRSZWxhdGlv
bk5hbWUocmVsKSksCi0JCQkJCSBlcnJoaW50KCJUcnkgdGhlIENPUFkgKFNFTEVDVCAuLi4pIFRP
IHZhcmlhbnQuIikpKTsKKwkJeworCQkJaWYgKCFSZWxhdGlvbklzUG9wdWxhdGVkKHJlbCkpCisJ
CQkJZXJlcG9ydChFUlJPUiwKKwkJCQkJCWVycmNvZGUoRVJSQ09ERV9GRUFUVVJFX05PVF9TVVBQ
T1JURUQpLAorCQkJCQkJZXJybXNnKCJjYW5ub3QgY29weSBmcm9tIG1hdGVyaWFsaXplZCB2aWV3
IHdoZW4gdGhlIG1hdGVyaWFsaXplZCB2aWV3IGlzIG5vdCBwb3B1bGF0ZWQiKSwKKwkJCQkJCWVy
cmhpbnQoIlVzZSB0aGUgUkVGUkVTSCBNQVRFUklBTElaRUQgVklFVyBjb21tYW5kIHBvcHVsYXRl
IHRoZSBtYXRlcmlhbGl6ZWQgdmlldyBmaXJzdC4iKSk7CisJCX0KIAkJZWxzZSBpZiAocmVsLT5y
ZF9yZWwtPnJlbGtpbmQgPT0gUkVMS0lORF9GT1JFSUdOX1RBQkxFKQogCQkJZXJlcG9ydChFUlJP
UiwKIAkJCQkJKGVycmNvZGUoRVJSQ09ERV9XUk9OR19PQkpFQ1RfVFlQRSksCi0tIAoyLjM0LjEK
Cg==
--0000000000003e89b2062cbb3c9c--