Re: COPY permissions problem - Windows XP - Mailing list pgadmin-support

From john.rylander@gmail.com
Subject Re: COPY permissions problem - Windows XP
Date
Msg-id 1136319157.935268.49360@o13g2000cwo.googlegroups.com
Whole thread Raw
In response to Re: COPY permissions problem - Windows XP  (john.rylander@gmail.com)
List pgadmin-support
BTW, copying the relevant CSV file to the "My Documents" folder of the
"postgres" user did not make things work with pgAdmin III Query
(1.4.1)--same permissions problem as noted in the original message:

ERROR:  could not open file "C:\Documents and Settings\postgres\My
Documents\Cumulative.csv" for reading: Permission denied

This is working as designed, I guess, but it's not well documented for
us poor Windows-using PostgresQL newbies (and the psql workaround is
effective, but, from GUI perspective, rather clumsy).  For those
Windows users importing data from other local sources, I fear this will
be an (at least temporary) unexpected showstopper every time.  (But
perhaps such users make only an insignificant percentage of the
intended audience.)



pgadmin-support by date:

Previous
From: john.rylander@gmail.com
Date:
Subject: Re: COPY permissions problem - Windows XP
Next
From: Roberto Tagliaferri
Date:
Subject: Re: 1.4.1 missing feature?