Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qJwh2-0005E4-Sx for pgsql-general@arkaria.postgresql.org; Thu, 13 Jul 2023 13:49:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qJwh1-00043R-Lw for pgsql-general@arkaria.postgresql.org; Thu, 13 Jul 2023 13:49:15 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qJwh1-00043I-AW for pgsql-general@lists.postgresql.org; Thu, 13 Jul 2023 13:49:15 +0000 Received: from ci74p00im-qukt09082301.me.com ([17.57.156.12]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qJwgt-000CD2-HU for pgsql-general@lists.postgresql.org; Thu, 13 Jul 2023 13:49:14 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mac.com; s=1a1hai; t=1689256146; bh=Sk41FM5QJg8oskm3J5mJvKgpiPiEjQuE+54iWuNc1Cc=; h=Content-Type:Mime-Version:Subject:From:Date:Message-Id:To; b=ObVjhlXWOHeHmnbJ7lGqvZPa4AdzP2J9FNLs0I5YMdN8/qjj3q15ejHG9MZRHaIEA 7O7HHm2Vo8a6bOpVyR+sG83LL1+ZD68Kofl2W3xed00Hx1/oBGTr+DnTymAiGEGd55 LSBh2YvEr8EAgPkAZawIz1mWRwnU+Xm3o0IZpu71cCrA+tTUgbyjyN0JCHwuA8n4tk iTJdlCM702x1YEuu1gZ5udFyjPn0Qcci07T6ksrT3U7fCk76jcGFSV/nQcdLwouznf ZPL0UC6sj2TYTp6TE0IKi2LsYRasG4oIuk4nOQ43GDWXZTqBHCkJVoCp3r3S4mVWcU dXE6dVFt4LgPg== Received: from smtpclient.apple (ci77p00im-dlb-asmtp-mailmevip.me.com [17.57.156.26]) by ci74p00im-qukt09082301.me.com (Postfix) with ESMTPSA id 966B3F80141; Thu, 13 Jul 2023 13:49:05 +0000 (UTC) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3731.600.7\)) Subject: Re: Problem perhaps after upgrading to pgadmin4 7.4 From: Carl Erik Eriksson In-Reply-To: Date: Thu, 13 Jul 2023 15:48:53 +0200 Cc: pgsql-general@lists.postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: <2E38536D-14A0-4459-A60B-FAEB5FF184CF@mac.com> References: <71E975C3-68C5-4CB7-9666-7C23C73BB98F@mac.com> To: depesz@depesz.com X-Mailer: Apple Mail (2.3731.600.7) X-Proofpoint-GUID: YkoUSCjw7_0a1f98zCqcMcvv9wP_kZtp X-Proofpoint-ORIG-GUID: YkoUSCjw7_0a1f98zCqcMcvv9wP_kZtp X-Proofpoint-Virus-Version: =?UTF-8?Q?vendor=3Dfsecure_engine=3D1.1.170-22c6f66c430a71ce266a39bfe25bc?= =?UTF-8?Q?2903e8d5c8f:6.0.138,18.0.790,17.11.62.513.0000000_definitions?= =?UTF-8?Q?=3D2022-01-12=5F03:2020-02-14=5F02,2022-01-12=5F03,2021-12-02?= =?UTF-8?Q?=5F01_signatures=3D0?= X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 clxscore=1015 spamscore=0 phishscore=0 malwarescore=0 mlxlogscore=948 bulkscore=0 adultscore=0 mlxscore=0 suspectscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.12.0-2212070000 definitions=main-2307130120 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Problem solved - thanks Depez! (The solution for now is to downgrade to = PGadmin4 version 7.2) > On 13 Jul 2023, at 13:52, hubert depesz lubaczewski = wrote: >=20 > On Thu, Jul 13, 2023 at 01:20:03PM +0200, Carl Erik Eriksson wrote: >> If I enter a query like select count(*) from table_1 I get a = correct response from the server >> If I enter select * from table_1 I get an error message that I do not = understand: >> Error Message:missing FROM-clause entry for table "rel" >> LINE 8: ...ER JOIN pg_catalog.pg_constraint con ON = con.conrelid=3Drel.oid >> PSQL tool (PGadmin on my Mac) >> However if I enter the same from the PSQL tool I get the correct = output. >>=20 >> But that output goes to my screen and I have found no way of = directing it to a file on my Mac. >>=20 >> Any suggestions? Either getting rid of the error message and getting = the output to my screen within the Query tool where I can then dump the = output to a file >> OR a way of running my query using the PSQL tool and redirecting the = output to a file on my computer. >>=20 >> An amateur who is up a creek without any paddle.. >=20 > Which pg version you're on? >=20 > Generally, try updating to newest pgadmin, from git repo > (https://github.com/pgadmin-org/pgadmin4/), there is/was a bug that > caused problems when using pg < 11 : > = https://github.com/pgadmin-org/pgadmin4/commit/732bcc2b4d91f0126cf69d69c14= df199bc4106bc >=20 > Best regards, >=20 > depesz >=20