| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Purusothaman A <purusothaman(dot)a(at)gmail(dot)com> |
| Cc: | "Milen A(dot) Radev" <milen(at)radev(dot)net>, pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] Problem with lo_export() and lo_import() from remote machine. |
| Date: | 2006-09-09 12:06:13 |
| Message-ID: | 20060909120613.GA10336@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
On Sat, Sep 09, 2006 at 05:19:26PM +0530, Purusothaman A wrote:
> I usually log in to postgresql server with admin username.
>
> But whatever its, according to documentation, if client machine's user has
> write access
> permission, this query should successfully be executed.
Read carefully, you are using the server-side functions, therefore:
"These two functions read and write files in the server's file system,
using the permissions of the database's owning user."
What your client user is is irrelevent. Perhaps you actually want to
use the client-side functions?
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike C | 2006-09-11 04:53:36 | SELECT and DATE Function question |
| Previous Message | Purusothaman A | 2006-09-09 11:49:26 | Re: Problem with lo_export() and lo_import() from remote machine. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Poul Jensen | 2006-09-09 12:09:43 | Re: ECPG - how to fetch then sort strings |
| Previous Message | Purusothaman A | 2006-09-09 11:49:26 | Re: Problem with lo_export() and lo_import() from remote machine. |