From sandhyar@amiindia.co.in Thu Jan  19 07:02:57 2006
X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 09F509DCA32
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Thu, 19 Jan 2006 03:02:57 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 49293-06
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Thu, 19 Jan 2006 03:02:56 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from venus.amiindia.co.in (unknown [203.199.198.234])
	by postgresql.org (Postfix) with ESMTP id 8C6539DC9C1
	for <pgsql-admin@postgresql.org>; Thu, 19 Jan 2006 03:02:52 -0400 (AST)
Received: from venus.amiindia.co.in (localhost.localdomain [127.0.0.1])
	by venus.amiindia.co.in (8.12.11/8.12.11) with ESMTP id k0J6vt0B019542
	for <pgsql-admin@postgresql.org>; Thu, 19 Jan 2006 12:27:55 +0530
Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in
	(Postfix) with ESMTP id 95A8E33266Afor <pgsql-admin@postgresql.org>;
	Thu, 19 Jan 2006 12:27:54 +0530 (IST)
Message-ID: <00c801c61cc6$e104d350$cd00000a@sandhyar>
From: "sandhya" <sandhyar@amiindia.co.in>
To: "Postgres" <pgsql-admin@postgresql.org>
Subject: lo_import
Date: Thu, 19 Jan 2006 12:36:32 +0530
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_00C5_01C61CF4.FA6C0920"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-imss-version: 2.5
X-imss-result: Passed
X-imss-scores: Clean:76.23421 C:21 M:1 S:5 R:5
X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.7500)
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.07 required=5 tests=[AWL=0.068, HTML_MESSAGE=0.001,
	UNPARSEABLE_RELAY=0.001]
X-Spam-Score: 0.07
X-Spam-Level: 
X-Archive-Number: 200601/208
X-Sequence-Number: 20296

This is a multi-part message in MIME format.

------=_NextPart_000_00C5_01C61CF4.FA6C0920
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

When i am using lo_import to load files into the database i am getting =
the following error.....
Please help me what i need to do

ERROR:  function lo_import ("unknown") does not exist
HINT:  No function matches the given name and argument types. You may =
need to ad
d explicit type casts.
------=_NextPart_000_00C5_01C61CF4.FA6C0920
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>When i am using lo_import to load files into the =
database i am=20
getting the following error.....</FONT></DIV>
<DIV><FONT size=3D2>Please help me what i need to do</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=3D2>ERROR:&nbsp; function lo_import&nbsp;("unknown") =
does not=20
exist<BR>HINT:&nbsp; No function matches the given name and argument =
types. You=20
may need to ad<BR>d explicit type casts.</FONT></DIV></BODY></HTML>

------=_NextPart_000_00C5_01C61CF4.FA6C0920--





From cruz@sygecom.com.br Tue Jan  3 18:06:12 2012
Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 6434D116AE57
	for <pgsql-admin@postgresql.org>; Tue,  3 Jan 2012 14:06:12 -0400 (AST)
Received: from smtp192.uni5.net ([189.38.92.192])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <cruz@sygecom.com.br>) id 1Ri8kU-0000zx-SO
	for pgsql-admin@postgresql.org; Tue, 03 Jan 2012 18:06:13 +0000
Received: from smtp-gw-03.uni5.net (smtp-gw-03 [127.0.0.1])
	by smtp192.uni5.net (Postfix) with ESMTP id 1C5D44F41A
	for <pgsql-admin@postgresql.org>; Tue,  3 Jan 2012 16:05:53 -0200 (BRST)
Received: from [192.168.0.192] (200.175.81.139.dynamic.adsl.gvt.net.br
	[200.175.81.139])
	by smtp-gw-03.uni5.net (Postfix) with ESMTPSA id 10201165D833B
	for <pgsql-admin@postgresql.org>; Tue,  3 Jan 2012 16:05:50 -0200 (BRST)
