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

Re: Troubles with PL/Perl in PgSQL

From: Vladimir D Belousov <pg-maillist(at)klarnet(dot)ru>
To: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Troubles with PL/Perl in PgSQL
Date: 2005-07-28 01:01:55
Message-ID: 42E82E83.3000808@klarnet.ru (view raw or flat)
Thread:
Lists: pgsql-novice
Jeff Eckermann wrote:

>"Vladimir D Belousov" <pg-maillist(at)klarnet(dot)ru> wrote in message 
>news:42E79EC3(dot)6040407(at)klarnet(dot)ru(dot)(dot)(dot)
>  
>
>>Hallo!
>>
>>I'm new in PgSQL and I try to migrate from InterBase (Firebird) to PgSQL.
>>
>>I have a trouble with call ANY plperl function.
>>I have the very simple function:
>>---------------------
>>
>>CREATE FUNCTION myint(integer) RETURNS integer AS $$
>> my $result = $_[0];
>> return $result;
>>$$ LANGUAGE plperl;
>>---------------------
>>
>>And when I try to call this function, I got the error:
>>---------------------
>>$ psql test
>>Welcome to psql 8.0.3, the PostgreSQL interactive terminal.
>>
>>Type:  \copyright for distribution terms
>>    \h for help with SQL commands
>>    \? for help with psql commands
>>    \g or terminate with semicolon to execute query
>>    \q to quit
>>
>>test=# select * from myint(5);
>>    
>>
>
>This syntax is appropriate for set-returning functions.  For functions 
>returning a single value, use "select myint(5);"
>  
>
I see, thank you!
But when I try
select myint(5) from test;
(table test exists but has no records), I got the same error.

And here that I have noticed:  on a home computer this truoble is not 
present.
However on the server and my home PC - the kernel and the system 
environment are
almost absolutely identical - FreeBSD 5.4 (cvsup on Tue Jul 26 21:24:24 
MSD 2005).
(except SMP support in the kernel and two options sysctl - for 
hypertrading on the server).
SysV IPC options are identical too.

Possibly, I've gape any bug report about a problem using SMP kernel?

>  
>
>>server closed the connection unexpectedly
>>     This probably means the server terminated abnormally
>>     before or while processing the request.
>>The connection to the server was lost. Attempting reset: Failed.
>>!>
>>---------------------
>>From the /var/log/messages
>>Jul 27 18:17:24 ibserver postgres[57180]: [5-1] FATAL:  the database 
>>system is in recovery mode
>>
>>I use FreeBSD 5.4 with PostgreSQL 8.0.3.
>>PgSQL was builded from sources with --with-perl option. Other options have 
>>defaults values.
>>
>>Thanks for any replies!
>>
>>
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 4: Have you searched our list archives?
>>
>>              http://archives.postgresql.org
>>
>>    
>>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org
>  
>


In response to

Responses

pgsql-novice by date

Next:From: Jeff EckermannDate: 2005-07-28 01:55:44
Subject: Re: Troubles with PL/Perl in PgSQL
Previous:From: Jeff EckermannDate: 2005-07-27 23:53:49
Subject: Re: Troubles with PL/Perl in PgSQL

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