=?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