Обсуждение: 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

От
PG Bug reporting form
Дата:
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

От
Tom Lane
Дата:
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



Re: BUG #16228: Can connect, but cannot open or use tables inLibreOffice Base 6

От
Joe Tart
Дата:
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