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

Reply via email to