Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id A7034632B5E for ; Tue, 24 Feb 2009 04:32:28 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 97022-06 for ; Tue, 24 Feb 2009 04:32:23 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from rekin23.go2.pl (rekin23.go2.pl [193.17.41.16]) by mail.postgresql.org (Postfix) with ESMTP id B7AF46323D9 for ; Tue, 24 Feb 2009 04:30:07 -0400 (AST) Received: from rekin23.go2.pl (rekin23 [127.0.0.1]) by rekin23.go2.pl (Postfix) with ESMTP id C348212883F for ; Tue, 24 Feb 2009 09:30:02 +0100 (CET) Received: from o2.pl (unknown [10.0.0.36]) by rekin23.go2.pl (Postfix) with SMTP for ; Tue, 24 Feb 2009 09:30:02 +0100 (CET) Subject: =?UTF-8?Q?Re:_Problem_With_using_PERL::DBI_in_plperlu_function?= From: =?UTF-8?Q?Tomasz_Olszak?= To: pgsql-admin@postgresql.org In-Reply-To: <200902231530.19579.xzilla@users.sourceforge.net> References: <57da2175.1ad3af61.49a26c33.ce91@o2.pl> <200902231530.19579.xzilla@users.sourceforge.net> Mime-Version: 1.0 Message-ID: <644a8ae7.2fd54209.49a3b009.acc13@o2.pl> Date: Tue, 24 Feb 2009 09:30:01 +0100 X-Originator: 83.18.171.115 Content-Type: multipart/alternative; boundary="==o2.pl-WebMail-701cbe7a.65c87290.acc23==" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200902/203 X-Sequence-Number: 31424 --==o2.pl-WebMail-701cbe7a.65c87290.acc23== Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Than=20you=20for=20Your=20answer=20Robert. =20 I've=20trying=20a=20lot=20of=20different=20configurations=20and=20the=20s= ame=20perl=20body=20that=20works=20in=20OS=20perl=20script=20but=20doesn'= t=20work=20in=20plperlu=20function. =20 I=20think=20it's=20a=20little=20bit=20confusing=20that=20almost=20all=20e= xamples=20in=20Internet=20showing=20creating=20connection=20from=20postgr= es=20to=20oracle=20the=20way=20I=20did=20it. =20 It=20seems=20that=20nobody=20tried=20to=20connect=20(from=20plperlu=20fun= ction)=20with=20external=20database(not=20installed=20on=20localhost=20an= d=20not=20in=20local=20network). =20 Version=20Of=20perl=20that=20i'm=20using=20is=205.8.8,=20postgresql=208.2= .9,=20oracle=2010.2=20client=20and=20DBI=20version=20is=201.52. =20 I'll=20try=20to=20install=20latest=20DBI=20and=20perl. =20If=20it's=20plperlu=20problem=20i=20will=20not=20try=20with=20latest=20= postgresql=20because=20databases=20and=20application=20i'm=20using=20i=20= too=20big=20to=20change=20source=20code=20of=20pg=20functions=20and=20app= lication=20in=20few=20days=20to=20work=20with=208.3.*=20databases. =20 If=20I=20find=20any=20solutions=20i=20will=20write=20an=20answer. =20 Greetings =20 Tomek There=20is=20a=20bug=20somewhere=20in=20the=20plperlu=20<->=20oracl= e=20dbi=20stack=20(most=20likely=20in=20 the=20oracle=20dbd=20driver,=20but=20that=20just=20a=20guess)=20that=20pr= events=20these=20type=20of=20 connections=20from=20work=20from=20a=20non-local=20connection,=20specific= ally=20due=20to=20lack=20 of=20environment=20variable=20sanity.=20We=20spent=20quite=20a=20bit=20of= =20time=20trying=20to=20figure=20 this=20out=20a=20few=20years=20ago,=20but=20to=20no=20avail,=20so=20gener= ally=20my=20answer=20on=20this=20 is=20"you=20can't=20do=20that",=20but=20by=20all=20means=20feel=20free=20= to=20dig=20in=20and=20post=20if=20you=20 find=20a=20way=20to=20make=20it=20work=20(I'm=20hopeful=20that=20newer=20= versions=20of=20the=20software=20 involved=20might=20work,=20but=20haven't=20had=20any=20luck=20in=20the=20= combinations=20I've=20tested=20 so=20far).=20 --=20 Robert=20Treat Conjecture:=20http://www.xzilla.net Consulting:=20http://www.omniti.com --==o2.pl-WebMail-701cbe7a.65c87290.acc23== Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Than=20you=20for=20Your=20answer=20Robert.=20=20I've=20tr= ying=20a=20lot=20of=20different=20configurations=20and=20the=20same=20per= l=20body=20that=20works=20in=20OS=20perl=20script=20but=20doesn't=20work=20= in=20plperlu=20function.=20=20I=20think=20it's=20a=20litt= le=20bit=20confusing=20that=20almost=20all=20examples=20in=20Internet=20s= howing=20creating=20connection=20from=20postgres=20to=20oracle=20the=20wa= y=20I=20did=20it.=20=20It=20seems=20that=20nobody=20tried= =20to=20connect=20(from=20plperlu=20function)=20with=20external=20databas= e(not=20installed=20on=20localhost=20and=20not=20in=20local=20network).=20=20Version=20Of=20perl=20that=20i'm=20using=20is=205.8.8= ,=20postgresql=208.2.9,=20oracle=2010.2=20client=20and=20DBI=20version=20= is=201.52.=20=20I'll=20try=20to=20install=20latest=20DBI=20= and=20perl.=20If=20it's=20plperlu=20problem=20i=20will=20not=20tr= y=20with=20latest=20postgresql=20because=20databases=20and=20application=20= i'm=20using=20i=20too=20big=20to=20change=20source=20code=20of=20pg=20fun= ctions=20and=20application=20in=20few=20days=20to=20work=20with=208.3.*=20= databases.=20=20If=20I=20find=20any=20solutions=20i=20wil= l=20write=20an=20answer.=20=20Greetings=20=20Tomek There=20is=20a=20bug=20= somewhere=20in=20the=20plperlu=20<->=20oracle=20dbi=20stack=20(most= =20likely=20in=20the=20oracle=20dbd=20driver,=20but=20that=20just= =20a=20guess)=20that=20prevents=20these=20type=20of=20connections= =20from=20work=20from=20a=20non-local=20connection,=20specifically=20due=20= to=20lack=20of=20environment=20variable=20sanity.=20We=20spent=20= quite=20a=20bit=20of=20time=20trying=20to=20figure=20this=20out=20= a=20few=20years=20ago,=20but=20to=20no=20avail,=20so=20generally=20my=20a= nswer=20on=20this=20is=20"you=20can't=20do=20that",=20but=20by=20= all=20means=20feel=20free=20to=20dig=20in=20and=20post=20if=20you=20find=20a=20way=20to=20make=20it=20work=20(I'm=20hopeful=20that=20newer=20= versions=20of=20the=20software=20involved=20might=20work,=20but=20= haven't=20had=20any=20luck=20in=20the=20combinations=20I've=20tested=20so=20far).=20--=20Robert=20TreatCon= jecture:=20http://www.xzilla.netConsulting:=20http://www.omniti.c= om --==o2.pl-WebMail-701cbe7a.65c87290.acc23==--