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
