On Thu, Mar 20, 2014 at 09:25:59AM -0700, Andrew Fresh wrote: > On Tue, Mar 18, 2014 at 09:29:36AM +0100, Pierre-Emmanuel Andr'e wrote: > > Thanks for your report. Could you tell me what tests fail ? > > Everything is ok here. > > Sorry about the poor report, this hopefully is a better one. I followed > the instructions for setting up Postgres in > /usr/local/share/doc/pkg-readmes/postgresql-server-9.3.3 > > I do notice that my client_encoding and server_encoding are SQL_ASCII, > so that is likely the cause. > > > # su - _postgresql > $ mkdir /var/postgresql/data > $ initdb -D /var/postgresql/data -U postgres -A md5 -W > > susctl kern.seminfo.semmni=60 kern.seminfo.semmns=1024 > > > > ===> Regression tests for p5-DBD-Pg-3.0.0 > PGINITDB="/usr/local/bin/initdb" PERL_DL_NONLAZY=1 /usr/bin/perl > "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" > t/*.t > t/00_signature.t .... skipped: Set the environment variable TEST_SIGNATURE to > enable this test > t/00basic.t ......... ok > # > # DBI Version 1.622 > # DBD::Pg Version 3.0.0 > # Perl Version 5.16.3 > # OS openbsd > # PostgreSQL (compiled) 90303 > # PostgreSQL (target) 90303 > # PostgreSQL (reported) PostgreSQL 9.3.3 on powerpc-unknown-openbsd5.5, > compiled by cc (GCC) 4.2.1 20070719 , 32-bit > # Default port 5432 > # DBI_DSN dbi:Pg:db="template1" > # DBI_USER postgres > # Test schema dbd_pg_testschema > # array_nulls on > # backslash_quote safe_encoding > # client_encoding SQL_ASCII > # server_encoding SQL_ASCII > # standard_conforming_strings on > t/01connect.t ....... ok > t/01constants.t ..... ok > t/02attribs.t ....... ok > t/03dbmethod.t ...... ok > t/03smethod.t ....... ok > NOTICE: RAISE NOTICE FROM dbdpg_test_error_handler > WARNING: RAISE WARNING FROM dbdpg_test_error_handler > # Checking pg_st_split_statement. This may take a while... > t/04misc.t .......... ok > t/06bytea.t ......... ok > t/07copy.t .......... ok > t/08async.t ......... ok > t/09arrays.t ........ ok > t/12placeholders.t .. ok > t/20savepoints.t .... ok > > # Failed test 'Fetching UTF-8 string from the database returns proper > string' > # at t/30unicode.t line 37. > # got: 'Émilie du Châtelet' > # expected: '�milie du Ch�telet' > > # Failed test 'Fetching UTF-8 string from the database returns string with > UTF-8 flag on' > # at t/30unicode.t line 39. > > # Failed test 'Fetching ASCII string from the database returns string with > UTF-8 flag on' > # at t/30unicode.t line 64. > # Looks like you failed 3 tests of 12. > t/30unicode.t ....... > Dubious, test returned 3 (wstat 768, 0x300) > Failed 3/12 subtests > Removing test database directory > t/99cleanup.t ....... ok > > Test Summary Report > ------------------- > t/30unicode.t (Wstat: 768 Tests: 12 Failed: 3) > Failed tests: 2-3, 8 > Non-zero exit status: 3 > Files=16, Tests=1766, 55 wallclock secs ( 1.02 usr 0.19 sys + 14.61 cusr > 2.76 csys = 18.58 CPU) > Result: FAIL > Failed 1/16 test programs. 3/1766 subtests failed. >
I think your errors are related to your database's encoding. I always create my databases with -E UTF8. -- Pierre-Emmanuel André <pea at raveland.org> GPG key: 0xBB8D3F0E
