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 |