Re: [Haskelldb-users] Problem using CalendarTimeT column

[Colin P. A. <co...@co...>]

>>>>> "Colin" == Colin Paul Adams <co...@co...> writes:

    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.

    Colin> I have just checked with sqlite3 that a create table
    Colin> statement like this works. Unfortunately I can't use the
    Colin> same bodge that I used with postgresql, as ALTER TABLE in
    Colin> sqlite3 does not support changing column types. But I'd
    Colin> like to experiment with changing the code generation for
    Colin> this column type. Can you tell me which module this occurs
    Colin> in?

Actually, I found it myself easily enough - it is in Sql/Defaults.hs.

So I made the change and reverted to sqlite3. The table gets created
OK, but the time zone does not appear in the data. So I get the same
error as before. Must be a limitation of sqlite3.

Still I could go back to using postgresql, without a bodge with this change.
-- 
Colin Adams
Preston Lancashire