DBD::Pg version 3.20.1 released April 30, 2026

[turnstep]

Version 3.20.1 has been tagged and uploaded to CPAN via pause. Mostly important bug fixes and improvements. No feature changes, so not a major version bump. From the Changes file:

• Set imp_dbh->async_sth when a prepare is successfully sent from pg_st_prepare_statement
  Don't execute "result auto-retrieve" code for a successful async prepare
  Increment imp_dbh->prepare_number when success of an async prepare is detected in handle_old_async
  [Rainer Weikusat, reported by Michael Kröll]
  (Github issue Mixup with prepared statement handles #183, pull request Handle async prepare correctly in handle_old_async #184)

• Fix hangup of queries like "COPY TO STDOUT" in async mode
  [Ed Sabol, Alexander Gorlov]
  (Github issue Hanging execution of queries like "COPY TO STDIN" in asynchronous mode. #98, pull request Fixed hangup of execution of queries like "COPY TO STDIN" in asynchronous mode. #101 and Redux: Fix hangup of execution of queries like "COPY TO STDOUT" in asynchronous mode (now with tests) #163)

• Improve documentation about sslmode options
  [Ed Sabol, reported by Alexander Karelas]
  (Github issue POD suggests it's impossible to verify server-side SSL certificates #180, pull request Issue #180: Update sslmode documentation #186)

• Drop ExtUtils::MakeMaker requirement back to 6.58, but recommend 7.64
  [Greg Sabino Mullane, Ed Sabol, reported by Peter Tribble]
  (Github issue Build fails on perl 5.34 #170)

• Shorten path for test database to reduce OS errors
  [Greg Sabino Mullane, Ed Sabol, reported by Gianni Ceccarelli and Peter Dyballa]
  (Github issue Tests fail when run in a directory with a long name #78 and DBD::Pg cannot be tested on macOS (or Mac OS X) with MacPorts package manager because socket path is too long #185)
  (RT ticket #157598)

[echolet]

This new version seems to fail to list App::Info::RDBMS::PostgreSQL as a prerequisite maybe? Fetching http://www.cpan.org/authors/id/T/TU/TURNSTEP/DBD-Pg-3.20.1.tar.gz -> OK Unpacking DBD-Pg-3.20.1.tar.gz Entering DBD-Pg-3.20.1 Checking configure dependencies from META.json Checking if you have version 0 ... Yes (0.9934) Checking if you have DBI 1.614 ... Yes (1.647) Checking if you have ExtUtils::MakeMaker 6.58 ... Yes (7.78) Configuring DBD-Pg-3.20.1 Running Makefile.PL Can't locate App/Info/RDBMS/PostgreSQL.pm in @inc (you may need to install the App::Info::RDBMS::PostgreSQL module) My PostgreSQL version is 14.22

…

-- Éric Cholet

[esabol]

Cannot reproduce, @echolet. What did you use to try to install it?

[echolet]

This is using cpanm on MacOS. Here's the entire log output: cpanm (App::cpanminus) 1.7049 on perl 5.042002 built for darwin-2level Work directory is /Users/eric/.cpanm/work/1777651175.45068 You have make /usr/bin/make You have LWP 6.82 You have /usr/bin/tar: bsdtar 3.5.3 - libarchive 3.7.4 zlib/1.2.12 liblzma/5.4.3 bz2lib/1.0.8 You have /usr/bin/unzip Searching DBD::Pg () on cpanmetadb ... --> Working on DBD::Pg Fetching http://www.cpan.org/authors/id/T/TU/TURNSTEP/DBD-Pg-3.20.1.tar.gz -> OK Unpacking DBD-Pg-3.20.1.tar.gz Entering DBD-Pg-3.20.1 Checking configure dependencies from META.json Checking if you have version 0 ... Yes (0.9934) Checking if you have DBI 1.614 ... Yes (1.647) Checking if you have ExtUtils::MakeMaker 6.58 ... Yes (7.78) Configuring DBD-Pg-3.20.1 Running Makefile.PL Can't locate App/Info/RDBMS/PostgreSQL.pm in @inc (you may need to install the App::Info::RDBMS::PostgreSQL module) ***@***.*** entries checked: t:lib /Users/eric/svn/chandra/lib /Users/eric/perl5/perlbrew/perls/perl-5.42.2/lib/site_perl/5.42.2/darwin-2level /Users/eric/perl5/perlbrew/perls/perl-5.42.2/lib/site_perl/5.42.2 /Users/eric/perl5/perlbrew/perls/perl-5.42.2/lib/5.42.2/darwin-2level /Users/eric/perl5/perlbrew/perls/perl-5.42.2/lib/5.42.2 .) at Makefile.PL line 80. I do have DBD::Pg 3.20.0 currently installed on this system, which was installed the same way, using cpanm, and that didn't fail. I see that 3.20.0's Makefile.PL also requires App::Info::RDBMS::PostgreSQL. I don't recall ever installing that module, so I don't understand why 3.20.0 didn't fail in the same way.

…

-- Éric Cholet

[esabol]

Well, I've used cpanm to install DBD::Pg 3.20.1 just fine. I'm using a different version of cpanm though, and I'm not on macOS. You should open an issue. This isn't really the place to be reporting or diagnosing installation issues.

That said, the weird thing i'm seeing is the @inc in Can't locate App/Info/RDBMS/PostgreSQL.pm in @inc. Last time I checked, Perl uses @INC, not @inc, so I don't what's going on there.

You don't need to have App::Info::RDBMS::PostgreSQL installed. It's not a Perl module that gets installed anywhere. It's part of the DBD::Pg distribution and only used during testing. There's nothing about this that has changed in many years.

[esabol]

I just tested using the latest version of cpanm (version 1.7049, same as you) to install DBD::Pg 3.20.1 on a Perl 5.42.2 Linux system, and it worked fine.

[echolet]

Le 1 mai 2026 à 22:42, Ed Sabol ***@***.***> a écrit : Well, I've used cpanm to install DBD::Pg 3.20.1 just fine. I'm using a different version of cpanm though, and I'm not on macOS. You should open an issue. This isn't really the place to be reporting or diagnosing installation issues. That said, the weird thing i'm seeing is the @inc in Can't locate App/Info/RDBMS/PostgreSQL.pm in @inc. Last time I checked, Perl uses @inc, not @inc, so I don't what's going on there.

I don't see any @inc in the emails I sent, only @inc. Here's an attempt to install without cpanm. ***@***.*** ~/.cpanm/work/1777651175.45068/DBD-Pg-3.20.1 % perl Makefile.PL Configuring DBD::Pg 3.20.1 Can't locate App/Info/RDBMS/PostgreSQL.pm in @inc (you may need to install the App::Info::RDBMS::PostgreSQL module) ***@***.*** entries checked: t:lib /Users/eric/svn/chandra/lib /Users/eric/perl5/perlbrew/perls/perl-5.42.2/lib/site_perl/5.42.2/darwin-2level /Users/eric/perl5/perlbrew/perls/perl-5.42.2/lib/site_perl/5.42.2 /Users/eric/perl5/perlbrew/perls/perl-5.42.2/lib/5.42.2/darwin-2level /Users/eric/perl5/perlbrew/perls/perl-5.42.2/lib/5.42.2) at Makefile.PL line 80.

You don't need to have App::Info::RDBMS::PostgreSQL installed. It's not a Perl module that gets installed anywhere. It's part of the DBD::Pg distribution and only used during the installation process. There's nothing about this that has changed in many years.

Thanks. Looking further into this, I find that in 3.20.0's Makefile.PL my %seplist = ( MacOS => ':', MSWin32 => '\\', whereas in 3.20.1 we have my %seplist = ( MacOS => ':', darwin => ':', MSWin32 => '\\', On MacOSX $^O is darwin and the separator should be '/', not ':'. This is why in the log output above we see @inc entries checked: t:lib which should be t/lib

…

-- Éric Cholet

[esabol]

Yes, I just discovered that difference myself. You're absolutely correct. That %seplist entry should never have been added.

[esabol]

This illustrates why the DBD::Pg project needs a macOS build in its CI workflow. See issue #173.

[esabol]

I don't see any @inc in the emails I sent, only @inc.

Oh, ha! I was looking on the GitHub website. GitHub changed the @INC to @inc in your emails presumably because it thought you were referencing a GitHub user.

Also, I have submitted PR #191 to fix this problem.

[esabol]

DBD::Pg 3.20.2 has been released to address this and is on CPAN, FYI.