Message-ID: <4F035189.9040300@sygecom.com.br>
Date: Tue, 03 Jan 2012 16:05:45 -0300
From: =?ISO-8859-1?Q?Maur=EDcio_Cruz?= <cruz@sygecom.com.br>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
	rv:8.0) Gecko/20111105 Thunderbird/8.0
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: lo_import
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201201/7
X-Sequence-Number: 38919

Hi all,

I'm trying to use lo_import to import a file into my database, if I 
execute from postgres runing in my local machine
it works perfectly, but if I do it in the postgres runing in the server, 
it says "No such file or directory"

I Guess postgres only see file on the machine it is runing and not 
through the network...
I will have to upload the file into the server and then use import  ?   
is there any other way ?

Thanks every one.
Cruz



From fabriziomello@gmail.com Wed Jan  4 00:02:12 2012
Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id 2AA8117C4C3F
	for <pgsql-admin@postgresql.org>; Tue,  3 Jan 2012 20:02:12 -0400 (AST)
Received: from mail-vw0-f46.google.com ([209.85.212.46])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <fabriziomello@gmail.com>) id 1RiEIy-0004DO-HH
	for pgsql-admin@postgresql.org; Wed, 04 Jan 2012 00:02:11 +0000
Received: by vbbfc26 with SMTP id fc26so12955575vbb.19
	for <pgsql-admin@postgresql.org>; Tue, 03 Jan 2012 16:01:55 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=mime-version:reply-to:in-reply-to:references:date:message-id
	:subject:from:to:cc:content-type;
	bh=EJsUep5CO1VX/CFhh+9sLosdsHEm7TAopqFBRSoD72U=;
	b=CQ7f2vwQqISpHwq4qkuSAVBP8yvVsW2wZcRohqoeFJbfZyWCypT/jnDj+8yG28FQlW
	ZTh7Eo3OHY8JGA8dk6jh3cCZTVfzYTRBIW1Dd03pesFEURT4kYLO5Q96KvYVsIdwaplJ
	xISCepisGpkGctXTlAHMMAUXGg7pdmbg6O/V4=
MIME-Version: 1.0
Received: by 10.52.38.72 with SMTP id e8mr14409557vdk.66.1325635315311; Tue,
	03 Jan 2012 16:01:55 -0800 (PST)
Received: by 10.220.9.145 with HTTP; Tue, 3 Jan 2012 16:01:55 -0800 (PST)
Reply-To: fabriziomello@gmail.com
In-Reply-To: <4F035189.9040300@sygecom.com.br>
References: <4F035189.9040300@sygecom.com.br>
Date: Tue, 3 Jan 2012 22:01:55 -0200
Message-ID: 
 <CAFcNs+q8YiMs6BVBAh2mMVk5ES36z3R7foKYAfgN0abA0+KJJA@mail.gmail.com>
Subject: Re: lo_import
From: =?ISO-8859-1?Q?Fabr=EDzio_de_Royes_Mello?= <fabriziomello@gmail.com>
To: =?ISO-8859-1?Q?Maur=EDcio_Cruz?= <cruz@sygecom.com.br>
Cc: pgsql-admin@postgresql.org
Content-Type: multipart/alternative; boundary=bcaec5196e071224b104b5a88611
X-Pg-Spam-Score: -2.7 (--)
X-Archive-Number: 201201/8
X-Sequence-Number: 38920

--bcaec5196e071224b104b5a88611
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Em 3 de janeiro de 2012 17:05, Maur=EDcio Cruz <cruz@sygecom.com.br> escrev=
eu:

> Hi all,
>
>
Hi Mauricio,



> I'm trying to use lo_import to import a file into my database, if I
> execute from postgres runing in my local machine
> it works perfectly, but if I do it in the postgres runing in the server,
> it says "No such file or directory"
>
>
It's the default behavior.


I Guess postgres only see file on the machine it is runing and not through
> the network...
> I will have to upload the file into the server and then use import  ?   i=
s
> there any other way ?
>
>
The lo_import/lo_export functions read/write files in the same file system
where postgres server is running [1]...

If you need send some file from your client to your database server you
must verify the implementation of libpq API in your programming language to
use another functions (lo_creat, lo_open, lo_write, lo_read) to create LOs
from your client side of connection into your server  [2].

Another way is using "psql" client program [3] to import/export large
objects.

[1] http://www.postgresql.org/docs/9.1/static/lo-funcs.html
[2] http://www.postgresql.org/docs/9.1/static/lo-examplesect.html
[3] http://www.postgresql.org/docs/9.1/static/app-psql.html


--=20
Fabr=EDzio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello

--bcaec5196e071224b104b5a88611
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<br><div class=3D"gmail_quote">Em 3 de janeiro de 2012 17:05, Maur=EDcio Cr=
uz <span dir=3D"ltr">&lt;<a href=3D"mailto:cruz@sygecom.com.br">cruz@sygeco=
m.com.br</a>&gt;</span> escreveu:<br><blockquote class=3D"gmail_quote" styl=
e=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi all,<br>
<br>
</blockquote><div><br></div><div>Hi Mauricio,</div><div><br></div><div>=A0<=
/div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-le=
ft:1px #ccc solid;padding-left:1ex">I&#39;m trying to use lo_import to impo=
rt a file into my database, if I execute from postgres runing in my local m=
achine<br>

it works perfectly, but if I do it in the postgres runing in the server, it=
 says &quot;No such file or directory&quot;<br>
<br>
</blockquote><div><br></div><div>It&#39;s the default behavior.</div><div>=
=A0</div><div><br></div><blockquote class=3D"gmail_quote" style=3D"margin:0=
 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I Guess postgres onl=
y see file on the machine it is runing and not through the network...<br>

I will have to upload the file into the server and then use import =A0? =A0=
 is there any other way ?<br>
<br>
</blockquote><div><br></div><div>The lo_import/lo_export functions read/wri=
te files in the same file system where postgres server is running [1]...</d=
iv><div><br></div><div>If you need send some file from your client to your =
database server you must verify the implementation of libpq API in your pro=
gramming language to use another functions (lo_creat, lo_open, lo_write, lo=
_read) to create LOs from your client side of connection into your server =
=A0[2].</div>
<div><br></div><div>Another way is using &quot;psql&quot; client program [3=
] to import/export large objects.</div><div><br></div><div>[1]=A0<a href=3D=
"http://www.postgresql.org/docs/9.1/static/lo-funcs.html">http://www.postgr=
esql.org/docs/9.1/static/lo-funcs.html</a></div>
<div>[2]=A0<a href=3D"http://www.postgresql.org/docs/9.1/static/lo-examples=
ect.html">http://www.postgresql.org/docs/9.1/static/lo-examplesect.html</a>=
</div><div>[3]=A0<a href=3D"http://www.postgresql.org/docs/9.1/static/app-p=
sql.html">http://www.postgresql.org/docs/9.1/static/app-psql.html</a></div>
<div><br></div><div><br></div></div>-- <br>Fabr=EDzio de Royes Mello<div>Co=
nsultoria/Coaching PostgreSQL<br>&gt;&gt; Blog sobre TI: <a href=3D"http://=
fabriziomello.blogspot.com" target=3D"_blank">http://fabriziomello.blogspot=
.com</a><div>
&gt;&gt; Perfil Linkedin:=A0<a href=3D"http://br.linkedin.com/in/fabriziome=
llo" target=3D"_blank">http://br.linkedin.com/in/fabriziomello</a></div><di=
v>&gt;&gt; Twitter:=A0<a href=3D"http://twitter.com/fabriziomello" target=
=3D"_blank">http://twitter.com/fabriziomello</a></div>
</div><br>

--bcaec5196e071224b104b5a88611--