Re: [ADMIN] plperl again but different problem

On Tue, Sep 13, 2005 at 05:17:55PM +0200, Marcin Giedz wrote: > Dnia wtorek, 13 wrze??nia 2005 17:01, Marcin Giedz napisa??: > > Additional info: I've also checked plperl with postgresql snapshot - problem > still exists ;( - > > didn't anyone have something similar? or maybe I'm only one who u

Re: [ADMIN] plperl again but different problem

Ok guys... thanks you both ;) I've installed perl once again into default location and now IT'S ALIVE ! Thanks once again. Marcin ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [ADMIN] plperl

Did you build from source? Did you explicitly enable PL/Perl during configuration?You need to specify --with-perl to configure to get it to build:http://www.postgresql.org/docs/8.0/static/install-procedure.html --Thomas F. O'ConnellCo-Founder, Information ArchitectSitening, LLCStrategic Open Source

Re: [ADMIN] plperl again but different problem

Marcin Giedz napisał(a): OK ... I have compiled it once again - really don't know why this time libperl is visible?: pgsql2-test:/usr/src/postgresql-8.0.3/src/pl/plperl# pgsql2-test:/usr/src/postgresql-8.0.3/src/pl/plperl# ldd libplperl.so libperl.so => /usr/lib/libperl.so (0xb7ed1000

Re: [ADMIN] plperl again but different problem

Marcin Giedz <[EMAIL PROTECTED]> writes: > OK ... I have compiled it once again - really don't know why this time > libperl is visible?: Sounds like you did it wrong the first time ;-) > pgsql2-test:/usr/src/postgresql-8.0.3/src/pl/plperl# ldd libplperl.so > libperl.so => /usr/lib/libper

Re: [ADMIN] plperl again but different problem

OK ... I have compiled it once again - really don't know why this time libperl is visible?: pgsql2-test:/usr/src/postgresql-8.0.3/src/pl/plperl# pgsql2-test:/usr/src/postgresql-8.0.3/src/pl/plperl# ldd libplperl.so libperl.so => /usr/lib/libperl.so (0xb7ed1000) libdl.so.2 => /lib

Re: [ADMIN] plperl again but different problem

Hi Here is what I have: [EMAIL PROTECTED]:~$ dpkg -l | grep -i perl ii libcompress-zl 1.34-1 Perl module for creation and manipulation of ii libdbi-perl1.46-6 Perl5 database interface by Tim Bunce ii libft-perl 1.2-14 Perl module for the FreeType library ii l

Re: [ADMIN] plperl again but different problem

Marcin Giedz <[EMAIL PROTECTED]> writes: > Tom Lane napisa³(a): >> How big a plperl.so do you have? >> > ~57kB plperl.so > ~1.2MB libperl.so Well, it's not statically linked then. You should go back into src/pl/plperl and do "make clean all" so you can see what command was done to produce plpe

Re: [ADMIN] plperl again but different problem

