Why you need it?
ToG项目上第三方数据库管理方鉴于安全管理考虑,禁止使用pgsql的public模式,但是服务端的undo_log必须使用public模式下的自增序列
private static final String INSERT_UNDO_LOG_SQL = "INSERT INTO " + UNDO_LOG_TABLE_NAME +
" (" + ClientTableColumnsName.UNDO_LOG_ID + "," + ClientTableColumnsName.UNDO_LOG_BRANCH_XID + ", "
- ClientTableColumnsName.UNDO_LOG_XID + ", " + ClientTableColumnsName.UNDO_LOG_CONTEXT + ", "
- ClientTableColumnsName.UNDO_LOG_ROLLBACK_INFO + ", " + ClientTableColumnsName.UNDO_LOG_LOG_STATUS + ", "
- ClientTableColumnsName.UNDO_LOG_LOG_CREATED + ", " + ClientTableColumnsName.UNDO_LOG_LOG_MODIFIED + ")"
- "VALUES (nextval('undo_log_id_seq'), ?, ?, ?, ?, ?, now(), now())";
How it could be?
能否修改插入的自增序列和undo_log表一样支持配置或者插入的时候不从代码层面获取主键id
Other related information
Add any other context or screenshots about the feature request here.
2条答案
按热度按时间cgh8pdjw1#
Thank you for your feedback; we will evaluate this requirement.
eqoofvh92#
这个问题大概在哪个版本做相关更新