[Libreoffice-bugs] [Bug 128488] New: sdbc postgresql stops working with postgresql 12 version

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=128488

            Bug ID: 128488
           Summary: sdbc postgresql stops working with postgresql 12
                    version
           Product: LibreOffice
           Version: unspecified
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kjonca at poczta.onet.pl

First of all I do not know if it is best place for this bug - but I have
nothing better.

By debian installation stops working with postgresql 12 version. A lot of
mysterious bug (table public.xxx does not exists and so on)

In postgres log I can see:
2019-10-31 05:19:16 CET LOG:  statement: SELECT pg_namespace.nspname,
pg_class.relname, pg_attribute.attname, pg_type.typname,
pg_attribute.atttypmod, pg_attribute.attnotnull, pg_type.typdefault,
pg_type.typtype, pg_attrdef.adsrc, pg_description.description,
pg_type.typbasetype, pg_attribute.attnum FROM pg_class, 
pg_attribute LEFT JOIN pg_attrdef ON pg_attribute.attrelid = pg_attrdef.adrelid
AND pg_attribute.attnum = pg_attrdef.adnum LEFT JOIN pg_description ON
pg_attribute.attrelid = pg_description.objoid AND
pg_attribute.attnum=pg_description.objsubid, pg_type, pg_namespace WHERE
pg_attribute.attrelid = pg_class.oid AND 
pg_attribute.atttypid = pg_type.oid AND pg_class.relnamespace =
pg_namespace.oid AND NOT pg_attribute.attisdropped AND pg_namespace.nspname
LIKE 'public' AND pg_class.relname LIKE 'przesylki' AND pg_attribute.attname
LIKE '%' ORDER BY pg_namespace.nspname, pg_class.relname, pg_attribute.attnum
2019-10-31 05:19:16 CET ERROR:  column pg_attrdef.adsrc does not exist at
character 173

according to postgres changelog - colum adsrc was removed and postgresql author
suggest using something like "pg_get_expr(pg_attrdef.adbin,pg_attrdef.adrelid)"

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191031/ed43581a/attachment.html>