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 9769F9FB389 for ; Mon, 11 Sep 2006 10:30:12 -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 78528-06 for ; Mon, 11 Sep 2006 13:30:04 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.202]) by postgresql.org (Postfix) with ESMTP id 211C49FB318 for ; Mon, 11 Sep 2006 10:30:03 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id 14so458953nzn for ; Mon, 11 Sep 2006 06:30:00 -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=HJk5e59RboHAwMjiZp0PA1tThq+7YFzE+EsWtn+3gnUU4yesk/xxZF4N3vwRIs2oejab4F/VJkn8bofkiRPWP56jmuQV3HVzpKXXmBjJs/WmAZB5n8ijQWviiYY+UyIpHWFyVvscQapklypz7HESS4Jf8GldVBTLyLZUYL85aDo= Received: by 10.65.43.5 with SMTP id v5mr1645462qbj; Mon, 11 Sep 2006 06:30:00 -0700 (PDT) Received: by 10.65.192.4 with HTTP; Mon, 11 Sep 2006 06:30:00 -0700 (PDT) Message-ID: <3650d0d50609110630p7c0fa6dfsb9dbc995f4406680@mail.gmail.com> Date: Mon, 11 Sep 2006 19:00:00 +0530 From: "Purusothaman A" To: "Martijn van Oosterhout" , "Marco Bizzarri" , "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: <3f0d61c40609110356n53e6da12h26d54cb74f448263@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_135388_713532.1157981400525" References: <3650d0d50609090407j237bb710h9bde1675c773925d@mail.gmail.com> <3650d0d50609090449q2aec1098xc3b62dd169de5843@mail.gmail.com> <20060909120613.GA10336@svana.org> <3650d0d50609110215j7361bc2dj55e6d7d73af1d07d@mail.gmail.com> <20060911093819.GA15769@svana.org> <3650d0d50609110257m7b216b27nabb8ae87f7852e2@mail.gmail.com> <20060911100336.GB16564@svana.org> <3650d0d50609110315uff51429n48e038dc6b9a482e@mail.gmail.com> <3f0d61c40609110356n53e6da12h26d54cb74f448263@mail.gmail.com> 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/89 X-Sequence-Number: 23003 ------=_Part_135388_713532.1157981400525 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi Marco Bizzarri and Martijn van Oosterhout, Thanks for your valuable reply. I am trying to execute all query from VC++ through CDatabase::ExecuteSQL(sQueryString) function call. ie, via programming, not by manual entering query statements. so, in my situation I can construct a string and pass on to this function to execute the query string. Whatever the string I pass to ExecuteSQL() function, gets executed and I cannot get any result retured from the passed query string [like OID - 198705, from lo_create()]. Now, can you suggest me how to achieve it? And one more clarification, what is the value 131072? How can I get this vlaue? According to PostgreSQL documentation, they gave C Syntax as client side function. Should I use those C API calls? :) Purusothaman A On 9/11/06, Marco Bizzarri wrote: > > I will try to explain it with a sample session: this is for creating > and writing a blob. > > From the psql prompt (> are the commands, the other are the results). > > > begin ; > BEGIN; > > > SELECT lo_creat(131072) ; > lo_creat > ---------- > 198705 > (1 row) > (this is the OID number of the newly created large object). > > > select lo_open(198705, 131072) ; > lo_open > --------- > 0 > (1 row) > > (this is the file handler which you will use in the operations). > > > SELECT lowrite(0, 'aaaa'); > lowrite > --------- > 4 > (1 row) > > (you wrote 4 character in a large object) > > > select lo_close(0); > lo_close > ---------- > 0 > (1 row) > > (you closed the file). > > > commit ; > COMMIT > > In this way, you created a new large object, and stored a string of 4 > bytes inside of it. > > Regards > Marco > > On 9/11/06, Purusothaman A wrote: > > Thanks Martijn van Oosterhout and Marco Bizzarri. > > > > But, according to syntax of client side lo_import and lo_export, we > should > > have 2 variable PGconn (for esatablished connection) and lobjld > (imported > > file ID in PostgreSQL). > > > > I don't know how to do this in SQL statements. > > > > pls give me sample client side sql statements. > > > > :) > > Purusothaman A > > > > > > On 9/11/06, Martijn van Oosterhout wrote: > > > > > On Mon, Sep 11, 2006 at 03:27:09PM +0530, Purusothaman A wrote: > > > Thanks Martijn van Oosterhout, > > > > > > So, I have to write my own wrapper function upon the functions below. > > > 1. Oid lo_import(PGconn *conn, const char *filename); > > > 2. int lo_export(PGconn *conn, Oid lobjId, const char *filename); > > > > Not sure why you need a wrapper (you didn't say which language you were > > using) but those functions work exactly like the version you put in the > > SQL statements, except the filenames are for the client computer with > > client permissions. > > > > Hope this helps, > > -- > > 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) > > > > iD8DBQFFBTR4IB7bNG8LQkwRAvhPAJ9KHp9DO1EjPqbkGwBdaSaKx5J90wCfQtZ8 > > ijq1n/SgAlwIiEgDI6zfICg= > > =Xk7N > > -----END PGP SIGNATURE----- > > > > > > > > > > > -- > Marco Bizzarri > http://notenotturne.blogspot.com/ > ------=_Part_135388_713532.1157981400525 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi Marco Bizzarri and Martijn van Oosterhout,

