"Owner" param not working for PostgreSQL.
Nobody has claimed this yet.
Assessment
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Newbie friendliness
- 35/100
- Issue type
- Bug
- Clarity
- Mostly clear
- Activity status
- Stale
- Tech stack
- fsharp, postgresql
- Domain
- databases
Research direction
Start with the supplied SqlDataProvider reproduction using PostgreSQL and Owner="backoffice"; the issue provides no source file or test to locate first. Trace the type-provider entry point and existing PostgreSQL owner handling, then verify that the reproduction no longer reports FS3028 and resolves the requested owner.
Written by the indexing model from the issue text.
Description
Description
The Owner parameter for the connecting to PostgreSQL doesn't seem to work and results in an error.
Repro steps
Connect to a PostgreSQL database like so:
let [<Literal>] resPath = __SOURCE_DIRECTORY__ + @"..\..\packages\Npgsql.3.1.0\lib\net45\"
let [<Literal>] dbVendor = Common.DatabaseProviderTypes.POSTGRESQL
type dbCon =
SqlDataProvider<DatabaseVendor = dbVendor,
ConnectionString = dbConStr,
ResolutionPath = resPath,
UseOptionTypes = false,
Owner = "backoffice">
let db = dbCon.GetDataContext()
Actual behavior
I get the following error:
Error FS3028 The type provider 'FSharp.Data.Sql.SqlTypeProvider' reported an error: Expected provided type named 'SqlDataProvider,DatabaseVendor="2",ConnectionString="Host=xxx; Database=xxx; Username=xxx; Password=xxx; ApplicationName=xxx; MinPoolSize=4; MaxPoolSize=10; Timeout=60; CommandTimeout=600",ResolutionPath="C:\\Users\\xxx\\packages\\Npgsql.3.1.0\\lib\\net45\\",Owner="backoffice"' but provided type has 'Name' with value 'SqlDataProvider,DatabaseVendor="2",ConnectionString="Host=xxx; Database=xxx; Username=xxx; Password=xxx; ApplicationName=xxx; MinPoolSize=4; MaxPoolSize=10; Timeout=60; CommandTimeout=600",ResolutionPath="C:\\Users\\xxx\\packages\\Npgsql.3.1.0\\lib\\net45\",Owner=\"backoffice"' xxx C:\Users\xxx\Desktop\xxx\Library1.fs
- Dominant language
- F#
- Stars
- 627
- Forks
- 147
- Avg merge
- 2h 2m
- Merged PRs (30d)
- 1
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from fsprojects/SQLProvider
-
enhancement
Difficulty 3/5 1-2 days Newbie friendliness 55/100
fsprojects/SQLProvider#872 · 2 comments ·
-
Repo Assist? Openenhancement
Difficulty 5/5 Over a week Newbie friendliness 10/100
fsprojects/SQLProvider#870 · 1 comment ·
-
postgresql
Difficulty 4/5 3-5 days Newbie friendliness 58/100
fsprojects/SQLProvider#869 · 2 comments ·
-
documentation
Difficulty 2/5 1-3 hours Newbie friendliness 42/100
fsprojects/SQLProvider#868 · 2 comments ·
-
sql server
Difficulty 4/5 3-5 days Newbie friendliness 45/100
fsprojects/SQLProvider#851 · 1 comment ·
All issues in fsprojects/SQLProvider
Similar issues
-
[6.x]: "Cannot use object of type stdClass as array" loading Users index (regression of #19182) Open
Difficulty 1/5 Under an hour Newbie friendliness 90/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
community-scripts/ProxmoxVE#17396 · 1 comment ·
-
bug possible-duplicate
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
AOSSIE-Org/PictoPy#1553 · 4 comments ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
BasedHardware/omi#15274 · 3 comments ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 88/100