incubator-seata icon indicating copy to clipboard operation
incubator-seata copied to clipboard

undo_log表自增序列

Open Hsxextreme opened this issue 10 months ago • 2 comments

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.

Hsxextreme avatar Apr 15 '24 08:04 Hsxextreme

Thank you for your feedback; we will evaluate this requirement.

slievrly avatar Apr 23 '24 10:04 slievrly

这个问题大概在哪个版本做相关更新

Hsxextreme avatar Apr 29 '24 08:04 Hsxextreme