Thanks for your valuable reply.

I am trying to execute all query from VC++ through CDatabase::ExecuteSQL(sQueryString) function call.

ie, via programming, not by manual entering query statements.
so, in my situation I can construct a string and pass on to this function to execute the query string.

Whatever the string I pass to ExecuteSQL() function, gets executed and I cannot get any result retured from the passed query string [like OID - 198705, from lo_create()].

Now, can you suggest me how to achieve it?

And one more clarification, what is the value 131072? How can I get this vlaue?

According to PostgreSQL documentation, they gave C Syntax as client side function.

Should I use those C API calls?

:)
Purusothaman A

On 9/11/06, Marco Bizzarri <marco.bizzarri@gmail.com > wrote:
I will try to explain it with a sample session: this is for creating
and writing a blob.

From the psql prompt (> are the commands, the other are the results).

> begin ;
BEGIN;

> SELECT lo_creat(131072) ;
lo_creat
----------
   198705
(1 row)
(this is the OID number of the newly created large object).

> select  lo_open(198705, 131072) ;
lo_open
---------
       0
(1 row)

(this is the file handler which you will use in the operations).

> SELECT lowrite(0, 'aaaa');
lowrite
---------
       4
(1 row)

(you wrote 4 character in a large object)

> select lo_close(0);
lo_close
----------
        0
(1 row)

(you closed the file).

> commit ;
COMMIT

In this way, you created a new large object, and stored a string of 4
bytes inside of it.

Regards
Marco

On 9/11/06, Purusothaman A < purusothaman.a@gmail.com> wrote:
> Thanks Martijn van Oosterhout and Marco Bizzarri.
>
> But, according to syntax of client side lo_import and lo_export, we should
> have 2 variable PGconn (for esatablished connection) and lobjld (imported
> file ID in PostgreSQL).
>
> I don't know how to do this in SQL statements.
>
> pls give me sample client side sql statements.
>
> :)
> Purusothaman A
>
>
> On 9/11/06, Martijn van Oosterhout < kleptog@svana.org> wrote:
> >
> On Mon, Sep 11, 2006 at 03:27:09PM +0530, Purusothaman A wrote:
> > Thanks Martijn van Oosterhout,
> >
> > So, I have to write my own wrapper function upon the functions below.
> >   1. Oid lo_import(PGconn *conn, const char *filename);
> >   2. int lo_export(PGconn *conn, Oid lobjId, const char *filename);
>
> Not sure why you need a wrapper (you didn't say which language you were
> using) but those functions work exactly like the version you put in the
> SQL statements, except the filenames are for the client computer with
> client permissions.
>
> Hope this helps,
> --
> 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)
>
> iD8DBQFFBTR4IB7bNG8LQkwRAvhPAJ9KHp9DO1EjPqbkGwBdaSaKx5J90wCfQtZ8
> ijq1n/SgAlwIiEgDI6zfICg=
> =Xk7N
> -----END PGP SIGNATURE-----
>
>
>
>


--
Marco Bizzarri
http://notenotturne.blogspot.com/

------=_Part_135388_713532.1157981400525--