PL/pgSQL

I am not able to run any user created functions.

Thanks for your help. Gene Tuttle.

Postgres 7.4
Redhat 9

Debug output:

DEBUG: StartTransactionCommand
LOG: statement: select my_factorial(1);
DEBUG: parse tree:
DETAIL: {QUERY :commandType 1 :querySource 0 :canSetTag true :utilityStmt
<>
:resultRelation 0 :into <> :hasAggs false :hasSubLinks false :rtable
<>
:jointree {FROMEXPR :fromlist <> :quals <>} :rowMarks () :targetList
({TARGETENTRY :resdom {RESDOM :resno 1 :restype 23 :restypmod -1
:resname
my_factorial :ressortgroupref 0 :resorigtbl 0 :resorigcol 0 :resjunk
false}
:expr {FUNCEXPR :funcid 34208 :funcresulttype 23 :funcretset false
:funcformat
0 :args ({CONST :consttype 23 :constlen 4 :constbyval true
:constisnull false
:constvalue 4 [ 1 0 0 0 ]})}}) :groupClause <> :havingQual <>
:distinctClause
<> :sortClause <> :limitOffset <> :limitCount <> :setOperations <>
:resultRelations ()}

DEBUG: rewritten parse tree:
DETAIL: ({QUERY :commandType 1 :querySource 0 :canSetTag true :utilityStmt
<>
:resultRelation 0 :into <> :hasAggs false :hasSubLinks false :rtable
<>
:jointree {FROMEXPR :fromlist <> :quals <>} :rowMarks () :targetList
({TARGETENTRY :resdom {RESDOM :resno 1 :restype 23 :restypmod -1
:resname
my_factorial :ressortgroupref 0 :resorigtbl 0 :resorigcol 0 :resjunk
false}
:expr {FUNCEXPR :funcid 34208 :funcresulttype 23 :funcretset false
:funcformat
0 :args ({CONST :consttype 23 :constlen 4 :constbyval true
:constisnull false
:constvalue 4 [ 1 0 0 0 ]})}}) :groupClause <> :havingQual <>
:distinctClause
<> :sortClause <> :limitOffset <> :limitCount <> :setOperations <>
:resultRelations ()})

DEBUG: plan:
DETAIL: {RESULT :startup_cost 0.00 :total_cost 0.01 :plan_rows 1
:plan_width 0
:targetlist ({TARGETENTRY :resdom {RESDOM :resno 1 :restype 23
:restypmod -1
:resname my_factorial :ressortgroupref 0 :resorigtbl 0 :resorigcol 0
:resjunk
false} :expr {FUNCEXPR :funcid 34208 :funcresulttype 23 :funcretset
false
:funcformat 0 :args ({CONST :consttype 23 :constlen 4 :constbyval
true
:constisnull false :constvalue 4 [ 1 0 0 0 ]})}}) :qual <> :lefttree
<>
:righttree <> :initPlan <> :extParam () :allParam () :nParamExec 0
:resconstantqual <>}

DEBUG: PortalRun
DEBUG: reaping dead processes
DEBUG: child process (PID 28036) was terminated by signal 11
LOG: server process (PID 28036) was terminated by signal 11
LOG: terminating any other active server processes
LOG: all server processes terminated; reinitializing
DEBUG: shmem_exit(0)
DEBUG: invoking IpcMemoryCreate(size=10436608)
LOG: database system was interrupted at 2004-06-30 08:33:40 CDT
LOG: checkpoint record is at 0/1534858
LOG: redo record is at 0/1534858; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 16669; next OID: 42400
LOG: database system was not properly shut down; automatic recovery in
progress
FATAL: the database system is starting up
DEBUG: proc_exit(0)
DEBUG: shmem_exit(0)
DEBUG: exit(0)
DEBUG: forked new backend, pid=28039 socket=8
DEBUG: reaping dead processes
DEBUG: child process (PID 28039) exited with exit code 0
LOG: record with zero length at 0/1534898
LOG: redo is not required
LOG: database system is ready
DEBUG: proc_exit(0)
DEBUG: shmem_exit(0)
DEBUG: exit(0)
DEBUG: reaping dead processes