在操作一个的远程postpreSQL数据库时,查询数据报出的权限问题 返回
socall 发布于2026/2/6
(1)navicat的连接

(2)navicat能查询ss_tb_yl_mz_medical_record表中数据

(3)代码中的连接数据库
var dbctx = new SqlSugarClient(new ConnectionConfig
{
ConfigId = "qzj_interface",
DbType = SqlSugar.DbType.PostgreSQL,
ConnectionString = "Server=188.3.1.122;Port=6566;User Id=qzj_interface;Password=qzj_interface;Database=qzj_ckdb;SearchPath=qzj_interface;",
IsAutoCloseConnection = true,
MoreSettings = new ConnMoreSettings
{
IsNoReadXmlDescription = true,
IsAutoUpdateQueryFilter = false,
IsWithNoLockQuery = false,
PgSqlIsAutoToLower = false,
DisableNvarchar = true
}
});
(4)查询数据时报错,提示pg_proc权限不够
var dt = dbctx.Ado.GetDataTable("select * from qzj_interface.ss_tb_yl_mz_medical_record limit 100");
listBox1.Items.Add($"行数:{dt.Rows};列数{dt.Columns}");

(5)版本.net48+Npgsql4.1.14+sqlsugar5.1.4.200
请问是什么原因呢,如何修改?
热忱回答(2)
-
socall VIP0
2026/2/6补充PostgreSQL的版本是
PostgreSQL 11.5, compiled by Visual C++ build 1914, 64-bit0 回复 -
fate sta VIP0
2026/2/6new NpgSqlConnection(字符串).Open()
这行代码能跑,ORM就能跑。 用原生测试
0 回复