https://bugs.documentfoundation.org/show_bug.cgi?id=92538
Stéphane Aulery <lk...@free.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |lk...@free.fr
See Also| |http://bugs.debian.org/8081
| |25
--- Comment #4 from Stéphane Aulery <lk...@free.fr> ---
Confirmed with version 4.3.3 on Debian
-----------------------------------------------------------------------------
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
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
