PG Seg Faults Performing a Query

Поиск
Список
Период
Сортировка
От Bill Thoen
Тема PG Seg Faults Performing a Query
Дата
Msg-id 46CB4CF0.6050902@gisnet.com
обсуждение исходный текст
Ответы Re: PG Seg Faults Performing a Query
Re: PG Seg Faults Performing a Query
Список pgsql-general
How would you suggest I try to track down this problem?
I run the following query:

SELECT a.* FROM compliance_2006 a, ers_regions b
  WHERE a.fips_st_cd=b.fips_st
    AND a.fips_cnty_cd=b.fips_cou AND b.region =1
    AND a.fips_st_cd='17' AND a.fips_cnty_cd='003';

and it works. But when I try this:

SELECT a.* FROM compliance_2006 a, ers_regions b
  WHERE a.fips_st_cd=b.fips_st
    AND a.fips_cnty_cd=b.fips_cou AND b.region =1
    AND a.fips_st_cd='17' ;

psql dies with the message:
Segmentation Fault.

Any suggestions?


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

Предыдущее
От: Tony Caduto
Дата:
Сообщение: Re: Need help doing a PostgreSQL vs Firebird feature comparison
Следующее
От: Steve Wampler
Дата:
Сообщение: Re: Auto-partitioning?