> The following bug has been logged online:
>=20
> Bug reference: 1456
> Logged by: Pascal Van Puymbroeck
> Email address: pascal.vanpuymbroeck@zenonproductions.be
> PostgreSQL version: 8.0.1
> Operating system: Windows 2000
> Description: COPY FROM error
> Details:=20
>=20
> The COPY table FROM command works fine as long as you use=20
> drives local to the machine like c: or e: , but when you try=20
> to use the command with a network drive mapped to o: for=20
> eaxmple, you get a 'could not open file for
> reading: invalid argument' error.
This is to be expected - the server runs with it's own user account, and
as such it won't have access to your profile with it's mapped drives.
Your solutions are:
*) Use an UNC mapped path (\\server\share\dir\file). This will require
either postgresql running as a domain account, or anonymous SMB (which
you *really* should have turned off)
*) use psql's \copy command. This one will write the file from the
client, and using your own windows account, so it shuold work fine with
mapped drives. This is what I'd recommend if you're doing one-off loads,
but it might be a bit trickier if you want it integrated in an app.
//Magnus