From: | Bill Thoen <bthoen(at)gisnet(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | PG Seg Faults Performing a Query |
Date: | 2007-08-21 20:37:04 |
Message-ID: | 46CB4CF0.6050902@gisnet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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?
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Wampler | 2007-08-21 20:46:19 | Re: Auto-partitioning? |
Previous Message | Tony Caduto | 2007-08-21 19:51:15 | Re: Need help doing a PostgreSQL vs Firebird feature comparison |
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2007-08-21 21:38:42 | Re: PG Seg Faults Performing a Query |
Previous Message | Andrew Chernow | 2007-08-21 19:44:11 | PGparam extension version 0.4 |