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@xxxxxxxxxxxxxx > [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of > Richard Sydney-Smith > Sent: Wednesday, August 03, 2005 6:10 PM > To: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: 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@xxxxxxxxxxxxxx so that your > message can get through to the mailing list cleanly > > > > > > > ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
