Bug#857467: libreoffice-base: Postgresql — Cannot enter or edit data or edit table columns

[Rene Engelhard <rene@debian.org>]

Hi,

On Sat, Mar 11, 2017 at 06:28:44PM +0100, Axel wrote:
> opening a table for data editing (by pressing Enter or double-clicking &c.) only shows the
> column names in the header, otherwise the window is completely empty and all controls
> greyed out. If data are inserted using the commandline tool PSQL, they show up in LO but
> cannot be changed.
> 
> New tables can be created and new columns added but no attributes of existing columns can be changed.

Using what driver?

> Versions of packages libreoffice-base is related to:
> pn  libmyodbc                             <none>
> ii  libmysql-java                         5.1.39-1~deb8u1
> ii  libpostgresql-jdbc-java [libpg-java]  9.2-1002-1
> pn  libsapdbc-java                        <none>
> pn  libsqliteodbc                         <none>
> pn  mdbtools                              <none>
> pn  odbc-postgresql                       <none>
> pn  tdsodbc                               <none>
> pn  unixodbc                              <none>
>
> -- no debconf information>

suggests that you use libpostgresql-jdbc-java so JDBC.. Which is nowadays
not really the best solution, IMHO.

What if you would try with libreoffice-sdbc-postgresql which is a "native"
 PostgreSQL connector using postgresqls libraries.

Regards,

Rene