PL/pgSQL
От | Tuttle, Gene |
---|---|
Тема | PL/pgSQL |
Дата | |
Msg-id | 199F7F755B80D511877100B0D0F0B76CC3FDE7@mail.rottlundhomes.com обсуждение исходный текст |
Ответы |
Re: PL/pgSQL
(Tom Lane <tgl@sss.pgh.pa.us>)
|
Список | pgsql-admin |
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
В списке pgsql-admin по дате отправления: