Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

使用pg数据库存在一些数据问题 #35

Open
JianxinORG76LBITCVECF6L opened this issue May 1, 2024 · 0 comments
Open

使用pg数据库存在一些数据问题 #35

JianxinORG76LBITCVECF6L opened this issue May 1, 2024 · 0 comments

Comments

@JianxinORG76LBITCVECF6L
Copy link

开发者你们好,我在Windows server服务器上安装时,在导入pg数据库的过程中出现了问题。
初始化表的过程是可以正常工作的,但是导入初始值的过程是有问题的。

在为表“menu”导入初始值的时候,pg数据库会默认拒绝定义id值(自增主键),需要使用“overriding system value”来进行强制导入

在为表“rolemenu”导入初始值的时候,报错
错误: 类型json的输入语法无效
LINE 1: ... '2023-08-30 15:36:15', '2023-10-11 10:11:58', 1, '["save"...
^
DETAIL: 令牌 "" 无效.
CONTEXT: JSON数据, 行 1: [...
移除所有反斜杠""后正常。

除此之外在权限设置页面进行任何操作的时候,均提示失败,可能与上述反斜杠的报错有关

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant