Bug 9514

при попытке create function получаем:
DEBUG:  ProcessUtility
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

фрагмент серверного лога:

STATEMENT:  CREATE FUNCTION calc_score(bigint) returns bigint language plperl as
$$my $score=$_[0];if ($score > 150) { $score = round($score*(2
050-$score)/2100); } return $score;$$;
DEBUG:  00000: parse tree:
DETAIL:  {QUERY :commandType 5 :querySource 0 :canSetTag true :utilityStmt ?
        :resultRelation 0 :into <> :hasAggs false :hasSubLinks false :rtable <>
        :jointree <> :rowMarks <> :forUpdate false :rowNoWait false :targetList <>
        :groupClause <> :havingQual <> :distinctClause <> :sortClause <>
:limitOffset
        <> :limitCount <> :setOperations <> :resultRelations <>}

LOCATION:  elog_node_display, print.c:86
STATEMENT:  CREATE FUNCTION calc_score(bigint) returns bigint language plperl as
$$my $score=$_[0];if ($score > 150) { $score = round($score*(2
050-$score)/2100); } return $score;$$;
DEBUG:  00000: ProcessUtility
LOCATION:  PortalRunUtility, pquery.c:952
STATEMENT:  CREATE FUNCTION calc_score(bigint) returns bigint language plperl as
$$my $score=$_[0];if ($score > 150) { $score = round($score*(2
050-$score)/2100); } return $score;$$;
Can't open perl script "-e": No such file or directory
DEBUG:  00000: reaping dead processes
LOCATION:  reaper, postmaster.c:2111
DEBUG:  00000: server process (PID 16662) was terminated by signal 11
LOCATION:  LogChildExit, postmaster.c:2515
LOG:  00000: server process (PID 16662) was terminated by signal 11
LOCATION:  LogChildExit, postmaster.c:2515
LOG:  00000: terminating any other active server processes
LOCATION:  HandleChildCrash, postmaster.c:2396
DEBUG:  00000: sending SIGQUIT to process 16637
LOCATION:  HandleChildCrash, postmaster.c:2449
DEBUG:  00000: sending SIGQUIT to process 16638
LOCATION:  HandleChildCrash, postmaster.c:2483
LOG:  00000: all server processes terminated; reinitializing
LOCATION:  reaper, postmaster.c:2296
DEBUG:  00000: shmem_exit(0)
LOCATION:  shmem_exit, ipc.c:126
DEBUG:  00000: invoking IpcMemoryCreate(size=22577152)
LOCATION:  CreateSharedMemoryAndSemaphores, ipci.c:99
LOG:  00000: database system was interrupted at 2006-05-04 18:16:45 MSD
LOCATION:  StartupXLOG, xlog.c:4374
LOG:  00000: checkpoint record is at 1/2258ED00
LOCATION:  StartupXLOG, xlog.c:4442
LOG:  00000: redo record is at 1/2258ED00; undo record is at 0/0; shutdown TRUE
LOCATION:  StartupXLOG, xlog.c:4469
LOG:  00000: next transaction ID: 9882117; next OID: 23815241
LOCATION:  StartupXLOG, xlog.c:4472
LOG:  00000: next MultiXactId: 1; next MultiXactOffset: 0
LOCATION:  StartupXLOG, xlog.c:4475
LOG:  00000: database system was not properly shut down; automatic recovery in
progress
LOCATION:  StartupXLOG, xlog.c:4532