Обсуждение: 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

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.


Magnus Hagander wrote:
<blockquote
 cite="mid6BCB9D8A16AC4241919521715F4D8BCE6C7804@algol.sollentuna.se"
 type="cite">

    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

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

> -----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 copy
>
> 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.
>
>
> 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
>
>
>
>
>
>
>