Bug#1072152: libreoffice-base: Copy/Paste calc>base fails on external postgres when used to specific schema on database
Package: libreoffice-base
Version: 4:7.4.7-1+deb12u2
Severity: normal
X-Debbugs-Cc: wim.bertels@ucll.be
Hello,
this bug has been present for quiet a while in my experience.
An example on how to reproduce:
1. create a small simple table in calc, eg a 2c by 4r table with a header (eg id, value with some rows)
2. connect to a postgres database with multiple schemas as a regular user userx (non superuser) (eg the schema schema1, schema2, schema3 exist) (using the built in external options
3. copy the small table from calc
4. paste it into a non default schema, like schema1
5. go through the popup menu and make the table
6. an exception will be thrown that the schema userx does not exist, even though you pasting to schema1
Designing a table does not have this issue.
I know this is not the latest version, but this is a bug that has existed for some years now, i don't think it fixed in more recent versions.
hth,
Wim
-- Package-specific info:
Configuration file Package Exists Changed
/etc/libreoffice/registry/base.xcd libreoffice-base Yes No
All deployed bundled extensions:
Identifier: com.sun.wiki-publisher
Version: 1.2.0
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/wiki-publisher
is registered: yes
Media-Type: application/vnd.sun.star.package-bundle
Description: De Wiki Publisher stelt u in staat om Wiki-artikelen te maken op MediaWiki-server zonder de syntaxis van de MediaWiki markup language te kennen. Publiceer uw nieuwe en bestaande documenten duidelijk met Writer naar een Wiki-pagina.
bundled Packages: {
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/wiki-publisher/help
is registered: yes
Media-Type: application/vnd.sun.star.help
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/wiki-publisher/WikiExtension.xcs
is registered: yes
Media-Type: application/vnd.sun.star.configuration-schema
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/wiki-publisher/WikiEditor/
is registered: yes
Media-Type: application/vnd.sun.star.basic-library
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/wiki-publisher/components.rdb
is registered: yes
Media-Type: application/vnd.sun.star.uno-components
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/wiki-publisher/Addons.xcu
is registered: yes
Media-Type: application/vnd.sun.star.configuration-data
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/wiki-publisher/ProtocolHandler.xcu
is registered: yes
Media-Type: application/vnd.sun.star.configuration-data
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/wiki-publisher/WikiExtension.xcu
is registered: yes
Media-Type: application/vnd.sun.star.configuration-data
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/wiki-publisher/OptionsDialog.xcu
is registered: yes
Media-Type: application/vnd.sun.star.configuration-data
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/wiki-publisher/Filter.xcu
is registered: yes
Media-Type: application/vnd.sun.star.configuration-data
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/wiki-publisher/Types.xcu
is registered: yes
Media-Type: application/vnd.sun.star.configuration-data
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/wiki-publisher/Paths.xcu
is registered: yes
Media-Type: application/vnd.sun.star.configuration-data
Description:
}
Identifier: com.sun.star.comp.Calc.NLPSolver
Version: 0.9
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/nlpsolver
is registered: yes
Media-Type: application/vnd.sun.star.package-bundle
Description: Deze extensie wordt ge\xefntegreerd in Calc en biedt nieuwe oplossingsmethoden die gebruikt kunnen worden voor het optimaliseren van niet-lineaire programmeermodellen.
bundled Packages: {
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/nlpsolver/help
is registered: yes
Media-Type: application/vnd.sun.star.help
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/nlpsolver/components.rdb
is registered: yes
Media-Type: application/vnd.sun.star.uno-components
Description:
}
Identifier: org.openoffice.da.writer2latex.oxt
Version: 1.4
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/writer2latex
is registered: yes
Media-Type: application/vnd.sun.star.package-bundle
Description: Writer2LaTeX voorziet in exportfilters voor LaTeX en BibTeX
bundled Packages: {
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/writer2latex/help
is registered: yes
Media-Type: application/vnd.sun.star.help
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/writer2latex/writer2latex.rdb
is registered: yes
Media-Type: application/vnd.sun.star.uno-typelibrary;type=RDB
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/writer2latex/W2LDialogs2/
is registered: yes
Media-Type: application/vnd.sun.star.basic-library
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/writer2latex/W2LDialogs/
is registered: yes
Media-Type: application/vnd.sun.star.basic-library
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/writer2latex/Options.xcs
is registered: yes
Media-Type: application/vnd.sun.star.configuration-schema
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/writer2latex/writer2latex-filter.jar
is registered: yes
Media-Type: application/vnd.sun.star.uno-component;type=Java
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/writer2latex/w2l_types.xcu
is registered: yes
Media-Type: application/vnd.sun.star.configuration-data
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/writer2latex/w2l_filters.xcu
is registered: yes
Media-Type: application/vnd.sun.star.configuration-data
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/writer2latex/OptionPages.xcu
is registered: yes
Media-Type: application/vnd.sun.star.configuration-data
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/writer2latex/Options.xcu
is registered: yes
Media-Type: application/vnd.sun.star.configuration-data
Description:
}
Identifier: org.openoffice.da.writer2xhtml.oxt
Version: 1.4
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/writer2xhtml
is registered: yes
Media-Type: application/vnd.sun.star.package-bundle
Description: Writer2xhtml verzorgt Writer en Calc met exportfilters voor XHTML en XHTML + MathML
bundled Packages: {
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/writer2xhtml/help
is registered: yes
Media-Type: application/vnd.sun.star.help
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/writer2xhtml/writer2xhtml.rdb
is registered: yes
Media-Type: application/vnd.sun.star.uno-typelibrary;type=RDB
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/writer2xhtml/W2XDialogs2/
is registered: yes
Media-Type: application/vnd.sun.star.basic-library
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/writer2xhtml/W2XDialogs/
is registered: yes
Media-Type: application/vnd.sun.star.basic-library
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/writer2xhtml/Options.xcs
is registered: yes
Media-Type: application/vnd.sun.star.configuration-schema
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/writer2xhtml/writer2xhtml-filter.jar
is registered: yes
Media-Type: application/vnd.sun.star.uno-component;type=Java
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/writer2xhtml/w2x_types.xcu
is registered: yes
Media-Type: application/vnd.sun.star.configuration-data
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/writer2xhtml/w2x_filters.xcu
is registered: yes
Media-Type: application/vnd.sun.star.configuration-data
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/writer2xhtml/Options.xcu
is registered: yes
Media-Type: application/vnd.sun.star.configuration-data
Description:
URL: vnd.sun.star.expand:$BUNDLED_EXTENSIONS/writer2xhtml/OptionPages.xcu
is registered: yes
Media-Type: application/vnd.sun.star.configuration-data
Description:
}
All deployed shared extensions:
<none>
All deployed user extensions:
<none>
Experimental features enabled:
<item oor:path="/org.openoffice.Office.Common/Misc"><prop oor:name="ExperimentalMode" oor:op="fuse"><value>false</value></prop></item>
Installed VCLplugs:
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name Version Architecture Description
+++-================-=================-============-===============================================
ii libreoffice-gtk3 4:7.4.7-1+deb12u2 amd64 office productivity suite -- GTK+ 3 integration
un libreoffice-kf5 <none> <none> (no description available)
un libreoffice-qt5 <none> <none> (no description available)
Java (javaldx):
/usr/lib/jvm/java-17-openjdk-amd64/lib/amd64/client:/usr/lib/jvm/java-17-openjdk-amd64/lib/amd64/server:/usr/lib/jvm/java-17-openjdk-amd64/lib/amd64/native_threads:/usr/lib/jvm/java-17-openjdk-amd64/lib/amd64
Java:
<java xmlns="http://openoffice.org/2004/java/framework/1.0"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
<javaInfo xsi:nil="false" vendorUpdate="2019-07-26" autoSelect="true">
<location>file:///usr/lib/jvm/java-11-openjdk-amd64</location>
</javaInfo>
</java>
-- System Information:
Debian Release: 12.5
APT prefers stable-updates
APT policy: (500, 'stable-updates'), (500, 'stable-security'), (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 6.1.0-17-amd64 (SMP w/8 CPU threads; PREEMPT)
Kernel taint flags: TAINT_PROPRIETARY_MODULE, TAINT_OOT_MODULE, TAINT_UNSIGNED_MODULE
Locale: LANG=nl_BE.utf8, LC_CTYPE=nl_BE.utf8 (charmap=UTF-8) (ignored: LC_ALL set to nl_BE.utf8), LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled
Versions of packages libreoffice-base depends on:
ii dpkg 1.21.22
ii libc6 2.36-9+deb12u7
ii libgcc-s1 12.2.0-14
ii libreoffice-base-core 4:7.4.7-1+deb12u2
ii libreoffice-base-drivers 4:7.4.7-1+deb12u2
ii libreoffice-common 4:7.4.7-1+deb12u2
ii libreoffice-core 4:7.4.7-1+deb12u2
ii libstdc++6 12.2.0-14
ii libuno-cppu3 4:7.4.7-1+deb12u2
ii libuno-cppuhelpergcc3-3 4:7.4.7-1+deb12u2
ii libuno-sal3 4:7.4.7-1+deb12u2
ii libuno-salhelpergcc3-3 4:7.4.7-1+deb12u2
ii ucf 3.0043+nmu1
ii uno-libs-private 4:7.4.7-1+deb12u2
Versions of packages libreoffice-base recommends:
ii default-jre [java8-runtime] 2:1.17-74
ii libreoffice-java-common 4:7.4.7-1+deb12u2
ii libreoffice-writer 4:7.4.7-1+deb12u2
ii openjdk-11-jre [java8-runtime] 11.0.20+8-1~deb11u1
ii openjdk-17-jre [java8-runtime] 17.0.11+9-1~deb12u1
Versions of packages libreoffice-base suggests:
ii libreoffice-report-builder 4:7.4.7-1+deb12u2
ii python3-uno 4:7.4.7-1+deb12u2
pn unixodbc <none>
Versions of packages libreoffice-core depends on:
ii fontconfig 2.14.1-4
ii fonts-opensymbol 4:102.12+LibO7.4.7-1+deb12u2
ii libabsl20220623 20220623.1-1
ii libboost-locale1.74.0 1.74.0+ds1-21
ii libc6 2.36-9+deb12u7
ii libcairo2 1.16.0-7
ii libclucene-contribs1v5 2.3.3.4+dfsg-1.1
ii libclucene-core1v5 2.3.3.4+dfsg-1.1
ii libcups2 2.4.2-3+deb12u5
ii libcurl3-gnutls 7.88.1-10+deb12u5
ii libdbus-1-3 1.14.10-1~deb12u1
ii libdconf1 0.40.0-4
ii libeot0 0.01-5+b1
ii libepoxy0 1.5.10-1
ii libexpat1 2.5.0-1
ii libexttextcat-2.0-0 3.4.5-1
ii libfontconfig1 2.14.1-4
ii libfreetype6 2.12.1+dfsg-5
ii libgcc-s1 12.2.0-14
ii libglib2.0-0 2.74.6-2+deb12u2
ii libgpgmepp6 1.18.0-3+b1
ii libgraphite2-3 1.3.14-1
ii libgstreamer-plugins-base1.0-0 1.22.0-3+deb12u1
ii libgstreamer1.0-0 1.22.0-2
ii libharfbuzz-icu0 6.0.0+dfsg-3
ii libharfbuzz0b 6.0.0+dfsg-3
ii libhunspell-1.7-0 1.7.1-1
ii libhyphen0 2.8.8-7
ii libice6 2:1.0.10-1
ii libicu72 72.1-3
ii libjpeg62-turbo 1:2.1.5-2
ii liblcms2-2 2.14-2
ii libldap-2.5-0 2.5.13+dfsg-5
ii libmythes-1.2-0 2:1.2.5-1
ii libnspr4 2:4.35-1
ii libnss3 2:3.87.1-1
ii libnumbertext-1.0-0 1.0.11-1
ii libopenjp2-7 2.5.0-2
ii liborcus-0.17-0 0.17.2-2+b2
ii liborcus-parser-0.17-0 0.17.2-2+b2
ii libpng16-16 1.6.39-2
ii libpoppler126 22.12.0-2+b1
ii libraptor2-0 2.0.15-4
ii librdf0 1.0.17-3
ii libreoffice-common 4:7.4.7-1+deb12u2
ii librevenge-0.0-0 0.0.5-3
ii libsm6 2:1.2.3-1
ii libstdc++6 12.2.0-14
ii libtiff6 4.5.0-6+deb12u1
ii libuno-cppu3 4:7.4.7-1+deb12u2
ii libuno-cppuhelpergcc3-3 4:7.4.7-1+deb12u2
ii libuno-sal3 4:7.4.7-1+deb12u2
ii libuno-salhelpergcc3-3 4:7.4.7-1+deb12u2
ii libwebp7 1.2.4-0.2+deb12u1
ii libx11-6 2:1.8.4-2+deb12u2
ii libx11-xcb1 2:1.8.4-2+deb12u2
ii libxext6 2:1.3.4-1+b1
ii libxinerama1 2:1.1.4-3
ii libxml2 2.9.14+dfsg-1.3~deb12u1
ii libxmlsec1 1.2.37-2
ii libxmlsec1-nss 1.2.37-2
ii libxrandr2 2:1.5.2-2+b1
ii libxrender1 1:0.9.10-1.1
ii libxslt1.1 1.1.35-1
ii libzxing2 1.4.0-3+b1
ii uno-libs-private 4:7.4.7-1+deb12u2
ii ure 4:7.4.7-1+deb12u2
ii zlib1g 1:1.2.13.dfsg-1
Versions of packages libreoffice-core recommends:
ii gstreamer1.0-libav 1.22.0-2
ii gstreamer1.0-plugins-bad 1.22.0-4+deb12u5
ii gstreamer1.0-plugins-base 1.22.0-3+deb12u1
ii gstreamer1.0-plugins-good 1.22.0-5+deb12u1
ii gstreamer1.0-plugins-ugly 1.22.0-2+deb12u1
ii libpaper-utils 1.1.29
Versions of packages libreoffice-base is related to:
pn libmariadb-java <none>
pn libmyodbc <none>
pn libmysql-java <none>
pn libpg-java <none>
pn libsapdbc-java <none>
pn libsqliteodbc <none>
pn mdbtools <none>
pn odbc-postgresql <none>
pn tdsodbc <none>
pn unixodbc <none>
-- no debconf information
Reply to: