X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id A6A479FB389 for ; Mon, 11 Sep 2006 06:15:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 10094-02 for ; Mon, 11 Sep 2006 09:15:11 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.198]) by postgresql.org (Postfix) with ESMTP id 970CA9FB209 for ; Mon, 11 Sep 2006 06:15:11 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id 14so425119nzn for ; Mon, 11 Sep 2006 02:15:10 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=bMGmCYcVylxQNES4PmpuxT/KoIwnrCgIRVNJBQosxZvqpZvWLScdr81aJBGTZiYxF0rqz+mFV7QZoRcfB9pRXwsMOKVf9f7U5jKvFtIVY2EuEsUL4lne3JYGqQ00Uq3yL+OZ8/4vKmEJeY1N4+JNV5KaqwZkeVNaFNGaZrs+v3M= Received: by 10.65.219.4 with SMTP id w4mr1560345qbq; Mon, 11 Sep 2006 02:15:10 -0700 (PDT) Received: by 10.65.192.4 with HTTP; Mon, 11 Sep 2006 02:15:10 -0700 (PDT) Message-ID: <3650d0d50609110215j7361bc2dj55e6d7d73af1d07d@mail.gmail.com> Date: Mon, 11 Sep 2006 14:45:10 +0530 From: "Purusothaman A" To: "Martijn van Oosterhout" , "Purusothaman A" , "Milen A. Radev" , pgsql-admin@postgresql.org, pgsql-general@postgresql.org Subject: Re: [GENERAL] Problem with lo_export() and lo_import() from remote machine. In-Reply-To: <20060909120613.GA10336@svana.org> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_132461_8061803.1157966110161" References: <3650d0d50609090407j237bb710h9bde1675c773925d@mail.gmail.com> <3650d0d50609090449q2aec1098xc3b62dd169de5843@mail.gmail.com> <20060909120613.GA10336@svana.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.2 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/81 X-Sequence-Number: 22995 ------=_Part_132461_8061803.1157966110161 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi Martijn van Oosterhout, Thanks for your valuable reply. Yes I misunderstood the documentation. Then, I searched PostgreSQL documentation for equivalent client-side functions. But I found only C programming APIs instead of SQL functions. I want functions which is usable in SQL statements. Can you give example or equivalent client side function syntax? Thanks in advance. :) Purusothaman A On 9/9/06, Martijn van Oosterhout wrote: > > 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 http://svana.org/kleptog/ > > From each according to his ability. To each according to his ability to > litigate. > > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.1 (GNU/Linux) > > iD8DBQFFAq41IB7bNG8LQkwRAsptAKCDSWuRI5T+JMqpWEQt7r69kJE6CwCfVTOO > mOqGDNQBTZZDs4WVf6NM+wQ= > =kT4s > -----END PGP SIGNATURE----- > > > ------=_Part_132461_8061803.1157966110161 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi Martijn van Oosterhout,

Thanks for your valuable reply.

Yes I misunderstood the documentation.

Then, I searched PostgreSQL documentation for equivalent client-side functions.
But I found only C programming APIs instead of SQL functions.

I want functions which is usable in SQL statements.

Can you give example or equivalent client side function syntax?

Thanks in advance.

:)
Purusothaman A




On 9/9/06, Martijn van Oosterhout <kleptog@svana.org> wrote:
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@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFFAq41IB7bNG8LQkwRAsptAKCDSWuRI5T+JMqpWEQt7r69kJE6CwCfVTOO
mOqGDNQBTZZDs4WVf6NM+wQ=
=kT4s
-----END PGP SIGNATURE-----



------=_Part_132461_8061803.1157966110161--