[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

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: