Re: [ADMIN] plperl again but different problem

2005-09-14 Thread David
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

2005-09-13 Thread Marcin Giedz
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 again but different problem

2005-09-13 Thread Sergiusz Jarczyk
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

2005-09-13 Thread Tom Lane
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

2005-09-13 Thread Marcin Giedz
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

2005-09-13 Thread Sergiusz Jarczyk
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

2005-09-13 Thread Tom Lane
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

2005-09-13 Thread Marcin Giedz
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

2005-09-13 Thread Marcin Giedz
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

2005-09-13 Thread Sergiusz Jarczyk
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

2005-09-13 Thread Sergiusz Jarczyk
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

2005-09-13 Thread Tom Lane
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

2005-09-13 Thread Marcin Giedz
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

2005-09-13 Thread Tom Lane
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

2005-09-13 Thread Marcin Giedz
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

2005-09-13 Thread Marcin Giedz
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

2005-09-13 Thread Marcin Giedz
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

2005-09-13 Thread Marcin Giedz
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 "/