Bug #132965 for DBD-Pg: Tests no longer pass when DBI_USER != postgres

In the past, it was completely fine to inject this in your environment before running tests:

DBI_DSN="dbi:Pg:dbname=pgtest"
DBI_USER="pgtest_user"
DBI_PASS="test"

( See also: https://wiki.gentoo.org/wiki/Project:Perl/maint-notes/dev-perl/DBD-Pg#Portage_Configuration )

And the database configuration is done as following:

 https://wiki.gentoo.org/wiki/Project:Perl/maint-notes/dev-perl/DBD-Pg#Database_Configuration

Which to me, seemed nicer and provided more guarantees about not contaminating your database than the default, "run tests as superuser: postgres"

Alas, this now seems to mean that various tests are broken, because they *ONLY* work as the superuser.

t/03dbmethod.t ......... 1/600 DBD::Pg::db do failed: ERROR:  permission denied to create foreign-data wrapper "dbd_pg_testfdw"
HINT:  Must be superuser to create a foreign-data wrapper. at t/03dbmethod.t line 742.
Issuing rollback() due to DESTROY without explicit disconnect() of DBD::Pg::db handle dbname=pgtest at t/03dbmethod.t line 742.
Show quoted text
t/03dbmethod.t ......... Dubious, test returned 255 (wstat 65280, 0xff00)


t/04misc.t ............. 81/95 DBD::Pg::db do failed: ERROR:  permission denied to set parameter "max_stack_depth" at t/04misc.t line 532, <$fh> line 8.
Issuing rollback() due to DESTROY without explicit disconnect() of DBD::Pg::db handle dbname=pgtest at t/04misc.t line 532, <$fh> line 8.
Show quoted text
t/04misc.t ............. Dubious, test returned 255 (wstat 65280, 0xff00)
Failed 14/95 subtests


This was, for whatever reason, previously not the case.


Show quoted text

Full test report comming to a CPAN Testers near you eventually when it stops timing out on every page load.

-- 
- CPAN kentnl@cpan.org
- Gentoo Perl Maintainer kentnl@gentoo.org ( perl@gentoo.org )