pg的语句处理主控函数

//pgsql/src/backend/executor/spi /* * Parse and plan a querystring. * * At entry, plan->argtypes and plan->nargs must be valid. * * Query and plan lists are stored into *plan. */ static void _SPI_prepare_plan(const char *src, _SPI_plan *plan) { List *raw_parsetree_list; List *query_list_list; List *plan_list; ListCell *list_item; ErrorContextCallback spierrcontext; Oid *argtypes = plan->argtypes; int nargs = plan->nargs; /* * Increment CommandCounter to see changes made by now. We must do this * to be sure of seeing any schema changes made by a just-preceding SPI * command. (But we don't bother advancing the snapshot, since the * planner generally operates under SnapshotNow rules anyway.) */ CommandCounterIncrement(); /* * Setup error traceback support for ereport() */ spierrcontext.callback = _SPI_error_callback; spierrcontext.arg = (void *) src; spierrcontext.previous = error_context_stack; error_context_stack = &spierrcontext; /* * Parse the request string into a list of raw parse trees. * raw_parsetree_list = pg_parse_query(src);/ /* * Do parse analysis and rule rewrite for each raw parsetree. * * We save the querytrees from each raw parsetree as a separate sublist. * This allows _SPI_execute_plan() to know where the boundaries between * original queries fall. */ query_list_list = NIL; plan_list = NIL; foreach(list_item, raw_parsetree_list) { Node *parsetree = (Node *) lfirst(list_item); List *query_list; query_list = pg_analyze_and_rewrite(parsetree, argtypes, nargs); query_list_list = lappend(query_list_list, query_list); plan_list = list_concat(plan_list, pg_plan_queries(query_list, NULL, false)); } plan->qtlist = query_list_list; plan->ptlist = plan_list; /* * Pop the error context stack */ error_context_stack = spierrcontext.previous; } /* * Execute the given plan with the given parameter values * * snapshot: query snapshot to use, or InvalidSnapshot for the normal * behavior of taking a new snapshot for each query. * crosscheck_snapshot: for RI use, all others pass InvalidSnapshot * read_only: TRUE for read-only execution (no CommandCounterIncrement) * fire_triggers: TRUE to fire AFTER triggers at end of query (normal case); * FALSE means any AFTER triggers are postponed to end of outer query * tcount: execution tuple-count limit, or 0 for none */ static int _SPI_execute_plan(_SPI_plan *plan, Datum *Values, const char *Nulls, Snapshot snapshot, Snapshot crosscheck_snapshot, bool read_only, bool fire_triggers, long tcount) { volatile int res = 0; volatile uint32 my_processed = 0; volatile Oid my_lastoid = InvalidOid; SPITupleTable *volatile my_tuptable = NULL; Snapshot saveActiveSnapshot; /* Be sure to restore ActiveSnapshot on error exit */ saveActiveSnapshot = ActiveSnapshot; PG_TRY(); { List *query_list_list = plan->qtlist; ListCell *plan_list_item = list_head(plan->ptlist); ListCell *query_list_list_item; ErrorContextCallback spierrcontext; int nargs = plan->nargs; ParamListInfo paramLI; /* Convert parameters to form wanted by executor */ if (nargs > 0) { int k; paramLI = (ParamListInfo) palloc0((nargs + 1) * sizeof(ParamListInfoData)); for (k = 0; k < nargs; k++) { paramLI[k].kind = PARAM_NUM; paramLI[k].id = k + 1; paramLI[k].ptype = plan->argtypes[k]; paramLI[k].isnull = (Nulls && Nulls[k] == 'n'); paramLI[k].value = Values[k]; } paramLI[k].kind = PARAM_INVALID; } else paramLI = NULL; /* * Setup error traceback support for ereport() */ spierrcontext.callback = _SPI_error_callback; spierrcontext.arg = (void *) plan->query; spierrcontext.previous = error_context_stack; error_context_stack = &spierrcontext; foreach(query_list_list_item, query_list_list) { List *query_list = lfirst(query_list_list_item); ListCell *query_list_item; foreach(query_list_item, query_list) { Query *queryTree = (Query *) lfirst(query_list_item); Plan *planTree; QueryDesc *qdesc; DestReceiver *dest; planTree = lfirst(plan_list_item); plan_list_item = lnext(plan_list_item); _SPI_current->processed = 0; _SPI_current->lastoid = InvalidOid; _SPI_current->tuptable = NULL; if (queryTree->commandType == CMD_UTILITY) { if (IsA(queryTree->utilityStmt, CopyStmt)) { CopyStmt *stmt = (CopyStmt *) queryTree->utilityStmt; if (stmt->filename == NULL) { res = SPI_ERROR_COPY; goto fail; } } else if (IsA(queryTree->utilityStmt, DeclareCursorStmt) || IsA(queryTree->utilityStmt, ClosePortalStmt) || IsA(queryTree->utilityStmt, FetchStmt)) { res = SPI_ERROR_CURSOR; goto fail; } else if (IsA(queryTree->utilityStmt, TransactionStmt)) { res = SPI_ERROR_TRANSACTION; goto fail; } } if (read_only && !QueryIsReadOnly(queryTree)) ereport(ERROR, (errcode(ERRCODE_FEATURE_NOT_SUPPORTED), /* translator: %s is a SQL statement name */ errmsg("%s is not allowed in a non-volatile function", CreateQueryTag(queryTree)))); /* * If not read-only mode, advance the command counter before * each command. */ if (!read_only) CommandCounterIncrement(); dest = CreateDestReceiver(queryTree->canSetTag ? DestSPI : DestNone, NULL); if (snapshot == InvalidSnapshot) { /* * Default read_only behavior is to use the entry-time * ActiveSnapshot; if read-write, grab a full new snap. */ if (read_only) ActiveSnapshot = CopySnapshot(saveActiveSnapshot); else ActiveSnapshot = CopySnapshot(GetTransactionSnapshot()); } else { /* * We interpret read_only with a specified snapshot to be * exactly that snapshot, but read-write means use the * snap with advancing of command ID. */ ActiveSnapshot = CopySnapshot(snapshot); if (!read_only) ActiveSnapshot->curcid = GetCurrentCommandId(); } if (queryTree->commandType == CMD_UTILITY) { ProcessUtility(queryTree->utilityStmt, paramLI, dest, NULL); res = SPI_OK_UTILITY; } else { qdesc = CreateQueryDesc(queryTree, planTree, ActiveSnapshot, crosscheck_snapshot, dest, paramLI, false); res = _SPI_pquery(qdesc, fire_triggers, queryTree->canSetTag ? tcount : 0); FreeQueryDesc(qdesc); } FreeSnapshot(ActiveSnapshot); ActiveSnapshot = NULL; /* * The last canSetTag query sets the auxiliary values returned * to the caller. Be careful to free any tuptables not * returned, to avoid intratransaction memory leak. */ if (queryTree->canSetTag) { my_processed = _SPI_current->processed; my_lastoid = _SPI_current->lastoid; SPI_freetuptable(my_tuptable); my_tuptable = _SPI_current->tuptable; } else { SPI_freetuptable(_SPI_current->tuptable); _SPI_current->tuptable = NULL; } /* we know that the receiver doesn't need a destroy call */ if (res < 0) goto fail; } } fail: /* * Pop the error context stack */ error_context_stack = spierrcontext.previous; } PG_CATCH(); { /* Restore global vars and propagate error */ ActiveSnapshot = saveActiveSnapshot; PG_RE_THROW(); } PG_END_TRY(); ActiveSnapshot = saveActiveSnapshot; /* Save results for caller */ SPI_processed = my_processed; SPI_lastoid = my_lastoid; SPI_tuptable = my_tuptable; return res; } //调用执行器 static int _SPI_pquery(QueryDesc *queryDesc, bool fire_triggers, long tcount) { int operation = queryDesc->operation; int res; switch (operation) { case CMD_SELECT: res = SPI_OK_SELECT; if (queryDesc->parsetree->into) /* select into table? */ { res = SPI_OK_SELINTO; queryDesc->dest = None_Receiver; /* don't output results */ } else if (queryDesc->dest->mydest != DestSPI) { /* Don't return SPI_OK_SELECT if we're discarding result */ res = SPI_OK_UTILITY; } break; case CMD_INSERT: res = SPI_OK_INSERT; break; case CMD_DELETE: res = SPI_OK_DELETE; break; case CMD_UPDATE: res = SPI_OK_UPDATE; break; default: return SPI_ERROR_OPUNKNOWN; } #ifdef SPI_EXECUTOR_STATS if (ShowExecutorStats) ResetUsage(); #endif if (fire_triggers) AfterTriggerBeginQuery(); ExecutorStart(queryDesc, false); ExecutorRun(queryDesc, ForwardScanDirection, tcount); _SPI_current->processed = queryDesc->estate->es_processed; _SPI_current->lastoid = queryDesc->estate->es_lastoid; if (operation == CMD_SELECT && queryDesc->dest->mydest == DestSPI) { if (_SPI_checktuples()) elog(ERROR, "consistency check on SPI tuple count failed"); } /* Take care of any queued AFTER triggers */ if (fire_triggers) AfterTriggerEndQuery(queryDesc->estate); ExecutorEnd(queryDesc); #ifdef SPI_EXECUTOR_STATS if (ShowExecutorStats) ShowUsage("SPI EXECUTOR STATS"); #endif return res; }

赞

签名档

编辑签名档

发表 取消

• 关于word 中的编号 2011-07-01 15:56
• 审核 2012-07-18 10:49
• (转)诺基亚手机三种通用刷机教程 2012-02-16 19:29
• 2011-7-21 2011-07-21 16:49

• 互动(0)

显示评论签名

全选 删除取消批量删除批量删除

提示 QQ空间郑重承诺：致力于为用户提供绿色、健康的网络空间！坚决杜绝低俗、恶意、等不良信息，在此愿每位QQ空间用户共同参与维护！对您的举报信息我们将第一时间核查处理，请点击：了解QQ空间举报入口

由于IE浏览器升级禁用了alt+x快捷键，请用alt+q快捷键来快速进入写说说入口

正在加载中...