PG crash on simple query

Поиск
Список
Период
Сортировка
От Maksim Likharev
Тема PG crash on simple query
Дата
Msg-id 56510AAEF435D240958D1CE8C6B1770A016D2D74@mailc03.aurigin.com
обсуждение исходный текст
Ответы Re: PG crash on simple query  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi,
I have consistent PG crash on some query,
so I was able to isolate a simple query that crash postgres...

SELECT p.docid FROM prod.t_documents AS p
INNER JOIN t_tempdocs AS t
    ON p.docid = t.docid
        LEFT OUTER JOIN prod.t_refs AS ct
            ON ct.docid = p.docid;

It seems like any reference to prod.t_refs lead to that.

We run PG 7.3 on SunOS

Is there any particular steps to follow in order to resolve this.
Thank you.

В списке pgsql-general по дате отправления:

Предыдущее
От: Toni Schlichting
Дата:
Сообщение: Re: How many fields in a table are too many
Следующее
От: Shridhar Daithankar
Дата:
Сообщение: Re: [HACKERS] Physical Database Configuration