On 8/21/07, Bill Thoen <bthoen@xxxxxxxxxx> wrote:
> 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.
so the client psql is what's dieing right? In that case you likely
are getting too big a result set for psql to handle at once. Trying
declaring a cursor to hold your query and fetching 100 or 1000 or so
rows at a time.
Just guessing. What's the exact text of the error message?
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
