Bug#808125: libreoffice-base: c/p from calc to create table, character_data does not exist on postgresql

[Rene Engelhard <rene@debian.org>]

Hi,

On Wed, Dec 16, 2015 at 10:59:16AM +0100, wim wrote:
> Setup:
> - base
> - postgresql backend
> - sdbc connection (jdbc will most likely have the same result)

Not sure, see below.

> Problem:
> - base takes a datatype character_data which doens't exist in postgresql, it should be varchar for example
> 
> Simulation:
[...]
> 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.

Sounds like https://bugs.documentfoundation.org/show_bug.cgi?id=92538?

Which suggests at least that it's definitely only PostgreSQL being affected
and that only with the "native" connection which might make it a bug of
libreoffice-sdbc-postgresql...

Regards,

Rene