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:
##
