Package: libreoffice-base Version: 1:4.3.3-2+deb8u2 Severity: normal Hallo,
Setup: - base - postgresql backend - sdbc connection (jdbc will most likely have the same result) Problem: - base takes a datatype character_data which doens't exist in postgresql, it should be varchar for example Simulation: 1. Take a table in calc (spreatsheet) with some columns of different structure (eg int, float, string, date) 2. copy the table from calc 3. paste it in base, table section, in a writable schema (a connection to a postgresql instance was already setup) 4. a nice wizard will popup 5. at one point in the wizard the datatypes have to be setup, u can auto, or just leave it as it is, 6. this is where the problem occurs, the default datatype for text is character_data which does not exist in postgresql or (the ISO standard?) 7. a good default would be character varying(n) (ISO standard) or varchar(n) (an alias) At this point the only workaround is to manually change the datatypes that don't match or exist. This could apply to other databases as well. hth, Wim -- System Information: Debian Release: 8.2 APT prefers stable-updates APT policy: (500, 'stable-updates'), (500, 'stable') Architecture: amd64 (x86_64) Kernel: Linux 3.16.0-4-amd64 (SMP w/8 CPU cores) Locale: LANG=nl_BE.utf8, LC_CTYPE=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 libc6 2.19-18+deb8u1 ii libgcc1 1:4.9.2-10 ii libreoffice-base-core 1:4.3.3-2+deb8u2 ii libreoffice-base-drivers 1:4.3.3-2+deb8u2 ii libreoffice-core 1:4.3.3-2+deb8u2 ii libstdc++6 4.9.2-10 ii uno-libs3 4.3.3-2+deb8u2 ii ure 4.3.3-2+deb8u2 Versions of packages libreoffice-base recommends: ii default-jre [java5-runtime] 2:1.7-52 ii libreoffice-java-common 1:4.3.3-2+deb8u2 ii libreoffice-writer 1:4.3.3-2+deb8u2 ii openjdk-7-jre [java5-runtime] 7u91-2.6.3-1~deb8u1 Versions of packages libreoffice-base suggests: pn libreoffice-gcj <none> ii libreoffice-report-builder 1:4.3.3-2+deb8u2 pn unixodbc <none> Versions of packages libreoffice-core depends on: ii fontconfig 2.11.0-6.3 ii fonts-opensymbol 2:102.6+LibO4.3.3-2+deb8u2 ii libatk1.0-0 2.14.0-1 ii libboost-date-time1.55.0 1.55.0+dfsg-3 ii libc6 2.19-18+deb8u1 ii libcairo2 1.14.0-2.1 ii libclucene-contribs1 2.3.3.4-4 ii libclucene-core1 2.3.3.4-4 ii libcmis-0.4-4 0.4.1-7 ii libcups2 1.7.5-11+deb8u1 ii libcurl3-gnutls 7.38.0-4+deb8u2 ii libdbus-1-3 1.8.20-0+deb8u1 ii libdbus-glib-1-2 0.102-1 ii libeot0 0.01-3 ii libexpat1 2.1.0-6+deb8u1 ii libexttextcat-2.0-0 3.4.4-1 ii libfontconfig1 2.11.0-6.3 ii libfreetype6 2.5.2-3+deb8u1 ii libgcc1 1:4.9.2-10 ii libgdk-pixbuf2.0-0 2.31.1-2+deb8u3 ii libgl1-mesa-glx [libgl1] 10.3.2-1+deb8u1 ii libglew1.10 1.10.0-3 ii libglib2.0-0 2.42.1-1 ii libgltf-0.0-0 0.0.2-2 ii libglu1-mesa [libglu1] 9.0.0-2 ii libgraphite2-3 1.2.4-3 ii libgtk2.0-0 2.24.25-3 ii libharfbuzz-icu0 0.9.35-2 ii libharfbuzz0b 0.9.35-2 ii libhunspell-1.3-0 1.3.3-3 ii libhyphen0 2.8.8-1 ii libice6 2:1.0.9-1+b1 ii libicu52 52.1-8+deb8u3 ii libjpeg62-turbo 1:1.3.1-12 ii liblangtag1 0.5.1-3 ii liblcms2-2 2.6-3+b3 ii libldap-2.4-2 2.4.40+dfsg-1+deb8u1 ii libmythes-1.2-0 2:1.2.4-1 ii libneon27-gnutls 0.30.1-1 ii libnspr4 2:4.10.7-1+deb8u1 ii libnss3 2:3.17.2-1.1+deb8u2 ii libodfgen-0.1-1 0.1.1-2 ii libpango-1.0-0 1.36.8-3 ii libpangocairo-1.0-0 1.36.8-3 ii libpangoft2-1.0-0 1.36.8-3 ii libpng12-0 1.2.50-2+deb8u1 ii librdf0 1.0.17-1+b1 ii libreoffice-common 1:4.3.3-2+deb8u2 ii librevenge-0.0-0 0.0.1-3 ii libsm6 2:1.2.2-1+b1 ii libssl1.0.0 1.0.1k-3+deb8u2 ii libstdc++6 4.9.2-10 ii libx11-6 2:1.6.2-3 ii libxext6 2:1.3.3-1 ii libxinerama1 2:1.1.3-1+b1 ii libxml2 2.9.1+dfsg1-5 ii libxrandr2 2:1.4.2-1+b1 ii libxrender1 1:0.9.8-1+b1 ii libxslt1.1 1.1.28-2+b2 ii libxt6 1:1.1.4-1+b1 ii uno-libs3 4.3.3-2+deb8u2 ii ure 4.3.3-2+deb8u2 ii zlib1g 1:1.2.8.dfsg-2+b1 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
