Thread: BUG #16228: Can connect, but cannot open or use tables in LibreOffice Base 6
BUG #16228: Can connect, but cannot open or use tables in LibreOffice Base 6
From
PG Bug reporting form
Date:
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)
Re: BUG #16228: Can connect, but cannot open or use tables in LibreOffice Base 6
From
Tom Lane
Date:
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:
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