Re: [SQL] i am getting error when i am using copy command

2006-05-09 Thread gourish singbal
  Penchal,     Is /tmp folder present and is the postgres user having read/write file permissions in /tmp folder. I was successfully able to copy a table to a file in /tmp folder on my machine .   Regards,Gourish SingbalSoftware EngineerZEDO Inc - Customer-Fit Ad Serving Worldwide.[EMAIL PROT

Re: [SQL] i am getting error when i am using copy command

2006-05-03 Thread Ben K.
file '/tmp/penchal.out' for writing: no such file or directory.. _IF_ you're on linux it could be due to selinux. setenforce 0 might solve the problem tempoarily. I would assume there should've been some existing discussion threads. (setenforce 1 afterwards.) Regards, Ben K. -

Re: [SQL] i am getting error when i am using copy command

2006-05-03 Thread Andrew Sullivan
On Wed, May 03, 2006 at 10:02:37AM +0200, Markus Schaber wrote: > > file ?/tmp/penchal.out? for writing: no such file or directory.. > > It seems that the /tmp directory is missing from your system. Right. And notice that the "your system" here is the _server_, not the machine you're running p

Re: [SQL] i am getting error when i am using copy command

2006-05-03 Thread Markus Schaber
Hi, Penchalaiah, Penchalaiah P. wrote: > Copy penchal to ‘/tmp/penchal.out’ > > When I am using this statement I am getting error is : could not open > file ‘/tmp/penchal.out’ for writing: no such file or directory.. It seems that the /tmp directory is missing from your system. This can hav