PG Seg Faults Performing a Query - Mailing list pgsql-general

From Bill Thoen
Subject PG Seg Faults Performing a Query
Date
Msg-id 46CB4CF0.6050902@gisnet.com
Whole thread Raw
Responses Re: PG Seg Faults Performing a Query  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Re: PG Seg Faults Performing a Query  ("Andrej Ricnik-Bay" <andrej.groups@gmail.com>)
List 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 by date:

Previous
From: Tony Caduto
Date:
Subject: Re: Need help doing a PostgreSQL vs Firebird feature comparison
Next
From: Steve Wampler
Date:
Subject: Re: Auto-partitioning?