COPY has no access permissions

From: P G <pgress5(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: COPY has no access permissions
Date: 2006-03-12 17:03:21
Message-ID: 20060312170321.18735.qmail@web35411.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I found something interesting when I try to load a
text file into a
table. I am on Windows XP and I am using the Copy
command.

If the file is under C:\Documents And Settings or
anywhere under that
folder, the database complains that it has no access
permissions. (The
file is on my desktop.)

If I place the file anywhere else, it works fine and
it loads the file.

What do I need to do in order to get Postgres to load
the file?

Thanks!

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Browse pgsql-general by date

  From Date Subject
Next Message Thomas F. O'Connell 2006-03-12 20:43:15 Re: Autovacuum Daemon Disrupting dropdb?
Previous Message Ycrux 2006-03-12 11:47:31 Re: getting failed while creating user accounts