Re: BUG #15244: Inherited table queries return null lines that do not exist

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #15244: Inherited table queries return null lines that do not exist
Дата
Msg-id 6046.1529099870@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #15244: Inherited table queries return null lines that do notexist  (PG Bug reporting form <noreply@postgresql.org>)
Список 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 по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15244: Inherited table queries return null lines that do notexist
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15245: pg_stat_all_tables does not include partition mastertables