Re: [interchange] Use timestamp datatype for Postgres

Peter <[email protected]>
Newsgroups gmane.comp.web.interchange.users
Message-ID <[email protected]> 
On 26/01/17 11:12, Josh Lavin wrote:
> commit e287246f93151bc165fa8d431997eba5d5a1bb8f
> Author: Josh Lavin <[email protected]>
> 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.


Peter
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.