Postgres Type Provider can't resolve columns

[trondd]

Hi. I am not sure if the title is entirely correct, but it describes the problem I am seeing. I am doing a little experiment with the Postgres type provider on a small test database running locally on my machine, but somehow the columns does not resolve. The database connection is working because the table names does auto-complete, but if I try to access a column in a record like this

    let b = query { for record in cnx.``[public].[myTable]`` do
                    select record.myField
            } |> Seq.toList

I get the following error:

****/Test.fs(34,34): Error FS3021: Unexpected exception from provided type 'FSharp.Data.Sql.SqlDataProvider,ConnectionString="Server=localhost;Port=5432;Database=****;user=****;",DatabaseVendor="2",ResolutionPath="****/packages/Npgsql.2.2.2/lib/net35"+dataContext+[public].[type]Entity' member 'GetMethods': The type provider 'FSharp.Data.Sql.SqlTypeProvider' reported an error: The given key was not present in the dictionary. (FS3021) (Foobar)

Any ideas?

• FSharp.Data.TypeProviders 4.3.0.0
• SQLProvider 0.0.9-alpha from NuGet
• Mono 3.10.0 ((detached/e204655)

[trondd]

I think I found the problem: varchar() strings are not supported by the type mapper.

[colinbull]

I'll have a look at this, just to be clear, Is the type of this reported as varchar or character varying? I'm no postgres expert but it seems that these can be reported in the provider as different types, but they are equivalent in the database.

[trondd]

The type is reported as character varying.

Den 14. nov. 2014 kl. 21:32 skrev Colin notifications@github.com:

I'll have a look at this, just to be clear? Is the type of this reported as varchar or character varying?

—
Reply to this email directly or view it on GitHub.

[kunjee17]

@trondd I guess it is working for me. With .net 4.5. Just FYI. As I have also faced same issue.

CREATE TABLE users (
Id SERIAL PRIMARY KEY,
username varchar(50) not null,
password varchar(50) not null
);

This is type you are trying?

[trondd]

@kunjee17 yes it is.

[colinbull]

Hi,

Just so you know, I'm not ignoring this, I'm just without internet at home
at the moment due to a house move, I can only access things via work
internet. As soon as I'm back connected I'll have a look at this. Just so I
know this works on .NET 4.5.x but not on mono? Correct?

Cheers

Colin

On Wed, Nov 26, 2014 at 11:13 AM, Trond Danielsen notifications@github.com
wrote:

Reopened #104 #104.

—
Reply to this email directly or view it on GitHub
#104 (comment).

[trondd]

Hi. I haven't tested this with .NET 4.5, only 4.0.

[colinbull]

I believe this is fixed now on development V1. See https://github.com/fsprojects/SQLProvider/blob/master/src/SQLProvider/Providers.Postgresql.fs#L129

Closing for now..