Re: Newlines in pl/python functions - Mailing list pgadmin-support

From Andreas Pflug
Subject Re: Newlines in pl/python functions
Date
Msg-id 4123BE50.8070406@pse-consulting.de
Whole thread Raw
In response to Newlines in pl/python functions  (Jason Hyett <jason@hyett.org>)
List pgadmin-support
Jason Hyett wrote:
> 
> Hello all,
> 
> Sorry if this is not the right forum, but...
> 
> I'm running postgres 7.4.3 on Linux with pl/python installed, and 
> pgadmin 1.0.2 on windows XP. If I try and create a python function via 
> pgadmin I cannot include newlines in the script. The function is updated 
> ok, but I get syntax errors when the script compiles. If I remove the 
> newlines and put all the code onto one long line then the function 
> compiles and executes fine.
> 
> If I create the same function on the server using psql then newlines 
> work ok, so I'm guessing there's a problem translating the newlines from 
> the Windows to Unix formats. Presumably this ought to work?
> 
> Just though I'd mention it since I can't find any reference elsewhere 
> suggesting this is a known issue.

I wonder if this is a problem with carriage returns (not linefeed).
Does the problem persist if you use pgAdmin on Linux?

Regards,
Andreas


pgadmin-support by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: pgAdmin3 bug
Next
From: chester c young
Date:
Subject: FC2 make problems