COPY permission problem - Windows XP

From: appa1(at)gmx(dot)de
To: pgadmin-support(at)postgresql(dot)org
Subject: COPY permission problem - Windows XP
Date: 2006-02-15 17:52:38
Message-ID: 15611.1140025958@www057.gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Whenever I try to perform a COPY command (even as superuser), I get the
following error message:

ERROR: could not open file "Z:\myfile.out" for reading: Permission denied

(the file is otherwise freely readable/writable to any user in Windows!)

I am using Perl-DBI Programs to access the database, and cannot just switch
to the "\copy" command since it is not supported using the Perl DBI database
driver (as far as I know).

The file I want to access has been generated with the same Perl Program just
before I try to copy it into the database...

(I am working with a Windows XP PSQL 8.1 installation.)

There's another posting like this in the Pgadmin support archives, but there
the issue has not been really solved. They just suggested to use the \copy
command instead, what is not possible for me!

--
10 GB Mailbox, 100 FreeSMS/Monat http://www.gmx.net/de/go/topmail
+++ GMX - die erste Adresse fr Mail, Message, More +++

Browse pgadmin-support by date

  From Date Subject
Next Message Poul Møller Hansen 2006-02-17 13:07:47 Scheduling jobs
Previous Message caoyu 2006-02-15 02:47:19 Is it possible to automatically generate sql queries according to DB stored in Psql