Bug#972847: libdbd-pg-perl: last_insert_id doesn't work against PostgreSQL 12 (or greater)

[Andrew Ruthven]

Package: libdbd-pg-perl
Version: 3.7.4-3
Severity: important

Dear Maintainer,

The version of DBD::Pg in Buster (and earlier) is incompatible with PostgreSQL
12 (or greater) if the application code using DBD::Pg uses the last_insert_id
function. The last_insert_id method uses the pg_attrdef.adsrc column which was
removed in Pg 12 (search for adsrc):

  https://www.postgresql.org/docs/12/release-12.html

DBD::Pg removed the usage of pg_attrdef.adsrc in version 3.8.0 with commit:

  88d2f8f1fc95bcd16e95d3fc667783fb7a9ab05b

I've set this as important as it may affect people running PostgreSQL from
the pgdg repos provided by PostgreSQL.

This bug shouldn't affect bullseye which currently has version 3.14.2.

Cheers,
Andrew

-- System Information:
Debian Release: 10.6
  APT prefers common
  APT policy: (500, 'common'), (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 4.9.227-vs2.3.9.12-beng (SMP w/8 CPU cores)
Locale: LANG=en_NZ.UTF-8, LC_CTYPE=POSIX (charmap=UTF-8) (ignored: LC_ALL set to en_NZ.UTF-8), LANGUAGE=en_NZ:en (charmap=UTF-8) (ignored: LC_ALL set to en_NZ.UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: sysvinit (via /sbin/init)

Versions of packages libdbd-pg-perl depends on:
ii  libc6                         2.28-10
ii  libdbi-perl [perl-dbdabi-94]  1.642-1+deb10u1
ii  libpq5                        11.9-0+deb10u1
ii  perl                          5.28.1-6+deb10u1
ii  perl-base [perlapi-5.28.1]    5.28.1-6+deb10u1

libdbd-pg-perl recommends no packages.

libdbd-pg-perl suggests no packages.

-- no debconf information