[ic] [interchange] Use timestamp datatype for Postgres

Peter 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 mailing list