COPY has no access permissions
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
Thanks, Mike! Your solution seems to have solved it.
--- mike <mike@thegodshalls.com> wrote:XP is denying access to your desktop to the postgres
account which the
database service is running on. If you go to the
folder C:\Document and
Settings\your_login_id, right click on it, select
security and
permissions, add the postgres account to it, then it
should work.Mike
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Import Notes
Reply to msg id not found: 1142186334.6784.3.camel@localhost.localdomain | Resolved by subject fallback