]> granicus.if.org Git - postgresql/commit
logical replication: fix OID type mapping mechanism
authorAlvaro Herrera <alvherre@alvh.no-ip.org>
Thu, 15 Mar 2018 00:34:26 +0000 (21:34 -0300)
committerAlvaro Herrera <alvherre@alvh.no-ip.org>
Thu, 15 Mar 2018 00:34:26 +0000 (21:34 -0300)
commit24c0a6c649768f428929e76dd7f5012ec9b93ce1
treec0b26eba9aaacb6169b3ecada3c19e5229c49d80
parent8df5a1c868cc28f89ac6221cff8e2b5c952d0eb6
logical replication: fix OID type mapping mechanism

The logical replication type map seems to have been misused by its only
caller -- it would try to use the remote OID as input for local type
routines, which unsurprisingly could result in bogus "cache lookup
failed for type XYZ" errors, or random other type names being picked up
if they happened to use the right OID.  Fix that, changing
Oid logicalrep_typmap_getid(Oid remoteid) to
char *logicalrep_typmap_gettypname(Oid remoteid)
which is more useful.  If the remote type is not part of the typmap,
this simply prints "unrecognized type" instead of choking trying to
figure out -- a pointless exercise (because the only input for that
comes from replication messages, which are not under the local node's
control) and dangerous to boot, when called from within an error context
callback.

Once that is done, it comes to light that the local OID in the typmap
entry was not being used for anything; the type/schema names are what we
need, so remove local type OID from that struct.

Once you do that, it becomes pointless to attach a callback to regular
syscache invalidation.  So remove that also.

Reported-by: Dang Minh Huong
Author: Masahiko Sawada
Reviewed-by: Álvaro Herrera, Petr Jelínek, Dang Minh Huong, Atsushi Torikoshi
Discussion: https://postgr.es/m/75DB81BEEA95B445AE6D576A0A5C9E936A6BE964@BPXM05GP.gisp.nec.co.jp
Discussion: https://postgr.es/m/75DB81BEEA95B445AE6D576A0A5C9E936A6C4B0A@BPXM05GP.gisp.nec.co.jp
src/backend/replication/logical/relation.c
src/backend/replication/logical/worker.c
src/include/replication/logicalproto.h
src/include/replication/logicalrelation.h