Base Cannot use tables from Postgres 12

jtart2 · January 23, 2020, 7:39pm

I’m using Libreoffice Base 6. I’ve downloaded Postgres 12 and created some tables.
I can connect to the Postgres tables with Base, but if I try to open the table, it disappears. (?)
If I try to create a table with Base, I get an error message that pg_attrdef.adsrc is absent and it cannot be created.

I’ve read on the web that is was removed for this version of Postgress 12.

Is there a work around, or do I need to switch to an older version of Postgress? If so, which works best with Base?

Thanks,
Joe

Ratslinger · January 23, 2020, 9:20pm

Hello,

You haven’t provided much information in your question. My main PostgreSQL installation is v10.x on an Ubuntu 18.04 Mate system. So in order not to cause problems there, moved to another system.

On Mint 19.2 Cinnamon installed PostgreSQL v12.1. Using pgAdmin4 created and restored an existing database.

Have LO v6.2.8.2 installed. Using the SDBC connection (native connector) I get the same problem you have displayed. Changing to a JDBC connector (used postgresql-42.2.9.jar from → PostgreSQL JDBC Download ) there was no problem with creating/reading/writing to tables. Was able to create view also.

jtart2 · January 24, 2020, 7:05pm

Using Windows 10 64 bit.
I downloaded the driver to my “Downloads” file. Not sure what I’m supposed to do with it next.
When connecting to Postgres with Base, it asks for the Java Class. Not sure what to type in that box. Tried different things, but obviously not correctly. Thanks for any additional input.

By the way, does anyone know if Postgres 11 contains the missing driver for Base?

Ratslinger · January 24, 2020, 7:50pm

For JDBC, the .jar file must be inserted into the Class Path. Tools >Options > LibreOffice > Advanced > ClassPath >Add Archive.

Then on connection settings, JDBC driver class = org.postgresql.Driver; Datasource URL = postgresql://localhost:5432/NAME_OF_YOUR_DB

"missing driver’ is vague at best. If referring to SDBC (native) connector, then I got mine through Synaptic Package Manager (on my Linux Ubuntu system) - libobasis6.3-postgresql-sdbc

jtart2 · January 28, 2020, 3:15pm

Thanks a lot, Ratslinger. After fooling around with the information you provided, it’s finally working!

jtart2 · January 31, 2020, 7:22pm

I’ve tried this on a 32 Bit Windows 10 machine and it can’t find the driver. I downloaded the 32 bit Java Version for the computer. Not sure if this is a 32 bit vs 64 bit problem, or a computer problem?