Re: BUG #15244: Inherited table queries return null lines that do not exist - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #15244: Inherited table queries return null lines that do not exist
Date
Msg-id 6046.1529099870@sss.pgh.pa.us
Whole thread Raw
In response to BUG #15244: Inherited table queries return null lines that do notexist  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
=?utf-8?q?PG_Bug_reporting_form?= <noreply@postgresql.org> writes:
> I was working with table inheritance and started having problems with my
> queries.
> I noticed that every time I perform a query on a parent table of an
> inheritance and perform a query on any table then with more records than the
> preceding table, postgres returns me rows with all records in null that do
> not exist in the table that I'm consulting.

FWIW, I tried this case with 1000000 somewhat-random records per table,
and couldn't see any misbehavior.   I wonder how much is "many records"
for you.  Also, what client-side code are you using?  If it's not psql,
can you reproduce the problem in psql?

            regards, tom lane


pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15244: Inherited table queries return null lines that do notexist
Next
From: PG Bug reporting form
Date:
Subject: BUG #15245: pg_stat_all_tables does not include partition mastertables