>>>>> "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
|
