Your message dated Tue, 20 Dec 2022 03:50:48 +0100
with message-id <2601f42c-e136-9af7-9114-ba9fbc789...@free.fr>
and subject line libreoffice-base: schema not respected in copy/paste of
calc_table to base_table
has caused the Debian Bug report #922764,
regarding libreoffice-base: schema not respected in copy/paste of calc_table to
base_table
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact ow...@bugs.debian.org
immediately.)
--
922764: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=922764
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
Package: libreoffice-base
Version: 1:5.2.7-1+deb9u5
Severity: normal
Hallo,
U can use copy/paste between calc and base to create a database table form calc
data.
I tested this with postgresql
Backend setup:
* pg server
* user user1
* database db1
** schema schema1
** schema schema2
When u paste the data (from calc) into the schema1 (in base) the schema is
ignored or it will give an error.
When u try the same with a different database client, this will work.
Given the error base gives, it seems it only reads the default search_path of
the logged in user,
and completely ignores the schema1 in which it was pasted. This allowing only
to paste in a schema that is in the default path of user1.
PS: set search_path to schema1; is not recognized in base
Suggestion: make the paste command in base schema aware
hth,
Wim
-- System Information:
Debian Release: 9.7
APT prefers stable-updates
APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 4.9.0-8-amd64 (SMP w/2 CPU cores)
Locale: LANG=nl_BE.utf8, LC_CTYPE=nl_BE.utf8 (charmap=UTF-8),
LANGUAGE=nl_BE.utf8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
Versions of packages libreoffice-base depends on:
ii dpkg 1.18.25
ii libc6 2.24-11+deb9u3
ii libgcc1 1:6.3.0-18+deb9u1
ii libreoffice-base-core 1:5.2.7-1+deb9u5
ii libreoffice-base-drivers 1:5.2.7-1+deb9u5
ii libreoffice-core 1:5.2.7-1+deb9u5
ii libstdc++6 6.3.0-18+deb9u1
ii uno-libs3 5.2.7-1+deb9u5
ii ure 5.2.7-1+deb9u5
Versions of packages libreoffice-base recommends:
ii default-jre [java5-runtime] 2:1.8-58
ii libreoffice-java-common 1:5.2.7-1+deb9u5
ii libreoffice-writer 1:5.2.7-1+deb9u5
ii openjdk-8-jre [java5-runtime] 8u181-b13-2~deb9u1
Versions of packages libreoffice-base suggests:
pn libreoffice-gcj <none>
ii libreoffice-report-builder 1:5.2.7-1+deb9u5
pn unixodbc <none>
Versions of packages libreoffice-core depends on:
ii fontconfig 2.11.0-6.7+b1
ii fonts-opensymbol 2:102.7+LibO5.2.7-1+deb9u5
ii libboost-date-time1.62.0 1.62.0+dfsg-4
ii libc6 2.24-11+deb9u3
ii libcairo2 1.14.8-1
ii libclucene-contribs1v5 2.3.3.4+dfsg-1
ii libclucene-core1v5 2.3.3.4+dfsg-1
ii libcmis-0.5-5v5 0.5.1+git20160603-3+b1
ii libcups2 2.2.1-8+deb9u2
ii libcurl3-gnutls 7.52.1-5+deb9u9
ii libdbus-1-3 1.10.26-0+deb9u1
ii libdbus-glib-1-2 0.108-2
ii libdconf1 0.26.0-2+b1
ii libeot0 0.01-4+b1
ii libexpat1 2.2.0-2+deb9u1
ii libexttextcat-2.0-0 3.4.4-2+b1
ii libfontconfig1 2.11.0-6.7+b1
ii libfreetype6 2.6.3-3.2
ii libgcc1 1:6.3.0-18+deb9u1
ii libgl1-mesa-glx [libgl1] 13.0.6-1+b2
ii libglew2.0 2.0.0-3+b1
ii libglib2.0-0 2.50.3-2
ii libgltf-0.0-0v5 0.0.2-5
ii libglu1-mesa [libglu1] 9.0.0-2.1
ii libgraphite2-3 1.3.10-1
ii libharfbuzz-icu0 1.4.2-1
ii libharfbuzz0b 1.4.2-1
ii libhunspell-1.4-0 1.4.1-2+b2
ii libhyphen0 2.8.8-5
ii libice6 2:1.0.9-2
ii libicu57 57.1-6+deb9u2
ii libjpeg62-turbo 1:1.5.1-2
ii liblangtag1 0.6.2-1
ii liblcms2-2 2.8-4+deb9u1
ii libldap-2.4-2 2.4.44+dfsg-5+deb9u2
ii libmythes-1.2-0 2:1.2.4-3
ii libneon27-gnutls 0.30.2-2
ii libnspr4 2:4.12-6
ii libnss3 2:3.26.2-1.1+deb9u1
ii libodfgen-0.1-1 0.1.6-2
ii libpcre3 2:8.39-3
ii libpng16-16 1.6.28-1
ii librdf0 1.0.17-1.1
ii libreoffice-common 1:5.2.7-1+deb9u5
ii librevenge-0.0-0 0.0.4-6
ii libsm6 2:1.2.2-1+b3
ii libstdc++6 6.3.0-18+deb9u1
ii libx11-6 2:1.6.4-3+deb9u1
ii libxext6 2:1.3.3-1+b2
ii libxinerama1 2:1.1.3-1+b3
ii libxml2 2.9.4+dfsg1-2.2+deb9u2
ii libxrandr2 2:1.5.1-1
ii libxrender1 1:0.9.10-1
ii libxslt1.1 1.1.29-2.1
ii uno-libs3 5.2.7-1+deb9u5
ii ure 5.2.7-1+deb9u5
ii zlib1g 1:1.2.8.dfsg-5
Versions of packages libreoffice-core recommends:
ii libpaper-utils 1.1.24+nmu5
Versions of packages libreoffice-base is related to:
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
--- End Message ---
--- Begin Message ---
A response has been provided. No follow-up of the report by the applicant.
--
Stéphane Aulery
--- End Message ---
