Re: Windows file path for copy

From: Richard Sydney-Smith <richard(at)ibisau(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Windows file path for copy
Date: 2005-08-03 16:09:57
Message-ID: 42F0EC55.9040401@ibisau.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Thanks. Can see the logic but many users are going to presume that they
can load from "their" desktop. For now I can operate around the issue
but will have to place instructions in big letters unless I want to
answer this adnauseum.<br>
<br>
<br>
Magnus Hagander wrote:
<blockquote
cite="mid6BCB9D8A16AC4241919521715F4D8BCE6C7804(at)algol(dot)sollentuna(dot)se"
type="cite">
<blockquote type="cite">
<pre wrap="">Windows XP SP2 with Postgresql 8.0.3
Two commands on fails the other succeeds:

Fails :

select import_sharedata('C:\\Documents and
Settings\\Richard\\Desktop\\EzyChart-20050721');

Succeeds:

select import_sharedata('C:\\EzyChart-20050721');

is it the spaces in the path that postgres does not like? If
so how do I format the enquiry pls?

Failure message indicates that It can not access the file.
However the file is downloaded to my destop and thus has been
created with my permissions.
</pre>
</blockquote>
<pre wrap=""><!---->
I assume import_sharedate() is a server-side function. In this case, the
*service account* needs permissions, not you. And don't grant it to your
desktop - that's generallyi a bad idea :-) Use a shared dir somewhere
that both you and the service accoutn has permissions on.

//Magnus

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to <a class="moz-txt-link-abbreviated" href="mailto:majordomo(at)postgresql(dot)org">majordomo(at)postgresql(dot)org</a> so that your
message can get through to the mailing list cleanly

</pre>
</blockquote>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 1.8 KB

In response to

Browse pgsql-general by date

  From Date Subject
Next Message marcelo Cortez 2005-08-03 16:30:49 postgresql.conf value need advice
Previous Message Edmund Dengler 2005-08-03 16:04:33 Re: Failure to use indexes (fwd)