[ic] [interchange] Use timestamp datatype for Postgres
peter at pajamian.dhs.org
Thu Jan 26 02:12:46 UTC 2017
On 26/01/17 11:12, Josh Lavin wrote:
> commit e287246f93151bc165fa8d431997eba5d5a1bb8f
> Author: Josh Lavin <digory at cpan.org>
> Date: Wed Jan 25 14:12:30 2017 -0800
> Use timestamp datatype for Postgres
> -Database userdb COLUMN_DEF "mod_time=varchar(20)"
> +Database userdb COLUMN_DEF "mod_time=timestamp"
> -Database userdb PREFER_NULL usernick
> +Database userdb PREFER_NULL usernick mod_time
Be careful with this. I recall having problems with timestamp in the
past where Interchange would try to truncate the input string based on
the bitwidth of the data type and it would cause the whole thing to fail.
More information about the interchange-users