PostgisGeometry error after upgrading to 0.1.35 beta

[sandeepc24]

I am getting following error after upgrading to 0.1.35 beta. I am on dotnet 2.1.4.

 error FS3021: Unexpected exception from provided type 'FSharp.Data.Npgsql.NpgsqlConnection,Connection="DATABASE_URL_PG",Config="C:\\.../appsettings.json"+Commands+CreateCommand,CommandText"select * from addresses where id  AddressId",ResultType"2"+Table' member 'GetMethods': The type provider 'FSharp.Data.Npgsql.NpgsqlProviders' reported an error: The design-time type 'Npgsql.LegacyPostgis.PostgisGeometry' utilized by a type provider was not found in the target reference assembly set...

[dmitry-a-morozov]

Thanks for reporting the issue. It's bit hard to test. Try https://www.nuget.org/packages/FSharp.Data.Npgsql/0.1.36-beta

[sandeepc24]

Thanks for fixing it Dmitry, I have an urgent issue to fix before I can test this, I'll let you know once I test this version.

[sandeepc24]

Apologies for the delayed response. It is still not working and I am getting same error.

[dmitry-a-morozov]

Make sure you reference Npgsql.LegacyPostgis package in consumption project.

[sandeepc24]

It is working fine after adding this package. Thanks a lot Dmitry.

[dmitry-a-morozov]

Great. Just curios how did you end up missing Npgsql.LegacyPostgis package? Because it's listed as explicit dependency https://www.nuget.org/packages/FSharp.Data.Npgsql/0.1.36-beta

Also, going forward some re-design will required to support choice between

• NetTopologySuite
• GeoJSON
• Legacy PostGIS

[sandeepc24]

Npgsql.LegacyPostgis was never installed and it didn't install when I upgraded to 0.1.36.

[dmitry-a-morozov]

It's strange because Npgsql.LegacyPostgis is transitive dependency and it has to be there

[sandeepc24]

My project compiles after adding package Npgsql.LegacyPostgis to my paket.reference but I am getting following error

An unhandled exception has occurred while executing the request.
  System.InvalidOperationException: Expected column "geom" of type "Npgsql.LegacyPostgis.PostgisGeometry" at position 6 (0-based indexing) but received column "geom" of type "System.String".
     at FSharp.Data.Npgsql.ISqlCommand Implementation.VerifyOutputColumns(NpgsqlDataReader cursor, DataColumn[] expectedColumns)

[dmitry-a-morozov]

You need to add type mappers https://github.com/demetrixbio/FSharp.Data.Npgsql/blob/master/tests/NpgsqlCmdTests.fs#L19

I realized that library should do it automatically when connection string passed into command ctor.

[sandeepc24]

Do you monitor FSharp slack or FSharp forums?

[dmitry-a-morozov]

no

[sandeepc24]

Thanks that fixed it.

[sandeepc24]

oops that fixed compilation only, I am still getting

 Expected column "geom" of type "Npgsql.LegacyPostgis.PostgisGeometry" at position 6 (0-based indexing) but received column "geom" of type "System.String".
     at FSharp.Data.Npgsql.ISqlCommand Implementation.VerifyOutputColumns(NpgsqlDataReader cursor, DataColumn[] expectedColumns)

[dmitry-a-morozov]

Do you pass connection string or connection instance to a command that fails?

[sandeepc24]

connection string

[dmitry-a-morozov]

I need to post a fix to make it work.

[sandeepc24]

ok, I'll wait for your fix. Thanks.

[dmitry-a-morozov]

Try https://www.nuget.org/packages/FSharp.Data.Npgsql/0.1.38-beta

[sandeepc24]

Thanks, that fixed the issue.