#1072152 libreoffice-base: Copy/Paste calc>base fails on external postgres when used to specific schema on database

Package:
libreoffice-base
Source:
libreoffice-base
Description:
office productivity suite -- database
Submitter:
wim
Date:
2024-05-29 10:21:04 UTC
Severity:
normal
#1072152#5
Date:
2024-05-29 10:20:14 UTC
From:
To:
Hello,

this bug has been present for quiet a while in my experience.

An example on how to reproduce:
1. create a small simple table in calc, eg a 2c by 4r table with a header (eg id, value with some rows)
2. connect to a postgres database with multiple schemas as a regular user userx (non superuser) (eg the schema schema1, schema2, schema3 exist) (using the built in external options
3. copy the small table from calc
4. paste it into a non default schema, like schema1
5. go through the popup menu and make the table
6. an exception will be thrown that the schema userx does not exist, even though you pasting to schema1

Designing a table does not have this issue.

I know this is not the latest version, but this is a bug that has existed for some years now, i don't think it fixed in more recent versions.

hth,
Wim