postgresql表名大写，binlog_loader报错

[georgeyz]

[binlog_loader_main] applyid binlog from 4
[loader] table PUB_COM_INFO index column com_uni_code
[loader] table STK_BASIC_INFO index column stk_uni_code
[loader] task 1 step 1 table public.PUB_COM_INFO load PUB_COM_INFO_old_key to remote 4 row complete, cost 0.613 ms
[loader]task merge oldkey faild: ERROR: relation "public.pub_com_info" does not exist
LINE 1: delete from public.PUB_COM_INFO where com_uni_code in (selec...

[loader] task 1 run faild
[binlog_loader_main] thread exit, proc exit

---

当把loader_table_list.txt中表名加上“”后也会报错
[binlog_loader_main] applyid binlog from 4
[loader] can not get table "STK_BASIC_INFO" index column name
[loader] can not get table "PUB_COM_INFO" index column name
[binlog_loader_main] thread exit, proc exit

因为postgresql是区分大小写，能否将查询中的表名加上“”，防止出现大写时报错

[wjzeng]

感谢反馈，这确实是一个问题，我随后解决。

[xhj0904]

你好，请问这个问题如何解决呢，我也遇到同样的问题