Bug #69624 for DBIx-Class-ResultSet-RecursiveUpdate: PostgreSQL test failures

Trying to install DBIx::Class::ResultSet::RecursiveUpdate, with DBICTEST_PG_{DSN,USER} set and pointing to a PostgreSQL 9.1beta3 server, I get the following failures. Fetching http://search.cpan.org/CPAN/authors/id/J/JJ/JJNAPIORK/DBIx-Class-ResultSet-RecursiveUpdate-0.24.tar.gz -> OK Unpacking DBIx-Class-ResultSet-RecursiveUpdate-0.24.tar.gz Entering DBIx-Class-ResultSet-RecursiveUpdate-0.24 Checking configure dependencies from META.yml Checking if you have ExtUtils::MakeMaker 6.30 ... Yes (6.56) Configuring DBIx-Class-ResultSet-RecursiveUpdate-0.24 Running Makefile.PL Warning: prerequisite DBIx::Class::IntrospectableM2M 0 not found. Checking if your kit is complete... Looks good Writing Makefile for DBIx::Class::ResultSet::RecursiveUpdate -> OK Finding PREREQ from Makefile ... Checking if you have DateTime 0 ... Yes (0.70) Checking if you have SQL::Translator 0.11006 ... Yes (0.11008) Checking if you have DBD::SQLite 1.21 ... Yes (1.33) Checking if you have Readonly 1.03 ... Yes (1.03) Checking if you have Test::More 0.88 ... Yes (0.98) Checking if you have Test::Warn 0.20 ... Yes (0.23) Checking if you have DBIx::Class::IntrospectableM2M 0 ... No Checking if you have Carp::Clan 6.04 ... Yes (6.04) Checking if you have DBIx::Class 0.08103 ... Yes (0.08192) Checking if you have List::MoreUtils 0.22 ... Yes (0.30) ==> Found dependencies: DBIx::Class::IntrospectableM2M Searching DBIx::Class::IntrospectableM2M on cpanmetadb ... --> Working on DBIx::Class::IntrospectableM2M Fetching http://search.cpan.org/CPAN/authors/id/G/GR/GRODITI/DBIx-Class-IntrospectableM2M-0.001001.tar.gz [...] -> OK Successfully installed DBIx-Class-IntrospectableM2M-0.001001 Building and testing DBIx-Class-ResultSet-RecursiveUpdate-0.24 cp lib/DBIx/Class/ResultSet/RecursiveUpdate.pm blib/lib/DBIx/Class/ResultSet/RecursiveUpdate.pm Manifying blib/man3/DBIx::Class::ResultSet::RecursiveUpdate.3pm PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t # Testing DBIx::Class::ResultSet::RecursiveUpdate 0.24 t/00load.t ................. ok t/moosified-rs.t ........... skipped: Moose, MooseX::NonMoose and namespace::autoclean required testing dbi:Pg:dbname=dbictest NOTICE: CREATE TABLE will create implicit sequence "onekey_id_seq" for serial column "onekey.id" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "onekey_pkey" for table "onekey" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "personality_pkey" for table "personality" NOTICE: CREATE TABLE will create implicit sequence "role_id_seq" for serial column "role.id" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "role_pkey" for table "role" NOTICE: CREATE TABLE will create implicit sequence "tag_id_seq" for serial column "tag.id" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "tag_pkey" for table "tag" NOTICE: CREATE TABLE will create implicit sequence "usr_id_seq" for serial column "usr.id" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "usr_pkey" for table "usr" NOTICE: CREATE TABLE will create implicit sequence "address_address_id_seq" for serial column "address.address_id" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "address_pkey" for table "address" NOTICE: CREATE TABLE will create implicit sequence "dvd_dvd_id_seq" for serial column "dvd.dvd_id" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dvd_pkey" for table "dvd" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "liner_notes_pkey" for table "liner_notes" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "twokeys_pkey" for table "twokeys" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "user_role_pkey" for table "user_role" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "viewing_pkey" for table "viewing" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dvdtag_pkey" for table "dvdtag" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "twokeys_belongsto_pkey" for table "twokeys_belongsto" DBIx::Class::Schema::deploy(): DBIx::Class::Schema::deploy(): DBI Exception: DBD::Pg::db do failed: ERROR: there is no unique constraint matching given keys for referenced table "dvd" at t/lib/DBSchemaBase.pm line 20 (running "ALTER TABLE "twokeys" ADD FOREIGN KEY ("dvd_name") REFERENCES "dvd" ("name") DEFERRABLE; ") at t/lib/DBSchemaBase.pm line 20 DBIx::Class::Schema::deploy(): DBIx::Class::Schema::deploy(): DBI Exception: DBD::Pg::db do failed: ERROR: there is no unique constraint matching given keys for referenced table "dvd" at t/lib/DBSchemaBase.pm line 20 (running "ALTER TABLE "twokeys_belongsto" ADD FOREIGN KEY ("key1") REFERENCES "dvd" ("twokeysfk") DEFERRABLE; ") at t/lib/DBSchemaBase.pm line 20 INSERT INTO usr ( name, password, username) VALUES ( ?, ?, ? ) RETURNING id: 'Test for nonexisting rel with suppressed warning but storage debugging', 'whatever', 'suppressed_nonexisting_rel_with_storage_debug' SELECT me.id, me.username, me.password, me.name FROM usr me WHERE ( me.id = ? ): '6' SELECT COUNT( * ) FROM usr me: DBIx::Class::ResultSet::RecursiveUpdate::recursive_update(): DBI Exception: DBD::Pg::st execute failed: ERROR: null value in column "id" violates not-null constraint [for Statement "INSERT INTO onekey ( id, name) VALUES ( ?, ? ) RETURNING id" with ParamValues: 1=undef, 2='aaaaa'] at t/lib/RunTests.pm line 152 # Looks like you planned 59 tests but ran 13. # Looks like your test exited with 29 just after 13. t/pg.t ..................... Dubious, test returned 29 (wstat 7424, 0x1d00) Failed 46/59 subtests t/pod-coverage.t ........... ok t/pod.t .................... ok t/release-dist-manifest.t .. skipped: these tests are for release candidate testing t/release-has-version.t .... skipped: these tests are for release candidate testing t/release-pod-coverage.t ... skipped: these tests are for release candidate testing t/release-pod-syntax.t ..... skipped: these tests are for release candidate testing t/release-portability.t .... skipped: these tests are for release candidate testing t/release-synopsis.t ....... skipped: these tests are for release candidate testing t/release-unused-vars.t .... skipped: these tests are for release candidate testing testing dbi:SQLite:dbname=t/var/dvdzbr.db INSERT INTO usr ( name, password, username) VALUES ( ?, ?, ? ): 'Test for nonexisting rel with suppressed warning but storage debugging', 'whatever', 'suppressed_nonexisting_rel_with_storage_debug' SELECT me.id, me.username, me.password, me.name FROM usr me WHERE ( me.id = ? ): '6' SELECT COUNT( * ) FROM usr me: t/sqlite.t ................. ok Test Summary Report ------------------- t/pg.t (Wstat: 7424 Tests: 13 Failed: 0) Non-zero exit status: 29 Parse errors: Bad plan. You planned 59 tests but ran 13. Files=13, Tests=75, 13 wallclock secs ( 0.13 usr 0.01 sys + 1.62 cusr 0.20 csys = 1.96 CPU) Result: FAIL Failed 1/13 test programs. 0/75 subtests failed. make: *** [test_dynamic] Error 255 -- ilmari "A disappointingly low fraction of the human race is, at any given time, on fire." - Stig Sandbeck Mathisen