Skip site navigation (1) Skip section navigation (2)

Re: plperl problem

From: Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>
To: Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: plperl problem
Date: 2004-02-06 14:29:31
Message-ID: 4023A4CB.8080109@cybertec.at (view raw or flat)
Thread:
Lists: pgsql-bugs
I guess you are using pl/perl and not pl/perlU.
Using untrusted modules in trusted functions is not a good idea.
I guess you will need pl/perlU.

	Cheers,

		Hans



Pavel Stehule wrote:
> Hello
> 
> 	When I try add "use" cmd into my code, I get following error:
> 
> ERROR:  creation of function failed: 'require' trapped by operation mask 
> at (eval 2) line 1.
> 
> 	Code without use command works fine.
> 
> work=# select version();
>                                                   version
> ------------------------------------------------------------------------------------------------------------
>  PostgreSQL 7.5devel on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.2 
> 20031022 (Red Hat Linux 3.3.2-1)
> 
> [postgres(at)triss root]$ perl -V
> Summary of my perl5 (revision 5.0 version 8 subversion 3) configuration:
>   Platform:
>     osname=linux, osvers=2.4.22-1.2115.nptl, archname=i686-linux
>     uname='linux triss 2.4.22-1.2115.nptl #1 wed oct 29 15:42:51 est 2003 
> i686 i686 i386 gnulinux '
>     config_args=''
>     hint=previous, useposix=true, d_sigaction=define
>     usethreads=undef use5005threads=undef useithreads=undef 
> usemultiplicity=undef
>     useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
>     use64bitint=undef use64bitall=undef uselongdouble=undef
>     usemymalloc=n, bincompat5005=undef
>   Compiler:
>     cc='cc', ccflags ='-fno-strict-aliasing -I/usr/local/include 
> -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm',
>     optimize='-O3',
>     cppflags='-fno-strict-aliasing -I/usr/local/include 
> -I/usr/include/gdbm -fno-strict-aliasing -I/usr/local/include 
> -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm 
> -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE 
> -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm'
>     ccversion='', gccversion='3.3.2 20031022 (Red Hat Linux 3.3.2-1)', 
> gccosandvers=''
>     intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
>     d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
>     ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', 
> lseeksize=8
>     alignbytes=4, prototype=define
>   Linker and Libraries:
>     ld='cc', ldflags =' -L/usr/local/lib'
>     libpth=/usr/local/lib /lib /usr/lib
>     libs=-lnsl -lgdbm -ldb -ldl -lm -lcrypt -lutil -lc
>     perllibs=-lnsl -ldl -lm -lcrypt -lutil -lc
>     libc=/lib/libc-2.3.2.so, so=so, useshrplib=true, libperl=libperl.a
>     gnulibc_version='2.3.2'
>   Dynamic Linking:
>     dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic 
> -Wl,-rpath,/usr/local/lib/perl5/5.8.3/i686-linux/CORE'
>     cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib'
> 
> 
> Characteristics of this binary (from libperl):
>   Compile-time options: USE_LARGE_FILES
>   Built under linux
>   Compiled at Feb  5 2004 15:11:03
>   @INC:
>     /usr/local/lib/perl5/5.8.3/i686-linux
>     /usr/local/lib/perl5/5.8.3
>     /usr/local/lib/perl5/site_perl/5.8.3/i686-linux
>     /usr/local/lib/perl5/site_perl/5.8.3
>     /usr/local/lib/perl5/site_perl
> 
> What I have to do?
> 
> Regards
> Pavel Stehule
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faqs/FAQ.html


-- 
Cybertec Geschwinde u Schoenig
Schoengrabern 134, A-2020 Hollabrunn, Austria
Tel: +43/2952/30706 or +43/664/233 90 75
www.cybertec.at, www.postgresql.at, kernel.cybertec.at


In response to

pgsql-bugs by date

Next:From: PostgreSQL Bugs ListDate: 2004-02-06 23:09:05
Subject: BUG #1074: postgresql crashes
Previous:From: Pavel StehuleDate: 2004-02-06 14:11:00
Subject: plperl problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group