Postgresql net6 macos cannot infer types

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

Postgresql net6 macos cannot infer types #765

Closed jkone27 closed 1 year ago

jkone27 commented 2 years ago

seems i cannot see the types for the tables in postgres, i dont see compilation errors...

legezam commented 1 year ago

Have you specified the schemas that need to be inferred, using the Owner parameter?

type Db = SqlDataProvider<Common.DatabaseProviderTypes.POSTGRESQL, "Server=localhost;Database=mydb;UserName=postgres;Password=postgres", Owner="schema1,schema2,schema3">

jkone27 commented 1 year ago

yes it works! thanks a lot :) maybe there should be a default that when no Owner it's specified, it should still read all schemas and not only Public ??? I guess that would be easier for people to use, or maybe we should create a specific PGSQL doc, as it's one of the most used DBs nowadays i guess pp use it even more than mssql or mysql in company/enterprise sector

jkone27 commented 1 year ago

Close as workaround is found