Bug 129649 - LibreOffice 6.3.4.2 and 6.3.3.2 (x64) Base ODBC queries do not work with PostgreSQL 12.1
Summary: LibreOffice 6.3.4.2 and 6.3.3.2 (x64) Base ODBC queries do not work with Post...
Status: RESOLVED NOTOURBUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.3.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: haveBacktrace
Depends on:
Blocks:
 
Reported: 2019-12-27 13:14 UTC by Matti Linnanvuori
Modified: 2020-01-07 14:39 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Backtrace (28.00 KB, text/rtf)
2019-12-30 08:07 UTC, Matti Linnanvuori 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Matti Linnanvuori 2019-12-27 13:14:17 UTC 
LibreOffice 6.3.4.2 and 6.3.3.2 (x64) Base on Windows 10 Pro 1909 ODBC queries do not work with PostgreSQL 12.1 on Red Hat Enterprise Linux 7.7 and 8.1. Often I get the following error: The data content could not be loaded. Invalid column number in ColAttributes. or Base crashes. I am using the following driver: psqlodbc_12_00_0000-x64.zip from https://www.postgresql.org/ftp/odbc/versions/msi/

https://ask.libreoffice.org/en/question/220947/libreoffice-6332-x64-base-odbc-queries-do-not-work-with-postgresql-121/
Comment 1 Julien Nabet 2019-12-27 19:52:35 UTC 
Would it be possible you retrieve a backtrace (see https://wiki.documentfoundation.org/QA/BugReport/Debug_Information#Windows:_How_to_get_a_backtrace)?
Comment 2 Matti Linnanvuori 2019-12-30 08:07:59 UTC 
Created attachment 156843 [details]
Backtrace
Comment 3 Julien Nabet 2019-12-30 08:46:23 UTC 
Thank you for your feedback.
Does it happen too when you use Postgres native connection from LO?
I mean, taking a look at the bt, difficult to tell if it's due to LO or Postgres ODBC driver.
Comment 4 Matti Linnanvuori 2019-12-30 09:01:22 UTC 
The error does not happen when I use Postgres native connection from LO.
Comment 5 Julien Nabet 2019-12-30 09:05:08 UTC 
Ok then.
I don't have more questions and since I don't know what to do then, uncc myself.
Comment 6 Matti Linnanvuori 2020-01-07 14:39:57 UTC 
Fixed with psqlODBC 12.01.0000.