Windows file path for copy
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.
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.
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
Import Notes
Resolved by subject fallback
<!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@algol.sollentuna.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@postgresql.org">majordomo@postgresql.org</a> so that your
message can get through to the mailing list cleanly
</pre>
</blockquote>
</body>
</html>
Where does import_sharedata() come from? AFAIK, it's not a part of
standard PostgreSQL. PostgreSQL functions for this is COPY, where just
this fact is documented at
http://www.postgresql.org/docs/8.0/static/sql-copy.html, under "Notes".
//Magnus
Show quoted text
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of
Richard Sydney-Smith
Sent: Wednesday, August 03, 2005 6:10 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Windows file path for copyThanks. 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.Magnus Hagander wrote:
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.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
majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
Import Notes
Resolved by subject fallback