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 1jMtuA-0008S5-TP for pgsql-bugs@arkaria.postgresql.org; Fri, 10 Apr 2020 13:41:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jMtu9-0001bb-IP for pgsql-bugs@arkaria.postgresql.org; Fri, 10 Apr 2020 13:41:09 +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 1jMtu9-0001bU-C8 for pgsql-bugs@lists.postgresql.org; Fri, 10 Apr 2020 13:41:09 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jMtu7-0005OA-9W for pgsql-bugs@postgresql.org; Fri, 10 Apr 2020 13:41:08 +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 03ADf5iT021605; Fri, 10 Apr 2020 09:41:05 -0400 From: Tom Lane To: ribal cc: pgsql-bugs@postgresql.org Subject: Re: pg_tables anomalies In-reply-to: <1586506892180-0.post@n3.nabble.com> References: <1586506892180-0.post@n3.nabble.com> Comments: In-reply-to ribal message dated "Fri, 10 Apr 2020 01:21:32 -0700" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <21603.1586526065.1@sss.pgh.pa.us> Date: Fri, 10 Apr 2020 09:41:05 -0400 Message-ID: <21604.1586526065@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ribal writes: > pgadmin deleted a table called m_rt_temp. > However, it is marked as still present in the catalog tree. I see no reason to think there is a bug here. I would bet on one of several types of user error: * Your discussion has not mentioned schemas. There might be more or less similarly named tables in different schemas, some of which are in your search_path and some of which aren't. * "_" is a wildcard in LIKE patterns, making it possible that those searches are matching more than you think they are. * Some of your queries appear to be searching for patterns with spaces in them. That's allowed in SQL identifiers, but you could not access such a table name without writing double quotes around it. But, since you have not shown the actual results of any of these queries, it's hard to tell exactly what the confusion is from. regards, tom lane