| From: | Huong Dangminh <huo-dangminh(at)ys(dot)jp(dot)nec(dot)com> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Cc: | Hiroshi Yanagisawa <hir-yanagisawa(at)ut(dot)jp(dot)nec(dot)com> |
| Subject: | User defined data types in Logical Replication |
| Date: | 2017-11-10 00:41:26 |
| Message-ID: | 75DB81BEEA95B445AE6D576A0A5C9E936A6BE964@BPXM05GP.gisp.nec.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
We are getting the bellow error while trying use Logical Replication
with user defined data types in a C program (when call elog function).
ERROR: XX000: cache lookup failed for type XXXXX
# XXXXX is remote type's oid
It occurs in worker.c:slot_store_error_callback function when remotetypoid not exist in local pg_type.
I have tried to write a patch (attached).
I think it is not kindly to change typename to the OID's one,
But I could not find the easy way to get typename from OID in the remote host.
---
Thanks and best regards,
Dang Minh Huong
NEC Solution Innovators, Ltd.
http://www.nec-solutioninnovators.co.jp/en/
| Attachment | Content-Type | Size |
|---|---|---|
| logicalrep_typmap.patch | application/octet-stream | 800 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Geoghegan | 2017-11-10 00:45:07 | Re: [COMMITTERS] pgsql: Fix freezing of a dead HOT-updated tuple |
| Previous Message | Amit Langote | 2017-11-10 00:34:57 | Re: path toward faster partition pruning |