"Glen W. Mabey" <[EMAIL PROTECTED]> writes: > When I SELECT any records from a certain table ("Acquisitions"), I get:
> acqlibdb=> select * from "Acquisitions"; > ERROR: relation "Acquisitions" does not exist > acqlibdb=> select * from public."Acquisitions"; > ERROR: relation "public.Acquisitions" does not exist Maybe it's not in the public schema but some other one (implying you forgot about a nondefault search_path setting). regards, tom lane ---------------------------(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