[Mono-list] SqlMetal to PostgreSQL

[Jonathan Pryor]

On Sun, 2010-02-07 at 19:45 -0500, Costantino Pipero wrote:
> Having failed to use sqlmetal for MySql, I ported my data to Postgres.
>  
> Now, this time the sqlmetal command finds the right provider, but it
> chokes on a data type with the error:
>  
> sqlmetal failed:System.ArgumentException: Don't know how to convert
> the SQL type 'timestamp with time zone' into a managed type.

Support for this type was added in DbLinq r1300...which hasn't been
integrated with Mono svn yet.

You can manually fix this by editing 
mcs/class/System.Data.Linq/src/DbLinq/Vendor/Implementation/SchemaLoader.TypeMapping.cs and adding the following after `case "timestamp"` (around line 193):

            case "timestamp":
            case "timestamp without time zone":
            case "timestamp with time zone":

Recompile and install the new System.Data.Linq and it should work.

 - Jon