Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iv45R-0003dp-IN for pgsql-bugs@arkaria.postgresql.org; Fri, 24 Jan 2020 18:53:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iv45P-0000qO-79 for pgsql-bugs@arkaria.postgresql.org; Fri, 24 Jan 2020 18:53:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iv45O-0000qH-VC for pgsql-bugs@lists.postgresql.org; Fri, 24 Jan 2020 18:53:43 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1iv45M-0008L4-Cj for pgsql-bugs@lists.postgresql.org; Fri, 24 Jan 2020 18:53:42 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id 00OIraSW031618; Fri, 24 Jan 2020 13:53:36 -0500 From: Tom Lane To: joetod1692@gmail.com cc: pgsql-bugs@lists.postgresql.org Subject: Re: BUG #16228: Can connect, but cannot open or use tables in LibreOffice Base 6 In-reply-to: <16228-a0a9869efc10fd8d@postgresql.org> References: <16228-a0a9869efc10fd8d@postgresql.org> Comments: In-reply-to PG Bug reporting form message dated "Fri, 24 Jan 2020 18:44:55 +0000" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <31616.1579892016.1@sss.pgh.pa.us> Date: Fri, 24 Jan 2020 13:53:36 -0500 Message-ID: <31617.1579892016@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk PG Bug reporting form 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