Re: [GENERAL] PL/Perl returning multiple rows

2003-11-10 Thread Christopher Murtagh
On Mon, 2003-11-10 at 21:11, Joshua D. Drake wrote: > The fact that it is pl/pgSQL? Seriously though, I think that pl/pgSQL is > counter intuitive to some people and those of us who are coming from say a Perl > background are going to be much more proficient in using pl/Perl then having > to learn

[GENERAL] pl-perl setup?

2001-05-25 Thread Jeff Boes
Hello, I'm fairly new to PostgreSQL. Does anyone have a resource for setting up plperl from scratch? The online documentation doesn't offer much help. -- Jeff Boes vox 616.226.9550 Database Engineer fax 616.349.9076

Re: [GENERAL] PL/Perl in 7.1.1

2001-05-16 Thread Tom Lane
Jeff Patterson <[EMAIL PROTECTED]> writes: > I recently upgraded from 7.0.3 to 7.1. Everything went fine until I went to > install plperl using createlang. It throws the following error message: > ERROR: Load of file /usr/local/pgsql/lib/plperl.so failed: >/usr/lib/perl5/5.6.0/i686-linux/auto/

[GENERAL] PL/Perl in 7.1.1

2001-05-16 Thread Jeff Patterson
I recently upgraded from 7.0.3 to 7.1. Everything went fine until I went to install plperl using createlang. It throws the following error message: ERROR: Load of file /usr/local/pgsql/lib/plperl.so failed: /usr/lib/perl5/5.6.0/i686-linux/auto/Opcode/Opcode.so: undefined symbol: Perl_save_vptr

Re: [GENERAL] PL/Perl without shared libperl.a

2001-05-12 Thread Alan Young
On Fri, 11 May 2001, Tom Lane wrote: > I believe you could actually use a non-shared libperl.a on Intel Linux; > just dike out the test for shared-ness in plperl's Makefile.PL. > The reason it's there is we couldn't think of a direct test for > position-independent code, which is the real requirem

Re: [GENERAL] PL/Perl without shared libperl.a

2001-05-11 Thread Tom Lane
Ian Lance Taylor <[EMAIL PROTECTED]> writes: > As far as I know, there is no simple way to test whether libperl.a is > compiled as position independent code or not. But it would be fairly > easy to test whether you can build a shared library using libperl.a, > by writing a little test case which

Re: [GENERAL] PL/Perl without shared libperl.a

2001-05-11 Thread Tom Lane
Ian Lance Taylor <[EMAIL PROTECTED]> writes: >> I believe you could actually use a non-shared libperl.a on Intel Linux; >> just dike out the test for shared-ness in plperl's Makefile.PL. >> The reason it's there is we couldn't think of a direct test for >> position-independent code, which is the r

Re: [GENERAL] PL/Perl without shared libperl.a

2001-05-11 Thread Tom Lane
Andrew Perrin <[EMAIL PROTECTED]> writes: > Has anyone got advice on building postgres 7.1 with PL/Perl support > WITHOUT having one's perl installation built with a shared libperl.a? Try repeating the Perl build with shared-lib selected and then just installing the resulting libperl.so beside l

[GENERAL] PL/Perl documentation ...

2001-05-02 Thread Adam Walczykiewicz
Is there available some more examples of writing functions in PL/Perl ? In standard documentation there is only just 2 examples. Thanks in advance for any help. Adam -- ---(end of broadcast)--- TIP 6: Have you searched our list archives?

Re: [GENERAL] PL/Perl Question

2001-04-20 Thread Doug McNaught
Hitesh Patel <[EMAIL PROTECTED]> writes: > I need to be able to execute SQL commands from inside a plperl > function and can't figure if I can do this. Also.. after executing > the query I need to be able to grab the number of tuples returned > and there values.. how would I go about doing this.

Re: [GENERAL] PL/Perl

2000-11-13 Thread Edward Q. Bridges
n.b. to clarify, i got PL/Perl working on RH Linux 6.2 am in the process of attempting to get it working on NT. ==BEGIN FORWARDED MESSAGE== when i did what's described below, i had no problems at all with PL/Perl (and, in fact, am using it for a couple of trig

Re: [GENERAL] PL/Perl

2000-11-13 Thread Edward Q. Bridges
when i did what's described below, i had no problems at all with PL/Perl (and, in fact, am using it for a couple of triggers that are lightly used in a production environment) http://www.postgresql.org/cgi/cvsweb.cgi/pgsql/src/pl/plperl/README?rev=1.2&content-type=text/x-cvsweb- markup you can

[GENERAL] PL/Perl compilation error

2000-10-24 Thread Gilles DAROLD
Hi, I have done a little work concerning the famous PL/Perl compilation Error and also into Interfaces/Perl5. The confusing POLLUTE option is no more used to see these parts compiled. I thinks it's now fully compatible with all Perl versions, yes Tom I use PPPort :-) The way to put it into the

Re: [GENERAL] PL/Perl compilation error

2000-10-17 Thread Alex Pilosov
On Tue, 17 Oct 2000, Tom Lane wrote: > Gilles DAROLD <[EMAIL PROTECTED]> writes: > >> The problem is this will break on older copies of Perl. > > > This problem is solved by perl itself ! > > Yeah, it is: there is a module called Devel::PPPort that isolates > user C code from the incompatibilit

Re: [GENERAL] PL/Perl compilation error

2000-10-16 Thread Tom Lane
Gilles DAROLD <[EMAIL PROTECTED]> writes: I have take a look to the source code concerning PL/Perl, it seems that 2 >variables have a bad call : errgv and na. If you replace them by their normal call (in 5.6.0) PL_errgv and PL_na you will >get success to compile the lib

Re: [GENERAL] PL/Perl compilation error

2000-10-16 Thread Gilles DAROLD
Bruce Momjian wrote: > Can you send me a patch? > > > Hi, > > > > I have take a look to the source code concerning PL/Perl, it seems that 2 variables > > have a bad call : errgv and na. > > > > If you replace them by their normal call (in 5.6.0) PL_errgv and PL_na you will get > > success to comp

Re: [GENERAL] PL/Perl compilation error

2000-10-16 Thread Bruce Momjian
Can you send me a patch? > Hi, > > I have take a look to the source code concerning PL/Perl, it seems that 2 variables > have a bad call : errgv and na. > > If you replace them by their normal call (in 5.6.0) PL_errgv and PL_na you will get > success to compile the lib plperl.so. > > Also in

Re: [GENERAL] PL/Perl compilation errorRe: [GENERAL] PL/Perl compilation error

2000-09-05 Thread Jan Wieck
Tom Lane wrote: > Alex Guryanow <[EMAIL PROTECTED]> writes: > > [root@eaccess plperl]# perl Makefile.PL > > For recent Perl versions you need to do > perl Makefile.PL POLLUTE=1 > instead. The src/pl Makefile would've done it that way for you, > but it looks like that code patch didn't mak

Re: [GENERAL] PL/Perl compilation error

2000-09-04 Thread Gilles DAROLD
Hi, I have take a look to the source code concerning PL/Perl, it seems that 2 variables have a bad call : errgv and na. If you replace them by their normal call (in 5.6.0) PL_errgv and PL_na you will get success to compile the lib plperl.so. Also in Perl documentation you will find the answer f

<    1   2