Sergiusz Jarczyk napisał(a): Hi again My PostgreSQL (built from sources) is running on Sarge too, bit I didn't have any such a problems. What's more, I have both Perls installed in standard places. Try to run 'locate *libperl*' to check Does nothing :( - h??? What packages related to per

Re: [ADMIN] plperl again but different problem

Tom Lane napisał(a): Marcin Giedz <[EMAIL PROTECTED]> writes: I don't see any libperl.so :( But doesn't plperl use shared libperl library? Yeah, it's supposed to. On an FC4 machine I get $ ldd libplperl.so linux-gate.so.1 => (0x00682000) libperl.so => /usr/lib/perl5/

Re: [ADMIN] plperl again but different problem

Hi Tom Lane napisał(a): Marcin Giedz <[EMAIL PROTECTED]> writes: I don't see any libperl.so :( But doesn't plperl use shared libperl library? Yeah, it's supposed to. On an FC4 machine I get $ ldd libplperl.so linux-gate.so.1 => (0x00682000) libperl.so => /usr/lib/pe

Re: [ADMIN] plperl again but different problem

Hi again My PostgreSQL (built from sources) is running on Sarge too, bit I didn't have any such a problems. What's more, I have both Perls installed in standard places. Try to run 'locate *libperl*' to check if there isn't more then one on your system. Sergiusz ---(en

Re: [ADMIN] plperl again but different problem

Marcin Giedz <[EMAIL PROTECTED]> writes: > I don't see any libperl.so :( But doesn't plperl use shared libperl library? Yeah, it's supposed to. On an FC4 machine I get $ ldd libplperl.so linux-gate.so.1 => (0x00682000) libperl.so => /usr/lib/perl5/5.8.6/i386-linux-thread-multi

Re: [ADMIN] plperl again but different problem

Dnia wtorek, 13 września 2005 17:24, Tom Lane napisał: > Marcin Giedz <[EMAIL PROTECTED]> writes: > >> createlang: language installation failed: ERROR: could not load library > >> "/usr/local/postgresql-8.0.3/lib/plperl.so": > >> /usr/local/postgresql-8.0.3/lib/plperl.so: undefined symbol: Perl_cr

Re: [ADMIN] plperl again but different problem

Marcin Giedz <[EMAIL PROTECTED]> writes: >> createlang: language installation failed: ERROR: could not load library >> "/usr/local/postgresql-8.0.3/lib/plperl.so": >> /usr/local/postgresql-8.0.3/lib/plperl.so: undefined symbol: Perl_croak I think you've got some kind of mismatch between the compi

Re: [ADMIN] plperl again but different problem

Dnia wtorek, 13 września 2005 17:01, Marcin Giedz napisał: Additional info: I've also checked plperl with postgresql snapshot - problem still exists ;( - didn't anyone have something similar? or maybe I'm only one who uses Sarge 3.1? :D:D Marcin > Dnia wtorek, 13 września 2005 14:42, Sergiu

Re: [ADMIN] plperl again but different problem

Dnia wtorek, 13 września 2005 14:42, Sergiusz Jarczyk napisał: > Hi Marcin > > Marcin Giedz napisał(a): > >Hello.. > > > >I've installed plperl.so in postgresql lib directory but when I try to > > create lang, such error occures: > > > >pgsql2-test:~# su pgadmin > >[EMAIL PROTECTED]:/root$ /usr/loc

Re: [ADMIN] plperl again but different problem

Dnia wtorek, 13 września 2005 14:18, Marcin Giedz napisał: > Hello.. O I didn't mention what Linux . Debian Sarge 3.1 kernel 2.6.12.5 perl lates 5.8.7 from sources perl 5.8.4-8 from dselect postgresql 8.0.3 from sources > > I've installed plperl.so in postgresql lib directory but when I

[ADMIN] plperl again but different problem

Hello.. I've installed plperl.so in postgresql lib directory but when I try to create lang, such error occures: pgsql2-test:~# su pgadmin [EMAIL PROTECTED]:/root$ /usr/local/postgresql/bin/createlang -p 5433 plperlu pl createlang: language installation failed: ERROR: could not load library "/

[ADMIN] plperl

Hi there,   I am trying to install plperl language with command   "createlang plperl template1"   I am getting error message "language installation failed: ERROR:  could not access file "$libdir/plperl": No such file or directory" Does anybody know how to fix this? Dont have much experienc

Re: [ADMIN] plperl loading

Joe Conway napisaÅ(a): Marek Lewczuk wrote: I've made some tests with plperl and I see that when plperl function is executed for the first time, then it takes much more time. I know that this is a "shared library" problem - is there a way to preload plperl every connection or maybe I can build p

Re: [ADMIN] plperl loading

Marek Lewczuk wrote: I've made some tests with plperl and I see that when plperl function is executed for the first time, then it takes much more time. I know that this is a "shared library" problem - is there a way to preload plperl every connection or maybe I can build plperl into postgresql s

[ADMIN] plperl loading

Hi, I've made some tests with plperl and I see that when plperl function is executed for the first time, then it takes much more time. I know that this is a "shared library" problem - is there a way to preload plperl every connection or maybe I can build plperl into postgresql source ? Thanks i

Re: [ADMIN] plperl won't load on Win2k3

> Hello All, > > I'd like to know what I am doing wrong. I've installed the > 7.5 win32 version of Postgres (love it...). I've entered the > bin directory and loaded the plpgsql language on my database > (works fine)... > > I have perl 5.6.1 installed as well and would like to load > the plpe

[ADMIN] plperl won't load on Win2k3

Hello All, I'd like to know what I am doing wrong. I've installed the 7.5 win32 version of Postgres (love it...). I've entered the bin directory and loaded the plpgsql language on my database (works fine)... I have perl 5.6.1 installed as well and would like to load the plperl language on the

Re: [ADMIN] plperl does not build on RH7.1

- Original-Nachricht Von: Tom Lane <[EMAIL PROTECTED]> An: Stefan Holzheu <[EMAIL PROTECTED]> Cc: ADMIN <[EMAIL PROTECTED]> Betreff: Re: [ADMIN] plperl does not build on RH7.1 Datum: 22/12/03 00:34 Thanks, Tom. I will try after Christmas. > > You need th

Re: [ADMIN] plperl does not build on RH7.1

Stefan Holzheu <[EMAIL PROTECTED]> writes: > In the previous message I have forgotten to give some important information: > postgresql 7.4 > perl 5.6.1 >> Is there a way to build plperl on RH7.1? You need this patch: 2003-11-24 08:16 petere * configure, configure.in, src/include/pg_con

[ADMIN] plperl does not build on RH7.1

In the previous message I have forgotten to give some important information: postgresql 7.4 perl 5.6.1 Is there a way to build plperl on RH7.1? Here the error output: plperl.c: In function `plperl_create_sub': plperl.c:306: warning: passing arg 1 of `perl_call_pv' from incompatible pointer type

[ADMIN] plperl does not build on RH7.1

Is there a way to build plperl on RH7.1? Here the error output: plperl.c: In function `plperl_create_sub': plperl.c:306: warning: passing arg 1 of `perl_call_pv' from incompatible pointer type plperl.c:306: warning: passing arg 2 of `perl_call_pv' makes pointer from integer without a cast plper

[ADMIN] Plperl make fails with Error1 at plperl.o (7.0.3)

Hello all, I'm resending the message sent by "turing2000" on November 16th. Because I'm having the exact same problem. My configuration is as follows: RedHat 7.0, originally installed the RPM version of PostgreSQL 7.0.2, then downloaded source and upgraded to 7.0.3... Now that I've gotten furthe