fsprojects / SQLProvider

A general F# SQL database erasing type provider, supporting LINQ queries, schema exploration, individuals, CRUD operations and much more besides.
https://fsprojects.github.io/SQLProvider
Other
564 stars 144 forks source link

geometry column didn't work with postgress #695

Open aalcaina opened 3 years ago

aalcaina commented 3 years ago

Describe the bug Fails to map a table that contains a column with geometry when is used postgres provider

To Reproduce Steps to reproduce the behavior:

  1. Create a table with a column of the type geometry
  2. Try to query this table
  3. See error: The type provider 'FSharp.Data.Sql.SqlTypeProvider' reported an error: Could not get columns for public.table, the type geometry(Point,4326) is unknown to Npgsql type mapping