BUG #16228: Can connect, but cannot open or use tables in LibreOffice Base 6
The following bug has been logged on the website:
Bug reference: 16228
Logged by: Joe Tart
Email address: joetod1692@gmail.com
PostgreSQL version: 12.1
Operating system: Windows 10 64bit
Description:
I can connect to Postgres 12 with Base, and the tables will show up in the
"tables" section, but when I click on the table to open it, the table
disappears. If I try to create a table from Base with the Wizard to store
in Postgres 12, I get an error message
"Error code: 1 pq_driver: [PGRES_FATAL_ERROR]ERROR: column pg_attrdef.adsrc
does not exist"
I have read that the driver was removed. Can someone look into it, please.
Thanks,
Joe (not a programmer)
PG Bug reporting form <noreply@postgresql.org> writes:
I can connect to Postgres 12 with Base, and the tables will show up in the
"tables" section, but when I click on the table to open it, the table
disappears. If I try to create a table from Base with the Wizard to store
in Postgres 12, I get an error message
"Error code: 1 pq_driver: [PGRES_FATAL_ERROR]ERROR: column pg_attrdef.adsrc
does not exist"
Evidently that driver needs some updates to work with Postgres 12.
(The system catalog pg_attrdef's adsrc column has been deprecated
for ages, and it finally went away in PG 12. If they're that much
behind the times, there may be other issues too.)
We can't really help you on this, you need to file a bug with
LibreOffice.
regards, tom lane
Ok, thanks.
On Fri, Jan 24, 2020 at 1:53 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Show quoted text
PG Bug reporting form <noreply@postgresql.org> writes:
I can connect to Postgres 12 with Base, and the tables will show up in
the
"tables" section, but when I click on the table to open it, the table
disappears. If I try to create a table from Base with the Wizard tostore
in Postgres 12, I get an error message
"Error code: 1 pq_driver: [PGRES_FATAL_ERROR]ERROR: column
pg_attrdef.adsrc
does not exist"
Evidently that driver needs some updates to work with Postgres 12.
(The system catalog pg_attrdef's adsrc column has been deprecated
for ages, and it finally went away in PG 12. If they're that much
behind the times, there may be other issues too.)We can't really help you on this, you need to file a bug with
LibreOffice.regards, tom lane