pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: ribal <na97oribal@gmail.com>
Cc: pgsql-bugs@postgresql.org
Subject: Re: pg_tables anomalies
Date: Fri, 10 Apr 2020 09:41:05 -0400
Message-ID: <21604.1586526065@sss.pgh.pa.us> (raw)
In-Reply-To: <1586506892180-0.post@n3.nabble.com>
References: <1586506892180-0.post@n3.nabble.com>

ribal <na97oribal@gmail.com> 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





view thread (2+ messages)

Message-ID: <21604.1586526065@sss.pgh.pa.us>
Permalink:  ../21604.1586526065@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/21604.1586526065@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: tgl@sss.pgh.pa.us, na97oribal@gmail.com
  Subject: Re: pg_tables anomalies
  In-Reply-To: <21604.1586526065@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox