User defined data types in Logical Replication

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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers


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.

Attachment Content-Type Size
logicalrep_typmap.patch application/octet-stream 800 bytes


Browse pgsql-hackers by date

  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