[Maia-users] invalid input syntax for type timestamp: "4Y-2m-2d 2H:2M:2S"

[Robert LeBlanc]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Marc G. Fournier wrote:
> 
> Found it in my old emails and yes, it fixes it ...

Thanks, Marc.  I've written it up as ticket #461, and committed the fix
in changeset 1177.


> But, those are Linux-isms, and break portability ... this appears to be an OS 
> issue, not a PostgreSQL vs MySQL issue ...

True, which I suppose says something about how few Maia users seem to be
using anything other than Linux--or that those Linux-isms are more
widespread than that document suggests.

What distracted us I think was the fact that the small handful of people
reporting this bug happened to all be PostgreSQL users (the syntax error
was already reported by DBD::Pg), so we took that to be the common
thread.  Instead it looks like these people were also all non-Linux
users (perhaps all FreeBSD/OpenBSD users?) with system libraries that
included stricter versions of the strftime() function.

- --
Robert LeBlanc <rjl at renaissoft.com>
Renaissoft, Inc.
Maia Mailguard <http://www.maiamailguard.com/>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGJGXZGmqOER2NHewRAps2AJ98X16yZABIVCEa2ouzdKZzb+uOGgCgnt6Q
+N3g1M0+WUWX3QhAqJC+YaE=
=q926
-----END PGP SIGNATURE-----