On Tue, Mar 15, 2005 at 02:50:06PM -0700, Michael Fuhr wrote: > 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:
Thanks for the detailed test you ran. This is something I should have done before spouting off. So, really, AIUI, one of the "selling points" for each of the above-mentioned languages is their portability. It would appear to me that this newline incompatibility ought to be considered a major bug in python. (Maybe I'm spouting off half-cocked again, though). ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
