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

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



Diagnostic-Code: X-Postfix; host
maia.hub.org[200.46.204.183] said: 451 4.5.0
    Error in processing, id=80912-01, cached FAILED:
DBD::Pg::st execute
    failed: ERROR:  invalid input syntax for type timestamp:
"4Y-2m-2d
    2H:2M:2S" (in reply to end of DATA command)

I haven't traced the problem yet .. if someone has a ready
fixed, that would be 
great ...

Thanks ...

- ----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappyhub.org                              MSN .
scrappyhub.org
Yahoo . yscrappy               Skype: hub.org        ICQ .
7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (FreeBSD)

iD8DBQFGJDYi4QvfyHIvDvMRAvIPAJ42PTpq5LtKwEnJdYGEVsK7H+ZhpwCg
sY9k
5y/Ud9bY+xmoKPRi7+QI9N0=
=eL90
-----END PGP SIGNATURE-----

_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

On Mon, Apr 16, 2007 at 11:14:49PM -0700, Robert LeBlanc
wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> > But, those are Linux-isms, and break portability
... this appears to be an OS 
> > issue, not a PostgreSQL vs MySQL issue ...
> 
> 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.


Not strictly true, Robert.

It has only appeared on my Linux systems, since the only
OpenBSD box is
the firewall.


Brian


_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

On Tue, Apr 17, 2007 at 10:01:05AM -0400, Brian McCullough
wrote:
> On Mon, Apr 16, 2007 at 11:14:49PM -0700, Robert
LeBlanc wrote:
> > -----BEGIN PGP SIGNED MESSAGE-----
> > > But, those are Linux-isms, and break
portability ... this appears to be an OS 
> > > issue, not a PostgreSQL vs MySQL issue ...
> > 
> > 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.
> 
> 
> Not strictly true, Robert.
> 
> It has only appeared on my Linux systems, since the
only OpenBSD box is
> the firewall.


Maybe I should contradict myself.  I may not have seen this
issue, but
others related to the PostgreSQL code.  It has been so long
that I don't
remember precisely.


B-)


_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users