>>>>> "Johannes" == Johannes Waldmann <[email protected]> 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
_______________________________________________
Haskell-Cafe mailing list
[email protected]
http://www.haskell.org/mailman/listinfo/haskell-cafe
