pgsql 的经纬度类型错误 返回
斌斌 发布于2026/1/28
```
[SugarColumn(ColumnName="geom")]
```
刚开始上面这样创建的不行,他默认写成了varchar(1) 类型,也设置了下面代码
NpgsqlConnection.GlobalTypeMapper.UseNetTopologySuite();
类型定义下面这样了。我数据库手动创建的,创建成功了。
[SugarColumn(IsNullable = true,ColumnName="geometry(Point)")]
public Geometry EvalLocation { get; set; }

Npgsql.PostgresException (0x80004005): 42703: column \"geometry(_point)\" does not exist\n\nPOSITION: 261\n at Npgsql.Internal.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|222_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)\n at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)\n at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)\n at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)\n at N
热忱回答(2)
-
fate sta VIP0
2026/1/29列名不要加()
0 回复 -
fate sta VIP0
2026/1/29column \"geometry(_point)\" does not exist 这个提示是不存在这一列。
0 回复