Bug#943873: libreoffice-sdbc-postgresql: Cannot work with postgresql 12 databases
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
Reply to: