X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 208C7DAE36 for ; Tue, 25 Oct 2005 16:57:57 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 01112-04 for ; Tue, 25 Oct 2005 19:57:52 +0000 (GMT) Received: from smtp-one-1.wash.one.se (smtp-one-1.one.se [213.80.101.15]) by svr1.postgresql.org (Postfix) with ESMTP id 54ED7DAE34 for ; Tue, 25 Oct 2005 16:57:53 -0300 (ADT) Received: from localhost (smtp-one-1.local [127.0.0.1]) by re-injector1.wash.one.se (Postfix) with ESMTP id 7E00E26DA6 for ; Tue, 25 Oct 2005 21:57:53 +0200 (CEST) Received: from smtp-one-1.wash.one.se ([127.0.0.1]) by localhost (smtp-one-1.wash.one.se [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 48444-04 for ; Tue, 25 Oct 2005 21:57:51 +0200 (CEST) Received: from [192.168.0.100] (STH-10-NAT-212.116.78.2-CUST-BRFFARMEN-CPE.globecom.net [212.116.78.2]) by smtp-one-1.wash.one.se (Postfix) with ESMTP id 6F987268FA for ; Tue, 25 Oct 2005 21:57:51 +0200 (CEST) Mime-Version: 1.0 (Apple Message framework v623) Content-Transfer-Encoding: 7bit Message-Id: Content-Type: text/plain; charset=US-ASCII; format=flowed To: From: reiner peterke Subject: copy error Date: Tue, 25 Oct 2005 21:57:50 +0200 X-Mailer: Apple Mail (2.623) X-Virus-Scanned: by amavisd-new at one.se (smtp-one-1) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 required=5 tests=[FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200510/44 X-Sequence-Number: 3312 either i'm trying to hard or something is wrong here. i have 2 postgres installations one at work 8.0.4 on windows xp and one at home on os x 10.3.9 and postgres 8.0.3. i took a data file and loaded into the installation at work with the copy command. but when i try the same thing here on my os x installation i get the following error. ERROR: could not open file "data/pg_nor.out" for reading: No such file or directory the command i run is copy mig_equip from 'data/pg_nor.out' using delimiters '|' with null as ''; the command i used at work was copy mig_equip from 'c:/tmp/pg_nor.out' using delimiters '|' with null as ''; the only difference being the location of the file. i've tried changing the location, ran with the full path, did chmod on the file, ran dos2unix to make sure that the was not a problem with the file format. so i'm stumped. i'm afraid i'm missing something obvious but i can't figure it out. any ideas? thanks. reiner