--- Begin Message ---
- To: Debian Bug Tracking System <submit@bugs.debian.org>
- Subject: libreoffice-sdbc-postgresql: Cannot work with postgresql 12 databases
- From: Kamil Jonca <kjonca@poczta.onet.pl>
- Date: Thu, 31 Oct 2019 07:09:18 +0100
- Message-id: <157250215859.3501.272966687979576985.reportbug@alfa.kjonca>
Package: libreoffice-sdbc-postgresql
Version: 1:6.3.3~rc1-1
Severity: important
Tags: upstream
I am not sure if it is really upstream things but I filled bug https: //bugs.documentfoundation.org/show_bug.cgi?id=128488
libreoffice-sdbc-postgresql is unusable with postgresql 12 databases
In logs I can see:
2019-10-31 05:19:16 CET LOG: statement: SELECT pg_namespace.nspname,
pg_class.relname, pg_attribute.attname, pg_type.typname,
pg_attribute.atttypmod, pg_attribute.attnotnull, pg_type.typdefault,
pg_type.typtype, pg_attrdef.adsrc, pg_description.description,
pg_type.typbasetype, pg_attribute.attnum FROM pg_class,
pg_attribute LEFT JOIN pg_attrdef ON pg_attribute.attrelid =
pg_attrdef.adrelid AND pg_attribute.attnum = pg_attrdef.adnum LEFT
JOIN pg_description ON pg_attribute.attrelid = pg_description.objoid
AND pg_attribute.attnum=pg_description.objsubid, pg_type, pg_namespace
WHERE pg_attribute.attrelid = pg_class.oid AND
pg_attribute.atttypid = pg_type.oid AND pg_class.relnamespace =
pg_namespace.oid AND NOT pg_attribute.attisdropped AND
pg_namespace.nspname LIKE 'public' AND pg_class.relname LIKE
'przesylki' AND pg_attribute.attname LIKE '%' ORDER BY
pg_namespace.nspname, pg_class.relname, pg_attribute.attnum
2019-10-31 05:19:16 CET ERROR: column pg_attrdef.adsrc does not exist at character 173
pg_attrdef.adsrc was removed from postgresql 12 and postgresql authors sugges using something like
pg_get_expr(pg_attrdef.adbin,pg_attrdef.adrelid) in queries
-- System Information:
Debian Release: bullseye/sid
APT prefers unstable
APT policy: (500, 'unstable'), (500, 'stable'), (1, 'experimental')
Architecture: amd64 (x86_64)
Foreign Architectures: i386
Kernel: Linux 5.3.7+1kjonca (SMP w/4 CPU cores)
Kernel taint flags: TAINT_WARN, TAINT_FIRMWARE_WORKAROUND, TAINT_UNSIGNED_MODULE
Locale: LANG=pl_PL.UTF-8, LC_CTYPE=pl_PL.UTF-8 (charmap=UTF-8), LANGUAGE=pl_PL.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled
Versions of packages libreoffice-sdbc-postgresql depends on:
ii libc6 2.29-2
ii libgcc1 1:9.2.1-16
ii libpq5 12.0-1+b1
ii libreoffice-core 1:6.3.3~rc1-1
ii libstdc++6 9.2.1-16
ii uno-libs3 6.3.3~rc1-1
ii ure 6.3.3~rc1-1
libreoffice-sdbc-postgresql recommends no packages.
Versions of packages libreoffice-sdbc-postgresql suggests:
ii postgresql 12+208
-- no debconf information
--- End Message ---
--- Begin Message ---
- To: 943873-close@bugs.debian.org
- Subject: Bug#943873: fixed in libreoffice 1:6.1.5-3+deb10u5
- From: Rene Engelhard <rene@debian.org>
- Date: Sat, 09 Nov 2019 20:35:11 +0000
- Message-id: <E1iTXRv-000Hb2-3f@fasolo.debian.org>
Source: libreoffice
Source-Version: 1:6.1.5-3+deb10u5
We believe that the bug you reported is fixed in the latest version of
libreoffice, which is due to be installed in the Debian FTP archive.
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to 943873@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Rene Engelhard <rene@debian.org> (supplier of updated libreoffice package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmaster@ftp-master.debian.org)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512
Format: 1.8
Date: Thu, 31 Oct 2019 18:26:41 +0100
Source: libreoffice
Architecture: source
Version: 1:6.1.5-3+deb10u5
Distribution: buster
Urgency: medium
Maintainer: Debian LibreOffice Maintainers <debian-openoffice@lists.debian.org>
Changed-By: Rene Engelhard <rene@debian.org>
Closes: 943873
Changes:
libreoffice (1:6.1.5-3+deb10u5) buster; urgency=medium
.
* debian/patches/Postgresql-12-no-adsrc.diff: add from
libreoffice-6-3 branch; fix the postgresql driver with
PostgreSQL 12 (closes: #943873)
Checksums-Sha1:
d2f3deb8135907c9af0261e6815da78245ef64a8 27751 libreoffice_6.1.5-3+deb10u5.dsc
3b8e843d68eabe5b71ba9616786683ef157afb34 9978044 libreoffice_6.1.5-3+deb10u5.debian.tar.xz
93372233bb6de372b418960b96ec75854fb7362d 43525 libreoffice_6.1.5-3+deb10u5_source.buildinfo
Checksums-Sha256:
64fab15443d3aaf3141ab1b24e2901c28f845f3eeca3aad98044570222edfc26 27751 libreoffice_6.1.5-3+deb10u5.dsc
e2753fd908b18451f06f85c4f43eb1eefaad9fbe29c72267b85367fca15f5728 9978044 libreoffice_6.1.5-3+deb10u5.debian.tar.xz
ac1cd4eec6c065b11e23b934a10c47509c5f4ea9733d479a48dbbe858057ed9d 43525 libreoffice_6.1.5-3+deb10u5_source.buildinfo
Files:
140d27ae95f35c867eb44acf76524a07 27751 editors optional libreoffice_6.1.5-3+deb10u5.dsc
44b89dc02f9899081c88cdb9709fb922 9978044 editors optional libreoffice_6.1.5-3+deb10u5.debian.tar.xz
3b23f5dd54a0086c85c1a443485162a3 43525 editors optional libreoffice_6.1.5-3+deb10u5_source.buildinfo
-----BEGIN PGP SIGNATURE-----
iQJEBAEBCgAuFiEE4S3qRnUGcM+pYIAdCqBFcdA+PnAFAl3Am9AQHHJlbmVAZGVi
aWFuLm9yZwAKCRAKoEVx0D4+cAQ1EACEY5cOrLtTm1C5IBPrRf8dsNRscW+fYJOa
szagzukjASp47Aeu/82kAnylMEU8C+Uok3jVs03uMi2N7f1Rynk6KEbEmRF3xwOd
gYPIfUFVSKiWf4j+Mj5IEMVZQ5KuzYt1LF7elGEWAkbB9STrlhebegGXx+TPlxhL
OLjatRyX4mT0Zh07actyunQsU1tGzAcNPurh5x60XDgXqIFPXW1DfMvTITY9AQdx
SzbyrQPl6p+gP3NS49CIZmXaPGlToMrjmv79d4jbpmoy8+YgkmbtARpRizJxnOEy
yHfThGPz1k5cItRrKMyhttjZvJScbZ6MLTiQzq8KRw1bObfFi8FJxkSf0N4C6QLQ
X7lrOd2XPuzDwsDSYerSQVjS7FktGAZ4M9rxcgOWBnFgvhC3fvOuMq1nOyl5/Kwl
TiYPTp6njbkGZsp6Y1nZptduw8PlRyk6jvfvJ+v0NRl6TaEkNLmvWjMhKtVef/2y
DUyfFYZJ1zriGkkXJX8Ssepbn8Eka4VcZvgVJiccc6mQl/jWjoBmJHn0RU1XAk/t
7EOtTOkeEi2X7dTfEEhdufMGQefrgq7kgylXiH8fvDyYCdxNfUcvyK+qG90JldjF
8/kvXYsPntA14WnXYKEYxAEtsfZnneetd0eBc2klmHVXv/EKadncBTZi3YVz50vo
UixDwVuntQ==
=w1Jd
-----END PGP SIGNATURE-----
--- End Message ---