The Pg tests will fail if PostgreSQL is configured with European date
styles (ie D/M/Y instead of the american M/D/Y).  The easiest solution
is to set the PGDATESTYLE environment variable before you run the test
suite, and a simple doc patch should suffice to let users know about
this when running the test suite.

export PGDATESTYLE=MDY

(to recreate the test errors just set the PGDATESTYLE to DMY)

Cheers,

Cees
--- t/00-warning.t.orig	2005-12-28 10:45:17.000000000 -0500
+++ t/00-warning.t	2005-12-28 10:45:02.000000000 -0500
@@ -26,6 +26,10 @@
 ##     RDBO_PG_DSN      (@{[ nvl('RDBO_PG_DSN', 'dbi:Pg:dbname=test;host=localhost') ]})
 ##     RDBO_PG_USER     (@{[ nvl('RDBO_PG_USER', 'postgres') ]})
 ##     RDBO_PG_PASS     (@{[ nvl('RDBO_PG_PASS', '<none>') ]})
+##
+##   Note:  If Postgres is configured with European dates then you should set
+##          the PGDATESTYLE environment variable to MDY or you will see
+##          failures with the various date tests.
 ## 
 ## MySQL:
 ## 

Reply via email to