John Seberg <johnseberg@xxxxxxxxx> writes: > I have bounced the db, made sure the processes and > files are owned by postgres. What else is there? > > COPY consult FROM > '/var/lib/pgsql/migrate/consult.txt'; This is probably a dumb question, but is 'migrate' owned and readable by 'postgres' as well? If that's not the problem, please post more info, including the error message you get in 'pqsl' and any relevant server log entries. -Doug ---------------------------(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