demetrixbio / FSharp.Data.Npgsql

F# type providers to support statically typed access to input parameters and result set of sql statement in idiomatic F# way. Data modifications via statically typed tables.
Apache License 2.0
128 stars 15 forks source link

BUG: interval updates corrupting #77

Closed melanore closed 4 years ago

melanore commented 4 years ago

Closes https://github.com/demetrixbio/FSharp.Data.Npgsql/issues/76

Bug was caused by incorrect check for user defined types in InformationSchema.ToDataColumnExpr method, that is used to provide data column information. Enums / other UDT always have namespace other then pg_catalog, however query inside getDbSchemaLookups function was not retrieving correct column type namespace, causing DataTable api to treat some columns as 'unknown'. image