On Tue, Mar 15, 2005 at 03:41:37PM +0000, Ragnar Hafstaš wrote:
> actually, perl scripts with \r\n line endings will run just fine in
> unix/linux.
Indeed, and PL/Perl doesn't care. I just tested several PLs with
PostgreSQL 8.0.1 on Solaris 9 and here are the results:
PL/pgSQL CRLF ok
PL/Perl CRLF ok
PL/Ruby CRLF ok
PL/Tcl CRLF ok
PL/Python CRLF fails
PL/R CRLF fails
Details:
CREATE FUNCTION test_pgsql() RETURNS integer AS
'DECLARE x integer;\r\nBEGIN\r\nx := 123;\r\nRETURN x;\r\nEND;\r\n'
LANGUAGE plpgsql;
CREATE FUNCTION test_perl() RETURNS integer AS
'$x = 123;\r\nreturn $x;\r\n'
LANGUAGE plperl;
CREATE FUNCTION test_ruby() RETURNS integer AS
'x = 123\r\nreturn x\r\n'
LANGUAGE plruby;
CREATE FUNCTION test_tcl() RETURNS integer AS
'set x 123\r\nreturn $x\r\n'
LANGUAGE pltcl;
CREATE FUNCTION test_python() RETURNS integer AS
'x = 123\r\nreturn x\r\n'
LANGUAGE plpythonu;
CREATE FUNCTION test_r() RETURNS integer AS
'x <- 123\r\nreturn(x)\r\n'
LANGUAGE plr;
SELECT test_pgsql();
test_pgsql
------------
123
(1 row)
SELECT test_perl();
test_perl
-----------
123
(1 row)
SELECT test_ruby();
test_ruby
-----------
123
(1 row)
SELECT test_tcl();
test_tcl
----------
123
(1 row)
SELECT test_python();
ERROR: plpython: could not compile function "test_python"
DETAIL: exceptions.SyntaxError: invalid syntax (line 2)
SELECT test_r();
ERROR: R interpreter parse error
DETAIL: R parse error caught in "PLR36865 <- function() {x <- 123
return(x)
}".
CONTEXT: In PL/R function test_r
If I remove the CRs from the Python and R functions then they work:
CREATE OR REPLACE FUNCTION test_python() RETURNS integer AS
'x = 123\nreturn x\n'
LANGUAGE plpythonu;
CREATE OR REPLACE FUNCTION test_r() RETURNS integer AS
'x <- 123\nreturn(x)\n'
LANGUAGE plr;
SELECT test_python();
test_python
-------------
123
(1 row)
SELECT test_r();
test_r
--------
123
(1 row)
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
