Re: [Haskell-cafe] Re: programmatic DB interface?

...

...

...

...

"Johannes" == Johannes Waldmann writes:

>> That is exactly the problem - it is wrong for CalendarT. Johannes> what do you mean by "it" ... what package should be fixed Johannes> (old-locale, haskelldb-hdbc-postgreqsl, ...)? Because Johannes> obviously something seems broken here. "It" is the use of unzoned times. I sent the following patch to the haskelldb list several months ago. But there has not been a new release since then. Colin> It is just the code to generate the SQL for CREATE TABLE is Colin> presumably faulty. For CalendarTimeT columns it should Colin> generate a time of Colin> timestamp with time zone Colin> as CalendarTime is a zoned timestamp. here's my patch: --- Default.hs~ 2009-02-13 23:06:25.000000000 +0000 +++ Default.hs 2009-10-01 16:43:34.000000000 +0100 @@ -92,7 +92,7 @@ IntegerT -> SqlType "bigint" DoubleT -> SqlType "double precision" BoolT -> SqlType "bit" - CalendarTimeT -> SqlType "timestamp" + CalendarTimeT -> SqlType "timestamp with time zone" BStrT a -> SqlType1 "varchar" a -- Colin Adams Preston Lancashire