[ python-Bugs-1000555 ] BE crashes server process on CREATE FUNCTION.

[noreply at pgfoundry.org]

Bugs item #1000555, was opened at 2006-02-16 01:03
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=442&aid=1000555&group_id=1000094

Category: BE/TEOP
Group: Performance Issue
Status: Open
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: James Pye (jwp)
Summary: BE crashes server process on CREATE FUNCTION.

Initial Comment:
When using psql to load a CREATE OR REPLACE FUNCTION script the Postgres server will sometimes crash. See attached file for server log. The problem seems to arise when making a change to the script file. The function I was working with is as follows.

create or replace function py_test(varchar) returns varchar
language python as
$Body$
return str(args[0]+'no')
$Body$

If I change the line

return str(args[0]+'no') to
return args[0]+'no'  or vica versa

I can generally cause the server to crash.
When I am doing this I have one psql session open to run the function and am loading the function by invoking psql -d test -f fnc_py_test.sql in another session.

Postgres 8.1.3,Python 2.4.2, BE 0.3 checked out from CVS about an hour ago.


----------------------------------------------------------------------

You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=442&aid=1000555&group_id=1000094