google-code-export / dblinq2007

Automatically exported from code.google.com/p/dblinq2007
Other
0 stars 0 forks source link

DbMetal does not recognise PostgreSQL user defined types #271

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Run DbMetal against a PostgreSQL database with user defined types
2. Error shown: 
DbMetal: Don't know how to convert the SQL type 'user-defined' into a managed 
type.
Parameter name: dataType

What is the expected output? What do you see instead?
Expected DbMetal to run successfully.
Output:
>>> Reading schema from PostgreSQL database
DbMetal: Don't know how to convert the SQL type 'user-defined' into a managed 
type.
Parameter name: dataType

What version of the product are you using? On what operating system?
DbLinq Database mapping generator 2008 version 0.20
on Fedora Linux 12

Please provide any additional information below.
PostgreSQL 8.4.4

Original issue reported on code.google.com by grau.f...@gmail.com on 9 Aug 2010 at 10:49

GoogleCodeExporter commented 9 years ago
Issue 272 has been merged into this issue.

Original comment by jonmpr...@gmail.com on 9 Aug 2010 at 1:33

GoogleCodeExporter commented 9 years ago
The problem here is effectively the same as that in issue 238: DbLinq shouldn't 
be in the business of doing SQL type to managed type mappings, as this 
information can be obtained via ADO.NET's DataTypes schema (and if that doesn't 
provide the information needed, then we're SOL, but that's no better than what 
happens now, as we're still SOL).

Thus, the fix is to make PgsqlSchemaLoader a subclass of DbSchemaLoader (which 
uses the DataTypes schema).

Original comment by jonmpr...@gmail.com on 9 Aug 2010 at 1:37

GoogleCodeExporter commented 9 years ago
Anybody working on this or has a solution already?

Original comment by Marco.Fr...@googlemail.com on 25 Jan 2011 at 4:03

GoogleCodeExporter commented 9 years ago
At least a trace of the name/location/type of the entity on which conversion 
failed would be helpful.  Working on this now.

Original comment by LiamBo...@gmail.com on 22 Jun 2011 at 11:59