Paul Tomblin <ptomblin@xcski.com> writes:
> Oh, and if I try and cast them both to varchar, the thing freaks out:
> waypoint=> select b.id, a.icao,a.faa_host_id from dafif_arpt a, waypoint b
> where b.id::varchar = a.icao::varchar;
> pqReadData() -- backend closed the channel unexpectedly.
> This probably means the backend terminated abnormally
> before or while processing the request.
What in the world...!?
What version are you running? What is the full schema for both tables?
("pg_dump -s -t tablename dbname" is the best way to get the complete
schema info.)
regards, tom lane