From: | "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> |
---|---|
To: | 'Amit Kapila' <amit(dot)kapila16(at)gmail(dot)com> |
Cc: | Peter Smith <smithpb2250(at)gmail(dot)com>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Önder Kalacı <onderkalaci(at)gmail(dot)com> |
Subject: | RE: doc: clarify the limitation for logical replication when REPILICA IDENTITY is FULL |
Date: | 2023-07-11 07:00:03 |
Message-ID: | TYAPR01MB58664DB6ECA653A6922B3FE3F531A@TYAPR01MB5866.jpnprd01.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Dear Amit,
> Isn't the same true for the hash operator class family as well?
True. I didn't write it on purpose because I didn't know the operator which is
operator class for BTree but not for Hash. But I agreed to clarify it.
> Can we
> slightly change the line as: "... the table includes an attribute
> whose datatype doesn't have an equality operator defined for it..".
Hmm, this suggestion is dubious for me. Regarding the point datatype, it has the
"same as" operator [1]. E.g., following SQL returns true.
```
postgres=# select point '(1, 1)' ~= point '(1, 1)';
?column?
----------
t
(1 row)
```
The reason why they cannot be supported by tuples_equal() is that lookup_type_cache()
only checks the operator classes for Btree and Hash. ~= does not defined as the class.
> Also, I find the proposed wording a bit odd, can we swap the sentence
> to say something like: "The UPDATE and DELETE operations cannot be
> replicated for the published tables that specifies REPLICA IDENTITY
> FULL but the table includes an attribute whose datatype doesn't have
> an equality operator defined for it on the subscriber."?
Swapped. But based on above reply, I did not completely use your suggestion.
[1]: https://www.postgresql.org/docs/devel/functions-geometry.html
Best Regards,
Hayato Kuroda
FUJITSU LIMITED
Attachment | Content-Type | Size |
---|---|---|
v3_add_description.patch | application/octet-stream | 1014 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Hayato Kuroda (Fujitsu) | 2023-07-11 07:04:29 | RE: doc: clarify the limitation for logical replication when REPILICA IDENTITY is FULL |
Previous Message | Andrey Lepikhov | 2023-07-11 06:44:39 | Re: Generating code for query jumbling through gen_node_support.pl |