Re: [GENERAL] Multiline plpython procedure

2005-01-17 Thread Hong Yuan
am with Windows-styled newlines perfectly. I suspect the problem might lie in the module pl/python, which receives functions from Postgres and passes them to python. Maybe I should file a bug report. -- HONG Yuan Homemaster Trading Co., Ltd. No. 601, Bldg. 41, 288 Shuangyang Rd. (N) Shanghai 200

Re: [GENERAL] Multiline plpython procedure

2005-01-17 Thread Hong Yuan
Tom Lane wrote: Hong Yuan <[EMAIL PROTECTED]> writes: I suppose there are some invisible characters inserted into the function body by pgAdmin. Seems like it must be. You could try pg_dump'ing both versions of the function and comparing the output files byte-by-byte. Be sure

Re: [GENERAL] Multiline plpython procedure

2005-01-17 Thread Hong Yuan
Adrian Klaver wrote: On Monday 17 January 2005 01:54 am, Hong Yuan wrote: I entered the multilineversion of this function exactly as written here and it ran properly. This was with version 8.0 of Postgres. You might want to do a /df+ circ in psql to see if your editor is putting a space at the

[GENERAL] Multiline plpython procedure

2005-01-17 Thread Hong Yuan
mpile function "circ" DETAIL: exceptions.SyntaxError: invalid syntax (line 2) How to get Postgres to accept a normal looking python function? Greetings -- HONG Yuan Homemaster Trading Co., Ltd. No. 601, Bldg. 41, 288 Shuangyang Rd. (N) Shanghai 200433, P.R.C. Tel: +86 21 55056553 Fax: