Bug#808125: libreoffice-base: c/p from calc to create table, character_data does not exist on postgresql
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
Reply to: