PostgreSQL Source Code git master
Loading...
Searching...
No Matches
utility.h File Reference
#include "tcop/cmdtag.h"
#include "tcop/tcopprot.h"
Include dependency graph for utility.h:
This graph shows which files directly or indirectly include this file:

Go to the source code of this file.

Data Structures

struct  AlterTableUtilityContext
 

Macros

#define COMMAND_OK_IN_READ_ONLY_TXN   0x0001
 
#define COMMAND_OK_IN_PARALLEL_MODE   0x0002
 
#define COMMAND_OK_IN_RECOVERY   0x0004
 
#define COMMAND_IS_STRICTLY_READ_ONLY
 
#define COMMAND_IS_NOT_READ_ONLY   0
 

Typedefs

typedef struct AlterTableUtilityContext AlterTableUtilityContext
 
typedef void(* ProcessUtility_hook_type) (PlannedStmt *pstmt, const char *queryString, bool readOnlyTree, ProcessUtilityContext context, ParamListInfo params, QueryEnvironment *queryEnv, DestReceiver *dest, QueryCompletion *qc)
 

Enumerations

enum  ProcessUtilityContext { PROCESS_UTILITY_TOPLEVEL , PROCESS_UTILITY_QUERY , PROCESS_UTILITY_QUERY_NONATOMIC , PROCESS_UTILITY_SUBCOMMAND }
 

Functions

void ProcessUtility (PlannedStmt *pstmt, const char *queryString, bool readOnlyTree, ProcessUtilityContext context, ParamListInfo params, QueryEnvironment *queryEnv, DestReceiver *dest, QueryCompletion *qc)
 
void standard_ProcessUtility (PlannedStmt *pstmt, const char *queryString, bool readOnlyTree, ProcessUtilityContext context, ParamListInfo params, QueryEnvironment *queryEnv, DestReceiver *dest, QueryCompletion *qc)
 
void ProcessUtilityForAlterTable (Node *stmt, AlterTableUtilityContext *context)
 
bool UtilityReturnsTuples (Node *parsetree)
 
TupleDesc UtilityTupleDescriptor (Node *parsetree)
 
QueryUtilityContainsQuery (Node *parsetree)
 
CommandTag CreateCommandTag (Node *parsetree)
 
static const charCreateCommandName (Node *parsetree)
 
LogStmtLevel GetCommandLogLevel (Node *parsetree)
 
bool CommandIsReadOnly (PlannedStmt *pstmt)
 

Variables

PGDLLIMPORT ProcessUtility_hook_type ProcessUtility_hook
 

Macro Definition Documentation

◆ COMMAND_IS_NOT_READ_ONLY

#define COMMAND_IS_NOT_READ_ONLY   0

Definition at line 68 of file utility.h.

◆ COMMAND_IS_STRICTLY_READ_ONLY

#define COMMAND_IS_STRICTLY_READ_ONLY
Value:
#define COMMAND_OK_IN_PARALLEL_MODE
Definition utility.h:57
#define COMMAND_OK_IN_RECOVERY
Definition utility.h:58
#define COMMAND_OK_IN_READ_ONLY_TXN
Definition utility.h:56

Definition at line 65 of file utility.h.

104{
105 return GetCommandTagName(CreateCommandTag(parsetree));
106}
107
108extern LogStmtLevel GetCommandLogLevel(Node *parsetree);
109
110extern bool CommandIsReadOnly(PlannedStmt *pstmt);
111
112#endif /* UTILITY_H */
const char * GetCommandTagName(CommandTag commandTag)
Definition cmdtag.c:47
Definition nodes.h:135
LogStmtLevel
Definition tcopprot.h:33
bool CommandIsReadOnly(PlannedStmt *pstmt)
Definition utility.c:95
CommandTag CreateCommandTag(Node *parsetree)
Definition utility.c:2369
LogStmtLevel GetCommandLogLevel(Node *parsetree)
Definition utility.c:3260

◆ COMMAND_OK_IN_PARALLEL_MODE

#define COMMAND_OK_IN_PARALLEL_MODE   0x0002

Definition at line 57 of file utility.h.

◆ COMMAND_OK_IN_READ_ONLY_TXN

#define COMMAND_OK_IN_READ_ONLY_TXN   0x0001

Definition at line 56 of file utility.h.

◆ COMMAND_OK_IN_RECOVERY

#define COMMAND_OK_IN_RECOVERY   0x0004

Definition at line 58 of file utility.h.

Typedef Documentation

◆ AlterTableUtilityContext

◆ ProcessUtility_hook_type

typedef void(* ProcessUtility_hook_type) (PlannedStmt *pstmt, const char *queryString, bool readOnlyTree, ProcessUtilityContext context, ParamListInfo params, QueryEnvironment *queryEnv, DestReceiver *dest, QueryCompletion *qc)

Definition at line 71 of file utility.h.

Enumeration Type Documentation

◆ ProcessUtilityContext

Enumerator
PROCESS_UTILITY_TOPLEVEL 
PROCESS_UTILITY_QUERY 
PROCESS_UTILITY_QUERY_NONATOMIC 
PROCESS_UTILITY_SUBCOMMAND 

Definition at line 20 of file utility.h.

21{
22 PROCESS_UTILITY_TOPLEVEL, /* toplevel interactive command */
23 PROCESS_UTILITY_QUERY, /* a complete query, but not toplevel */
24 PROCESS_UTILITY_QUERY_NONATOMIC, /* a complete query, nonatomic
25 * execution context */
26 PROCESS_UTILITY_SUBCOMMAND, /* a portion of a query */
ProcessUtilityContext
Definition utility.h:21
@ PROCESS_UTILITY_SUBCOMMAND
Definition utility.h:26
@ PROCESS_UTILITY_TOPLEVEL
Definition utility.h:22
@ PROCESS_UTILITY_QUERY_NONATOMIC
Definition utility.h:24
@ PROCESS_UTILITY_QUERY
Definition utility.h:23

Function Documentation

◆ CommandIsReadOnly()

bool CommandIsReadOnly ( PlannedStmt pstmt)
extern

Definition at line 95 of file utility.c.

96{
97 Assert(IsA(pstmt, PlannedStmt));
98 switch (pstmt->commandType)
99 {
100 case CMD_SELECT:
101 if (pstmt->rowMarks != NIL)
102 return false; /* SELECT FOR [KEY] UPDATE/SHARE */
103 else if (pstmt->hasModifyingCTE)
104 return false; /* data-modifying CTE */
105 else
106 return true;
107 case CMD_UPDATE:
108 case CMD_INSERT:
109 case CMD_DELETE:
110 case CMD_MERGE:
111 return false;
112 case CMD_UTILITY:
113 /* For now, treat all utility commands as read/write */
114 return false;
115 default:
116 elog(WARNING, "unrecognized commandType: %d",
117 (int) pstmt->commandType);
118 break;
119 }
120 return false;
121}
#define Assert(condition)
Definition c.h:873
#define WARNING
Definition elog.h:36
#define elog(elevel,...)
Definition elog.h:226
#define IsA(nodeptr, _type_)
Definition nodes.h:164
@ CMD_MERGE
Definition nodes.h:279
@ CMD_UTILITY
Definition nodes.h:280
@ CMD_INSERT
Definition nodes.h:277
@ CMD_DELETE
Definition nodes.h:278
@ CMD_UPDATE
Definition nodes.h:276
@ CMD_SELECT
Definition nodes.h:275
#define NIL
Definition pg_list.h:68
bool hasModifyingCTE
Definition plannodes.h:83
List * rowMarks
Definition plannodes.h:138
CmdType commandType
Definition plannodes.h:68

References Assert, CMD_DELETE, CMD_INSERT, CMD_MERGE, CMD_SELECT, CMD_UPDATE, CMD_UTILITY, PlannedStmt::commandType, elog, PlannedStmt::hasModifyingCTE, IsA, NIL, PlannedStmt::rowMarks, and WARNING.

Referenced by _SPI_execute_plan(), init_execution_state(), and SPI_cursor_open_internal().

◆ CreateCommandName()

static const char * CreateCommandName ( Node parsetree)
inlinestatic

◆ CreateCommandTag()

CommandTag CreateCommandTag ( Node parsetree)
extern

Definition at line 2369 of file utility.c.

2370{
2371 CommandTag tag;
2372
2373 switch (nodeTag(parsetree))
2374 {
2375 /* recurse if we're given a RawStmt */
2376 case T_RawStmt:
2377 tag = CreateCommandTag(((RawStmt *) parsetree)->stmt);
2378 break;
2379
2380 /* raw plannable queries */
2381 case T_InsertStmt:
2382 tag = CMDTAG_INSERT;
2383 break;
2384
2385 case T_DeleteStmt:
2386 tag = CMDTAG_DELETE;
2387 break;
2388
2389 case T_UpdateStmt:
2390 tag = CMDTAG_UPDATE;
2391 break;
2392
2393 case T_MergeStmt:
2394 tag = CMDTAG_MERGE;
2395 break;
2396
2397 case T_SelectStmt:
2398 tag = CMDTAG_SELECT;
2399 break;
2400
2401 case T_PLAssignStmt:
2402 tag = CMDTAG_SELECT;
2403 break;
2404
2405 /* utility statements --- same whether raw or cooked */
2406 case T_TransactionStmt:
2407 {
2408 TransactionStmt *stmt = (TransactionStmt *) parsetree;
2409
2410 switch (stmt->kind)
2411 {
2412 case TRANS_STMT_BEGIN:
2413 tag = CMDTAG_BEGIN;
2414 break;
2415
2416 case TRANS_STMT_START:
2418 break;
2419
2420 case TRANS_STMT_COMMIT:
2421 tag = CMDTAG_COMMIT;
2422 break;
2423
2426 tag = CMDTAG_ROLLBACK;
2427 break;
2428
2430 tag = CMDTAG_SAVEPOINT;
2431 break;
2432
2433 case TRANS_STMT_RELEASE:
2434 tag = CMDTAG_RELEASE;
2435 break;
2436
2437 case TRANS_STMT_PREPARE:
2439 break;
2440
2443 break;
2444
2447 break;
2448
2449 default:
2450 tag = CMDTAG_UNKNOWN;
2451 break;
2452 }
2453 }
2454 break;
2455
2458 break;
2459
2460 case T_ClosePortalStmt:
2461 {
2462 ClosePortalStmt *stmt = (ClosePortalStmt *) parsetree;
2463
2464 if (stmt->portalname == NULL)
2466 else
2467 tag = CMDTAG_CLOSE_CURSOR;
2468 }
2469 break;
2470
2471 case T_FetchStmt:
2472 {
2473 FetchStmt *stmt = (FetchStmt *) parsetree;
2474
2475 tag = (stmt->ismove) ? CMDTAG_MOVE : CMDTAG_FETCH;
2476 }
2477 break;
2478
2479 case T_CreateDomainStmt:
2481 break;
2482
2483 case T_CreateSchemaStmt:
2485 break;
2486
2487 case T_CreateStmt:
2488 tag = CMDTAG_CREATE_TABLE;
2489 break;
2490
2493 break;
2494
2497 break;
2498
2501 break;
2502
2505 break;
2506
2509 break;
2510
2513 break;
2514
2515 case T_CreateFdwStmt:
2517 break;
2518
2519 case T_AlterFdwStmt:
2521 break;
2522
2525 break;
2526
2528 tag = CMDTAG_ALTER_SERVER;
2529 break;
2530
2533 break;
2534
2537 break;
2538
2541 break;
2542
2545 break;
2546
2549 break;
2550
2551 case T_DropStmt:
2552 switch (((DropStmt *) parsetree)->removeType)
2553 {
2554 case OBJECT_TABLE:
2555 tag = CMDTAG_DROP_TABLE;
2556 break;
2557 case OBJECT_SEQUENCE:
2559 break;
2560 case OBJECT_VIEW:
2561 tag = CMDTAG_DROP_VIEW;
2562 break;
2563 case OBJECT_MATVIEW:
2565 break;
2566 case OBJECT_INDEX:
2567 tag = CMDTAG_DROP_INDEX;
2568 break;
2569 case OBJECT_TYPE:
2570 tag = CMDTAG_DROP_TYPE;
2571 break;
2572 case OBJECT_DOMAIN:
2573 tag = CMDTAG_DROP_DOMAIN;
2574 break;
2575 case OBJECT_COLLATION:
2577 break;
2578 case OBJECT_CONVERSION:
2580 break;
2581 case OBJECT_SCHEMA:
2582 tag = CMDTAG_DROP_SCHEMA;
2583 break;
2584 case OBJECT_TSPARSER:
2586 break;
2589 break;
2590 case OBJECT_TSTEMPLATE:
2592 break;
2595 break;
2598 break;
2599 case OBJECT_EXTENSION:
2601 break;
2602 case OBJECT_FUNCTION:
2604 break;
2605 case OBJECT_PROCEDURE:
2607 break;
2608 case OBJECT_ROUTINE:
2609 tag = CMDTAG_DROP_ROUTINE;
2610 break;
2611 case OBJECT_AGGREGATE:
2613 break;
2614 case OBJECT_OPERATOR:
2616 break;
2617 case OBJECT_LANGUAGE:
2619 break;
2620 case OBJECT_CAST:
2621 tag = CMDTAG_DROP_CAST;
2622 break;
2623 case OBJECT_TRIGGER:
2624 tag = CMDTAG_DROP_TRIGGER;
2625 break;
2628 break;
2629 case OBJECT_RULE:
2630 tag = CMDTAG_DROP_RULE;
2631 break;
2632 case OBJECT_FDW:
2634 break;
2636 tag = CMDTAG_DROP_SERVER;
2637 break;
2638 case OBJECT_OPCLASS:
2640 break;
2641 case OBJECT_OPFAMILY:
2643 break;
2644 case OBJECT_POLICY:
2645 tag = CMDTAG_DROP_POLICY;
2646 break;
2647 case OBJECT_TRANSFORM:
2649 break;
2652 break;
2653 case OBJECT_PUBLICATION:
2655 break;
2658 break;
2659 default:
2660 tag = CMDTAG_UNKNOWN;
2661 }
2662 break;
2663
2664 case T_TruncateStmt:
2666 break;
2667
2668 case T_CommentStmt:
2669 tag = CMDTAG_COMMENT;
2670 break;
2671
2672 case T_SecLabelStmt:
2674 break;
2675
2676 case T_CopyStmt:
2677 tag = CMDTAG_COPY;
2678 break;
2679
2680 case T_RenameStmt:
2681
2682 /*
2683 * When the column is renamed, the command tag is created from its
2684 * relation type
2685 */
2686 tag = AlterObjectTypeCommandTag(((RenameStmt *) parsetree)->renameType == OBJECT_COLUMN ?
2687 ((RenameStmt *) parsetree)->relationType :
2688 ((RenameStmt *) parsetree)->renameType);
2689 break;
2690
2692 tag = AlterObjectTypeCommandTag(((AlterObjectDependsStmt *) parsetree)->objectType);
2693 break;
2694
2696 tag = AlterObjectTypeCommandTag(((AlterObjectSchemaStmt *) parsetree)->objectType);
2697 break;
2698
2699 case T_AlterOwnerStmt:
2700 tag = AlterObjectTypeCommandTag(((AlterOwnerStmt *) parsetree)->objectType);
2701 break;
2702
2704 tag = AlterObjectTypeCommandTag(((AlterTableMoveAllStmt *) parsetree)->objtype);
2705 break;
2706
2707 case T_AlterTableStmt:
2708 tag = AlterObjectTypeCommandTag(((AlterTableStmt *) parsetree)->objtype);
2709 break;
2710
2711 case T_AlterDomainStmt:
2712 tag = CMDTAG_ALTER_DOMAIN;
2713 break;
2714
2716 switch (((AlterFunctionStmt *) parsetree)->objtype)
2717 {
2718 case OBJECT_FUNCTION:
2720 break;
2721 case OBJECT_PROCEDURE:
2723 break;
2724 case OBJECT_ROUTINE:
2726 break;
2727 default:
2728 tag = CMDTAG_UNKNOWN;
2729 }
2730 break;
2731
2732 case T_GrantStmt:
2733 {
2734 GrantStmt *stmt = (GrantStmt *) parsetree;
2735
2736 tag = (stmt->is_grant) ? CMDTAG_GRANT : CMDTAG_REVOKE;
2737 }
2738 break;
2739
2740 case T_GrantRoleStmt:
2741 {
2742 GrantRoleStmt *stmt = (GrantRoleStmt *) parsetree;
2743
2744 tag = (stmt->is_grant) ? CMDTAG_GRANT_ROLE : CMDTAG_REVOKE_ROLE;
2745 }
2746 break;
2747
2750 break;
2751
2752 case T_DefineStmt:
2753 switch (((DefineStmt *) parsetree)->kind)
2754 {
2755 case OBJECT_AGGREGATE:
2757 break;
2758 case OBJECT_OPERATOR:
2760 break;
2761 case OBJECT_TYPE:
2762 tag = CMDTAG_CREATE_TYPE;
2763 break;
2764 case OBJECT_TSPARSER:
2766 break;
2769 break;
2770 case OBJECT_TSTEMPLATE:
2772 break;
2775 break;
2776 case OBJECT_COLLATION:
2778 break;
2781 break;
2782 default:
2783 tag = CMDTAG_UNKNOWN;
2784 }
2785 break;
2786
2788 tag = CMDTAG_CREATE_TYPE;
2789 break;
2790
2791 case T_CreateEnumStmt:
2792 tag = CMDTAG_CREATE_TYPE;
2793 break;
2794
2795 case T_CreateRangeStmt:
2796 tag = CMDTAG_CREATE_TYPE;
2797 break;
2798
2799 case T_AlterEnumStmt:
2800 tag = CMDTAG_ALTER_TYPE;
2801 break;
2802
2803 case T_ViewStmt:
2804 tag = CMDTAG_CREATE_VIEW;
2805 break;
2806
2808 if (((CreateFunctionStmt *) parsetree)->is_procedure)
2810 else
2812 break;
2813
2814 case T_IndexStmt:
2815 tag = CMDTAG_CREATE_INDEX;
2816 break;
2817
2818 case T_RuleStmt:
2819 tag = CMDTAG_CREATE_RULE;
2820 break;
2821
2822 case T_CreateSeqStmt:
2824 break;
2825
2826 case T_AlterSeqStmt:
2828 break;
2829
2830 case T_DoStmt:
2831 tag = CMDTAG_DO;
2832 break;
2833
2834 case T_CreatedbStmt:
2836 break;
2837
2842 break;
2843
2844 case T_DropdbStmt:
2846 break;
2847
2848 case T_NotifyStmt:
2849 tag = CMDTAG_NOTIFY;
2850 break;
2851
2852 case T_ListenStmt:
2853 tag = CMDTAG_LISTEN;
2854 break;
2855
2856 case T_UnlistenStmt:
2857 tag = CMDTAG_UNLISTEN;
2858 break;
2859
2860 case T_LoadStmt:
2861 tag = CMDTAG_LOAD;
2862 break;
2863
2864 case T_CallStmt:
2865 tag = CMDTAG_CALL;
2866 break;
2867
2868 case T_ClusterStmt:
2869 tag = CMDTAG_CLUSTER;
2870 break;
2871
2872 case T_VacuumStmt:
2873 if (((VacuumStmt *) parsetree)->is_vacuumcmd)
2874 tag = CMDTAG_VACUUM;
2875 else
2876 tag = CMDTAG_ANALYZE;
2877 break;
2878
2879 case T_ExplainStmt:
2880 tag = CMDTAG_EXPLAIN;
2881 break;
2882
2884 switch (((CreateTableAsStmt *) parsetree)->objtype)
2885 {
2886 case OBJECT_TABLE:
2887 if (((CreateTableAsStmt *) parsetree)->is_select_into)
2888 tag = CMDTAG_SELECT_INTO;
2889 else
2891 break;
2892 case OBJECT_MATVIEW:
2894 break;
2895 default:
2896 tag = CMDTAG_UNKNOWN;
2897 }
2898 break;
2899
2902 break;
2903
2904 case T_AlterSystemStmt:
2905 tag = CMDTAG_ALTER_SYSTEM;
2906 break;
2907
2908 case T_VariableSetStmt:
2909 switch (((VariableSetStmt *) parsetree)->kind)
2910 {
2911 case VAR_SET_VALUE:
2912 case VAR_SET_CURRENT:
2913 case VAR_SET_DEFAULT:
2914 case VAR_SET_MULTI:
2915 tag = CMDTAG_SET;
2916 break;
2917 case VAR_RESET:
2918 case VAR_RESET_ALL:
2919 tag = CMDTAG_RESET;
2920 break;
2921 default:
2922 tag = CMDTAG_UNKNOWN;
2923 }
2924 break;
2925
2926 case T_VariableShowStmt:
2927 tag = CMDTAG_SHOW;
2928 break;
2929
2930 case T_DiscardStmt:
2931 switch (((DiscardStmt *) parsetree)->target)
2932 {
2933 case DISCARD_ALL:
2934 tag = CMDTAG_DISCARD_ALL;
2935 break;
2936 case DISCARD_PLANS:
2938 break;
2939 case DISCARD_TEMP:
2940 tag = CMDTAG_DISCARD_TEMP;
2941 break;
2942 case DISCARD_SEQUENCES:
2944 break;
2945 default:
2946 tag = CMDTAG_UNKNOWN;
2947 }
2948 break;
2949
2952 break;
2953
2954 case T_CreateTrigStmt:
2956 break;
2957
2960 break;
2961
2964 break;
2965
2966 case T_CreatePLangStmt:
2968 break;
2969
2970 case T_CreateRoleStmt:
2971 tag = CMDTAG_CREATE_ROLE;
2972 break;
2973
2974 case T_AlterRoleStmt:
2975 tag = CMDTAG_ALTER_ROLE;
2976 break;
2977
2978 case T_AlterRoleSetStmt:
2979 tag = CMDTAG_ALTER_ROLE;
2980 break;
2981
2982 case T_DropRoleStmt:
2983 tag = CMDTAG_DROP_ROLE;
2984 break;
2985
2986 case T_DropOwnedStmt:
2987 tag = CMDTAG_DROP_OWNED;
2988 break;
2989
2992 break;
2993
2994 case T_LockStmt:
2995 tag = CMDTAG_LOCK_TABLE;
2996 break;
2997
3000 break;
3001
3002 case T_CheckPointStmt:
3003 tag = CMDTAG_CHECKPOINT;
3004 break;
3005
3006 case T_ReindexStmt:
3007 tag = CMDTAG_REINDEX;
3008 break;
3009
3012 break;
3013
3014 case T_CreateCastStmt:
3015 tag = CMDTAG_CREATE_CAST;
3016 break;
3017
3020 break;
3021
3024 break;
3025
3028 break;
3029
3032 break;
3033
3034 case T_AlterTypeStmt:
3035 tag = CMDTAG_ALTER_TYPE;
3036 break;
3037
3040 break;
3041
3044 break;
3045
3046 case T_CreatePolicyStmt:
3048 break;
3049
3050 case T_AlterPolicyStmt:
3051 tag = CMDTAG_ALTER_POLICY;
3052 break;
3053
3054 case T_CreateAmStmt:
3056 break;
3057
3060 break;
3061
3064 break;
3065
3068 break;
3069
3072 break;
3073
3076 break;
3077
3080 break;
3081
3082 case T_PrepareStmt:
3083 tag = CMDTAG_PREPARE;
3084 break;
3085
3086 case T_ExecuteStmt:
3087 tag = CMDTAG_EXECUTE;
3088 break;
3089
3090 case T_CreateStatsStmt:
3092 break;
3093
3094 case T_AlterStatsStmt:
3096 break;
3097
3098 case T_DeallocateStmt:
3099 {
3100 DeallocateStmt *stmt = (DeallocateStmt *) parsetree;
3101
3102 if (stmt->name == NULL)
3104 else
3105 tag = CMDTAG_DEALLOCATE;
3106 }
3107 break;
3108
3109 case T_WaitStmt:
3110 tag = CMDTAG_WAIT;
3111 break;
3112
3113 /* already-planned queries */
3114 case T_PlannedStmt:
3115 {
3116 PlannedStmt *stmt = (PlannedStmt *) parsetree;
3117
3118 switch (stmt->commandType)
3119 {
3120 case CMD_SELECT:
3121
3122 /*
3123 * We take a little extra care here so that the result
3124 * will be useful for complaints about read-only
3125 * statements
3126 */
3127 if (stmt->rowMarks != NIL)
3128 {
3129 /* not 100% but probably close enough */
3130 switch (((PlanRowMark *) linitial(stmt->rowMarks))->strength)
3131 {
3132 case LCS_FORKEYSHARE:
3134 break;
3135 case LCS_FORSHARE:
3137 break;
3138 case LCS_FORNOKEYUPDATE:
3140 break;
3141 case LCS_FORUPDATE:
3143 break;
3144 default:
3145 tag = CMDTAG_SELECT;
3146 break;
3147 }
3148 }
3149 else
3150 tag = CMDTAG_SELECT;
3151 break;
3152 case CMD_UPDATE:
3153 tag = CMDTAG_UPDATE;
3154 break;
3155 case CMD_INSERT:
3156 tag = CMDTAG_INSERT;
3157 break;
3158 case CMD_DELETE:
3159 tag = CMDTAG_DELETE;
3160 break;
3161 case CMD_MERGE:
3162 tag = CMDTAG_MERGE;
3163 break;
3164 case CMD_UTILITY:
3165 tag = CreateCommandTag(stmt->utilityStmt);
3166 break;
3167 default:
3168 elog(WARNING, "unrecognized commandType: %d",
3169 (int) stmt->commandType);
3170 tag = CMDTAG_UNKNOWN;
3171 break;
3172 }
3173 }
3174 break;
3175
3176 /* parsed-and-rewritten-but-not-planned queries */
3177 case T_Query:
3178 {
3179 Query *stmt = (Query *) parsetree;
3180
3181 switch (stmt->commandType)
3182 {
3183 case CMD_SELECT:
3184
3185 /*
3186 * We take a little extra care here so that the result
3187 * will be useful for complaints about read-only
3188 * statements
3189 */
3190 if (stmt->rowMarks != NIL)
3191 {
3192 /* not 100% but probably close enough */
3193 switch (((RowMarkClause *) linitial(stmt->rowMarks))->strength)
3194 {
3195 case LCS_FORKEYSHARE:
3197 break;
3198 case LCS_FORSHARE:
3200 break;
3201 case LCS_FORNOKEYUPDATE:
3203 break;
3204 case LCS_FORUPDATE:
3206 break;
3207 default:
3208 tag = CMDTAG_UNKNOWN;
3209 break;
3210 }
3211 }
3212 else
3213 tag = CMDTAG_SELECT;
3214 break;
3215 case CMD_UPDATE:
3216 tag = CMDTAG_UPDATE;
3217 break;
3218 case CMD_INSERT:
3219 tag = CMDTAG_INSERT;
3220 break;
3221 case CMD_DELETE:
3222 tag = CMDTAG_DELETE;
3223 break;
3224 case CMD_MERGE:
3225 tag = CMDTAG_MERGE;
3226 break;
3227 case CMD_UTILITY:
3228 tag = CreateCommandTag(stmt->utilityStmt);
3229 break;
3230 default:
3231 elog(WARNING, "unrecognized commandType: %d",
3232 (int) stmt->commandType);
3233 tag = CMDTAG_UNKNOWN;
3234 break;
3235 }
3236 }
3237 break;
3238
3239 default:
3240 elog(WARNING, "unrecognized node type: %d",
3241 (int) nodeTag(parsetree));
3242 tag = CMDTAG_UNKNOWN;
3243 break;
3244 }
3245
3246 return tag;
3247}
CommandTag
Definition cmdtag.h:23
#define stmt
@ LCS_FORUPDATE
Definition lockoptions.h:27
@ LCS_FORSHARE
Definition lockoptions.h:25
@ LCS_FORKEYSHARE
Definition lockoptions.h:24
@ LCS_FORNOKEYUPDATE
Definition lockoptions.h:26
#define nodeTag(nodeptr)
Definition nodes.h:139
@ TRANS_STMT_ROLLBACK_TO
@ TRANS_STMT_START
@ TRANS_STMT_SAVEPOINT
@ TRANS_STMT_BEGIN
@ TRANS_STMT_ROLLBACK
@ TRANS_STMT_COMMIT_PREPARED
@ TRANS_STMT_COMMIT
@ TRANS_STMT_ROLLBACK_PREPARED
@ TRANS_STMT_PREPARE
@ TRANS_STMT_RELEASE
@ VAR_SET_DEFAULT
@ VAR_RESET
@ VAR_SET_MULTI
@ VAR_SET_VALUE
@ VAR_SET_CURRENT
@ VAR_RESET_ALL
@ OBJECT_EVENT_TRIGGER
@ OBJECT_FDW
@ OBJECT_TSPARSER
@ OBJECT_COLLATION
@ OBJECT_ACCESS_METHOD
@ OBJECT_OPCLASS
@ OBJECT_AGGREGATE
@ OBJECT_MATVIEW
@ OBJECT_SCHEMA
@ OBJECT_POLICY
@ OBJECT_OPERATOR
@ OBJECT_FOREIGN_TABLE
@ OBJECT_TSCONFIGURATION
@ OBJECT_OPFAMILY
@ OBJECT_DOMAIN
@ OBJECT_COLUMN
@ OBJECT_ROUTINE
@ OBJECT_PROCEDURE
@ OBJECT_EXTENSION
@ OBJECT_INDEX
@ OBJECT_SEQUENCE
@ OBJECT_TSTEMPLATE
@ OBJECT_LANGUAGE
@ OBJECT_FOREIGN_SERVER
@ OBJECT_TSDICTIONARY
@ OBJECT_PUBLICATION
@ OBJECT_RULE
@ OBJECT_CONVERSION
@ OBJECT_TABLE
@ OBJECT_VIEW
@ OBJECT_TYPE
@ OBJECT_FUNCTION
@ OBJECT_STATISTIC_EXT
@ OBJECT_CAST
@ OBJECT_TRIGGER
@ OBJECT_TRANSFORM
@ DISCARD_ALL
@ DISCARD_PLANS
@ DISCARD_SEQUENCES
@ DISCARD_TEMP
#define linitial(l)
Definition pg_list.h:178
static int fb(int x)
CommandTag CreateCommandTag(Node *parsetree)
Definition utility.c:2369
static CommandTag AlterObjectTypeCommandTag(ObjectType objtype)
Definition utility.c:2223

References AlterObjectTypeCommandTag(), CMD_DELETE, CMD_INSERT, CMD_MERGE, CMD_SELECT, CMD_UPDATE, CMD_UTILITY, CreateCommandTag(), DISCARD_ALL, DISCARD_PLANS, DISCARD_SEQUENCES, DISCARD_TEMP, elog, fb(), LCS_FORKEYSHARE, LCS_FORNOKEYUPDATE, LCS_FORSHARE, LCS_FORUPDATE, linitial, NIL, nodeTag, OBJECT_ACCESS_METHOD, OBJECT_AGGREGATE, OBJECT_CAST, OBJECT_COLLATION, OBJECT_COLUMN, OBJECT_CONVERSION, OBJECT_DOMAIN, OBJECT_EVENT_TRIGGER, OBJECT_EXTENSION, OBJECT_FDW, OBJECT_FOREIGN_SERVER, OBJECT_FOREIGN_TABLE, OBJECT_FUNCTION, OBJECT_INDEX, OBJECT_LANGUAGE, OBJECT_MATVIEW, OBJECT_OPCLASS, OBJECT_OPERATOR, OBJECT_OPFAMILY, OBJECT_POLICY, OBJECT_PROCEDURE, OBJECT_PUBLICATION, OBJECT_ROUTINE, OBJECT_RULE, OBJECT_SCHEMA, OBJECT_SEQUENCE, OBJECT_STATISTIC_EXT, OBJECT_TABLE, OBJECT_TRANSFORM, OBJECT_TRIGGER, OBJECT_TSCONFIGURATION, OBJECT_TSDICTIONARY, OBJECT_TSPARSER, OBJECT_TSTEMPLATE, OBJECT_TYPE, OBJECT_VIEW, stmt, TRANS_STMT_BEGIN, TRANS_STMT_COMMIT, TRANS_STMT_COMMIT_PREPARED, TRANS_STMT_PREPARE, TRANS_STMT_RELEASE, TRANS_STMT_ROLLBACK, TRANS_STMT_ROLLBACK_PREPARED, TRANS_STMT_ROLLBACK_TO, TRANS_STMT_SAVEPOINT, TRANS_STMT_START, VAR_RESET, VAR_RESET_ALL, VAR_SET_CURRENT, VAR_SET_DEFAULT, VAR_SET_MULTI, VAR_SET_VALUE, and WARNING.

Referenced by _SPI_prepare_oneshot_plan(), _SPI_prepare_plan(), CreateCommandName(), CreateCommandTag(), EventTriggerGetTag(), exec_parse_message(), exec_simple_query(), interpret_AS_clause(), prepare_next_query(), PrepareQuery(), REGRESS_utility_command(), and standard_ProcessUtility().

◆ GetCommandLogLevel()

LogStmtLevel GetCommandLogLevel ( Node parsetree)
extern

Definition at line 3260 of file utility.c.

3261{
3263
3264 switch (nodeTag(parsetree))
3265 {
3266 /* recurse if we're given a RawStmt */
3267 case T_RawStmt:
3268 lev = GetCommandLogLevel(((RawStmt *) parsetree)->stmt);
3269 break;
3270
3271 /* raw plannable queries */
3272 case T_InsertStmt:
3273 case T_DeleteStmt:
3274 case T_UpdateStmt:
3275 case T_MergeStmt:
3276 lev = LOGSTMT_MOD;
3277 break;
3278
3279 case T_SelectStmt:
3280 if (((SelectStmt *) parsetree)->intoClause)
3281 lev = LOGSTMT_DDL; /* SELECT INTO */
3282 else
3283 lev = LOGSTMT_ALL;
3284 break;
3285
3286 case T_PLAssignStmt:
3287 lev = LOGSTMT_ALL;
3288 break;
3289
3290 /* utility statements --- same whether raw or cooked */
3291 case T_TransactionStmt:
3292 lev = LOGSTMT_ALL;
3293 break;
3294
3296 lev = LOGSTMT_ALL;
3297 break;
3298
3299 case T_ClosePortalStmt:
3300 lev = LOGSTMT_ALL;
3301 break;
3302
3303 case T_FetchStmt:
3304 lev = LOGSTMT_ALL;
3305 break;
3306
3307 case T_CreateSchemaStmt:
3308 lev = LOGSTMT_DDL;
3309 break;
3310
3311 case T_CreateStmt:
3313 lev = LOGSTMT_DDL;
3314 break;
3315
3319 lev = LOGSTMT_DDL;
3320 break;
3321
3325 lev = LOGSTMT_DDL;
3326 break;
3327
3328 case T_CreateFdwStmt:
3329 case T_AlterFdwStmt:
3336 lev = LOGSTMT_DDL;
3337 break;
3338
3339 case T_DropStmt:
3340 lev = LOGSTMT_DDL;
3341 break;
3342
3343 case T_TruncateStmt:
3344 lev = LOGSTMT_MOD;
3345 break;
3346
3347 case T_CommentStmt:
3348 lev = LOGSTMT_DDL;
3349 break;
3350
3351 case T_SecLabelStmt:
3352 lev = LOGSTMT_DDL;
3353 break;
3354
3355 case T_CopyStmt:
3356 if (((CopyStmt *) parsetree)->is_from)
3357 lev = LOGSTMT_MOD;
3358 else
3359 lev = LOGSTMT_ALL;
3360 break;
3361
3362 case T_PrepareStmt:
3363 {
3364 PrepareStmt *stmt = (PrepareStmt *) parsetree;
3365
3366 /* Look through a PREPARE to the contained stmt */
3367 lev = GetCommandLogLevel(stmt->query);
3368 }
3369 break;
3370
3371 case T_ExecuteStmt:
3372 {
3373 ExecuteStmt *stmt = (ExecuteStmt *) parsetree;
3375
3376 /* Look through an EXECUTE to the referenced stmt */
3377 ps = FetchPreparedStatement(stmt->name, false);
3378 if (ps && ps->plansource->raw_parse_tree)
3379 lev = GetCommandLogLevel(ps->plansource->raw_parse_tree->stmt);
3380 else
3381 lev = LOGSTMT_ALL;
3382 }
3383 break;
3384
3385 case T_DeallocateStmt:
3386 lev = LOGSTMT_ALL;
3387 break;
3388
3389 case T_RenameStmt:
3390 lev = LOGSTMT_DDL;
3391 break;
3392
3394 lev = LOGSTMT_DDL;
3395 break;
3396
3398 lev = LOGSTMT_DDL;
3399 break;
3400
3401 case T_AlterOwnerStmt:
3402 lev = LOGSTMT_DDL;
3403 break;
3404
3406 lev = LOGSTMT_DDL;
3407 break;
3408
3409 case T_AlterTypeStmt:
3410 lev = LOGSTMT_DDL;
3411 break;
3412
3414 case T_AlterTableStmt:
3415 lev = LOGSTMT_DDL;
3416 break;
3417
3418 case T_AlterDomainStmt:
3419 lev = LOGSTMT_DDL;
3420 break;
3421
3422 case T_GrantStmt:
3423 lev = LOGSTMT_DDL;
3424 break;
3425
3426 case T_GrantRoleStmt:
3427 lev = LOGSTMT_DDL;
3428 break;
3429
3431 lev = LOGSTMT_DDL;
3432 break;
3433
3434 case T_DefineStmt:
3435 lev = LOGSTMT_DDL;
3436 break;
3437
3439 lev = LOGSTMT_DDL;
3440 break;
3441
3442 case T_CreateEnumStmt:
3443 lev = LOGSTMT_DDL;
3444 break;
3445
3446 case T_CreateRangeStmt:
3447 lev = LOGSTMT_DDL;
3448 break;
3449
3450 case T_AlterEnumStmt:
3451 lev = LOGSTMT_DDL;
3452 break;
3453
3454 case T_ViewStmt:
3455 lev = LOGSTMT_DDL;
3456 break;
3457
3459 lev = LOGSTMT_DDL;
3460 break;
3461
3463 lev = LOGSTMT_DDL;
3464 break;
3465
3466 case T_IndexStmt:
3467 lev = LOGSTMT_DDL;
3468 break;
3469
3470 case T_RuleStmt:
3471 lev = LOGSTMT_DDL;
3472 break;
3473
3474 case T_CreateSeqStmt:
3475 lev = LOGSTMT_DDL;
3476 break;
3477
3478 case T_AlterSeqStmt:
3479 lev = LOGSTMT_DDL;
3480 break;
3481
3482 case T_DoStmt:
3483 lev = LOGSTMT_ALL;
3484 break;
3485
3486 case T_CreatedbStmt:
3487 lev = LOGSTMT_DDL;
3488 break;
3489
3493 lev = LOGSTMT_DDL;
3494 break;
3495
3496 case T_DropdbStmt:
3497 lev = LOGSTMT_DDL;
3498 break;
3499
3500 case T_NotifyStmt:
3501 lev = LOGSTMT_ALL;
3502 break;
3503
3504 case T_ListenStmt:
3505 lev = LOGSTMT_ALL;
3506 break;
3507
3508 case T_UnlistenStmt:
3509 lev = LOGSTMT_ALL;
3510 break;
3511
3512 case T_LoadStmt:
3513 lev = LOGSTMT_ALL;
3514 break;
3515
3516 case T_CallStmt:
3517 lev = LOGSTMT_ALL;
3518 break;
3519
3520 case T_ClusterStmt:
3521 lev = LOGSTMT_DDL;
3522 break;
3523
3524 case T_VacuumStmt:
3525 lev = LOGSTMT_ALL;
3526 break;
3527
3528 case T_ExplainStmt:
3529 {
3530 ExplainStmt *stmt = (ExplainStmt *) parsetree;
3531 bool analyze = false;
3532 ListCell *lc;
3533
3534 /* Look through an EXPLAIN ANALYZE to the contained stmt */
3535 foreach(lc, stmt->options)
3536 {
3537 DefElem *opt = (DefElem *) lfirst(lc);
3538
3539 if (strcmp(opt->defname, "analyze") == 0)
3540 analyze = defGetBoolean(opt);
3541 /* don't "break", as explain.c will use the last value */
3542 }
3543 if (analyze)
3544 return GetCommandLogLevel(stmt->query);
3545
3546 /* Plain EXPLAIN isn't so interesting */
3547 lev = LOGSTMT_ALL;
3548 }
3549 break;
3550
3552 lev = LOGSTMT_DDL;
3553 break;
3554
3556 lev = LOGSTMT_DDL;
3557 break;
3558
3559 case T_AlterSystemStmt:
3560 lev = LOGSTMT_DDL;
3561 break;
3562
3563 case T_VariableSetStmt:
3564 lev = LOGSTMT_ALL;
3565 break;
3566
3567 case T_VariableShowStmt:
3568 lev = LOGSTMT_ALL;
3569 break;
3570
3571 case T_DiscardStmt:
3572 lev = LOGSTMT_ALL;
3573 break;
3574
3575 case T_CreateTrigStmt:
3576 lev = LOGSTMT_DDL;
3577 break;
3578
3580 lev = LOGSTMT_DDL;
3581 break;
3582
3584 lev = LOGSTMT_DDL;
3585 break;
3586
3587 case T_CreatePLangStmt:
3588 lev = LOGSTMT_DDL;
3589 break;
3590
3591 case T_CreateDomainStmt:
3592 lev = LOGSTMT_DDL;
3593 break;
3594
3595 case T_CreateRoleStmt:
3596 lev = LOGSTMT_DDL;
3597 break;
3598
3599 case T_AlterRoleStmt:
3600 lev = LOGSTMT_DDL;
3601 break;
3602
3603 case T_AlterRoleSetStmt:
3604 lev = LOGSTMT_DDL;
3605 break;
3606
3607 case T_DropRoleStmt:
3608 lev = LOGSTMT_DDL;
3609 break;
3610
3611 case T_DropOwnedStmt:
3612 lev = LOGSTMT_DDL;
3613 break;
3614
3616 lev = LOGSTMT_DDL;
3617 break;
3618
3619 case T_LockStmt:
3620 lev = LOGSTMT_ALL;
3621 break;
3622
3624 lev = LOGSTMT_ALL;
3625 break;
3626
3627 case T_CheckPointStmt:
3628 lev = LOGSTMT_ALL;
3629 break;
3630
3631 case T_ReindexStmt:
3632 lev = LOGSTMT_ALL; /* should this be DDL? */
3633 break;
3634
3636 lev = LOGSTMT_DDL;
3637 break;
3638
3639 case T_CreateCastStmt:
3640 lev = LOGSTMT_DDL;
3641 break;
3642
3644 lev = LOGSTMT_DDL;
3645 break;
3646
3648 lev = LOGSTMT_DDL;
3649 break;
3650
3652 lev = LOGSTMT_DDL;
3653 break;
3654
3656 lev = LOGSTMT_DDL;
3657 break;
3658
3659 case T_CreatePolicyStmt:
3660 lev = LOGSTMT_DDL;
3661 break;
3662
3663 case T_AlterPolicyStmt:
3664 lev = LOGSTMT_DDL;
3665 break;
3666
3668 lev = LOGSTMT_DDL;
3669 break;
3670
3672 lev = LOGSTMT_DDL;
3673 break;
3674
3675 case T_CreateAmStmt:
3676 lev = LOGSTMT_DDL;
3677 break;
3678
3680 lev = LOGSTMT_DDL;
3681 break;
3682
3684 lev = LOGSTMT_DDL;
3685 break;
3686
3688 lev = LOGSTMT_DDL;
3689 break;
3690
3692 lev = LOGSTMT_DDL;
3693 break;
3694
3696 lev = LOGSTMT_DDL;
3697 break;
3698
3699 case T_CreateStatsStmt:
3700 lev = LOGSTMT_DDL;
3701 break;
3702
3703 case T_AlterStatsStmt:
3704 lev = LOGSTMT_DDL;
3705 break;
3706
3708 lev = LOGSTMT_DDL;
3709 break;
3710
3711 case T_WaitStmt:
3712 lev = LOGSTMT_ALL;
3713 break;
3714
3715 /* already-planned queries */
3716 case T_PlannedStmt:
3717 {
3718 PlannedStmt *stmt = (PlannedStmt *) parsetree;
3719
3720 switch (stmt->commandType)
3721 {
3722 case CMD_SELECT:
3723 lev = LOGSTMT_ALL;
3724 break;
3725
3726 case CMD_UPDATE:
3727 case CMD_INSERT:
3728 case CMD_DELETE:
3729 case CMD_MERGE:
3730 lev = LOGSTMT_MOD;
3731 break;
3732
3733 case CMD_UTILITY:
3734 lev = GetCommandLogLevel(stmt->utilityStmt);
3735 break;
3736
3737 default:
3738 elog(WARNING, "unrecognized commandType: %d",
3739 (int) stmt->commandType);
3740 lev = LOGSTMT_ALL;
3741 break;
3742 }
3743 }
3744 break;
3745
3746 /* parsed-and-rewritten-but-not-planned queries */
3747 case T_Query:
3748 {
3749 Query *stmt = (Query *) parsetree;
3750
3751 switch (stmt->commandType)
3752 {
3753 case CMD_SELECT:
3754 lev = LOGSTMT_ALL;
3755 break;
3756
3757 case CMD_UPDATE:
3758 case CMD_INSERT:
3759 case CMD_DELETE:
3760 case CMD_MERGE:
3761 lev = LOGSTMT_MOD;
3762 break;
3763
3764 case CMD_UTILITY:
3765 lev = GetCommandLogLevel(stmt->utilityStmt);
3766 break;
3767
3768 default:
3769 elog(WARNING, "unrecognized commandType: %d",
3770 (int) stmt->commandType);
3771 lev = LOGSTMT_ALL;
3772 break;
3773 }
3774 }
3775 break;
3776
3777 default:
3778 elog(WARNING, "unrecognized node type: %d",
3779 (int) nodeTag(parsetree));
3780 lev = LOGSTMT_ALL;
3781 break;
3782 }
3783
3784 return lev;
3785}
PreparedStatement * FetchPreparedStatement(const char *stmt_name, bool throwError)
Definition prepare.c:434
bool defGetBoolean(DefElem *def)
Definition define.c:93
struct parser_state ps
#define lfirst(lc)
Definition pg_list.h:172
static long analyze(struct nfa *nfa)
Definition regc_nfa.c:3051
char * defname
Definition parsenodes.h:844
@ LOGSTMT_MOD
Definition tcopprot.h:36
@ LOGSTMT_DDL
Definition tcopprot.h:35
@ LOGSTMT_ALL
Definition tcopprot.h:37
LogStmtLevel GetCommandLogLevel(Node *parsetree)
Definition utility.c:3260

References analyze(), CMD_DELETE, CMD_INSERT, CMD_MERGE, CMD_SELECT, CMD_UPDATE, CMD_UTILITY, defGetBoolean(), DefElem::defname, elog, fb(), FetchPreparedStatement(), GetCommandLogLevel(), lfirst, LOGSTMT_ALL, LOGSTMT_DDL, LOGSTMT_MOD, nodeTag, ps, stmt, and WARNING.

Referenced by check_log_statement(), and GetCommandLogLevel().

◆ ProcessUtility()

void ProcessUtility ( PlannedStmt pstmt,
const char queryString,
bool  readOnlyTree,
ProcessUtilityContext  context,
ParamListInfo  params,
QueryEnvironment queryEnv,
DestReceiver dest,
QueryCompletion qc 
)
extern

Definition at line 501 of file utility.c.

509{
510 Assert(IsA(pstmt, PlannedStmt));
511 Assert(pstmt->commandType == CMD_UTILITY);
512 Assert(queryString != NULL); /* required as of 8.4 */
513 Assert(qc == NULL || qc->commandTag == CMDTAG_UNKNOWN);
514
515 /*
516 * We provide a function hook variable that lets loadable plugins get
517 * control when ProcessUtility is called. Such a plugin would normally
518 * call standard_ProcessUtility().
519 */
521 (*ProcessUtility_hook) (pstmt, queryString, readOnlyTree,
522 context, params, queryEnv,
523 dest, qc);
524 else
525 standard_ProcessUtility(pstmt, queryString, readOnlyTree,
526 context, params, queryEnv,
527 dest, qc);
528}
CommandTag commandTag
Definition cmdtag.h:31
void standard_ProcessUtility(PlannedStmt *pstmt, const char *queryString, bool readOnlyTree, ProcessUtilityContext context, ParamListInfo params, QueryEnvironment *queryEnv, DestReceiver *dest, QueryCompletion *qc)
Definition utility.c:545
ProcessUtility_hook_type ProcessUtility_hook
Definition utility.c:71

References Assert, CMD_UTILITY, QueryCompletion::commandTag, PlannedStmt::commandType, fb(), IsA, ProcessUtility_hook, and standard_ProcessUtility().

Referenced by _SPI_execute_plan(), CreateSchemaCommand(), execute_sql_string(), ImportForeignSchema(), PortalRunUtility(), postquel_getnext(), ProcessUtilityForAlterTable(), and ProcessUtilitySlow().

◆ ProcessUtilityForAlterTable()

void ProcessUtilityForAlterTable ( Node stmt,
AlterTableUtilityContext context 
)
extern

Definition at line 1959 of file utility.c.

1960{
1961 PlannedStmt *wrapper;
1962
1963 /*
1964 * For event triggers, we must "close" the current complex-command set,
1965 * and start a new one afterwards; this is needed to ensure the ordering
1966 * of command events is consistent with the way they were executed.
1967 */
1969
1970 /* Create a suitable wrapper */
1971 wrapper = makeNode(PlannedStmt);
1972 wrapper->commandType = CMD_UTILITY;
1973 wrapper->canSetTag = false;
1974 wrapper->utilityStmt = stmt;
1975 wrapper->stmt_location = context->pstmt->stmt_location;
1976 wrapper->stmt_len = context->pstmt->stmt_len;
1977 wrapper->planOrigin = PLAN_STMT_INTERNAL;
1978
1979 ProcessUtility(wrapper,
1980 context->queryString,
1981 false,
1983 context->params,
1984 context->queryEnv,
1986 NULL);
1987
1990}
DestReceiver * None_Receiver
Definition dest.c:96
void EventTriggerAlterTableStart(Node *parsetree)
void EventTriggerAlterTableRelid(Oid objectId)
void EventTriggerAlterTableEnd(void)
#define makeNode(_type_)
Definition nodes.h:161
@ PLAN_STMT_INTERNAL
Definition plannodes.h:40
ParamListInfo params
Definition utility.h:35
QueryEnvironment * queryEnv
Definition utility.h:36
PlannedStmt * pstmt
Definition utility.h:32
const char * queryString
Definition utility.h:33
bool canSetTag
Definition plannodes.h:86
ParseLoc stmt_len
Definition plannodes.h:165
PlannedStmtOrigin planOrigin
Definition plannodes.h:77
ParseLoc stmt_location
Definition plannodes.h:163
Node * utilityStmt
Definition plannodes.h:150
void ProcessUtility(PlannedStmt *pstmt, const char *queryString, bool readOnlyTree, ProcessUtilityContext context, ParamListInfo params, QueryEnvironment *queryEnv, DestReceiver *dest, QueryCompletion *qc)
Definition utility.c:501

References PlannedStmt::canSetTag, CMD_UTILITY, PlannedStmt::commandType, EventTriggerAlterTableEnd(), EventTriggerAlterTableRelid(), EventTriggerAlterTableStart(), fb(), makeNode, None_Receiver, AlterTableUtilityContext::params, PLAN_STMT_INTERNAL, PlannedStmt::planOrigin, PROCESS_UTILITY_SUBCOMMAND, ProcessUtility(), AlterTableUtilityContext::pstmt, AlterTableUtilityContext::queryEnv, AlterTableUtilityContext::queryString, AlterTableUtilityContext::relid, stmt, PlannedStmt::stmt_len, PlannedStmt::stmt_location, and PlannedStmt::utilityStmt.

Referenced by ATParseTransformCmd(), and ATRewriteTables().

◆ standard_ProcessUtility()

void standard_ProcessUtility ( PlannedStmt pstmt,
const char queryString,
bool  readOnlyTree,
ProcessUtilityContext  context,
ParamListInfo  params,
QueryEnvironment queryEnv,
DestReceiver dest,
QueryCompletion qc 
)
extern

Definition at line 545 of file utility.c.

553{
554 Node *parsetree;
555 bool isTopLevel = (context == PROCESS_UTILITY_TOPLEVEL);
557 ParseState *pstate;
558 int readonly_flags;
559
560 /* This can recurse, so check for excessive recursion */
562
563 /*
564 * If the given node tree is read-only, make a copy to ensure that parse
565 * transformations don't damage the original tree. This could be
566 * refactored to avoid making unnecessary copies in more cases, but it's
567 * not clear that it's worth a great deal of trouble over. Statements
568 * that are complex enough to be expensive to copy are exactly the ones
569 * we'd need to copy, so that only marginal savings seem possible.
570 */
571 if (readOnlyTree)
572 pstmt = copyObject(pstmt);
573 parsetree = pstmt->utilityStmt;
574
575 /* Prohibit read/write commands in read-only states. */
579 {
581
588 }
589
590 pstate = make_parsestate(NULL);
591 pstate->p_sourcetext = queryString;
592 pstate->p_queryEnv = queryEnv;
593
594 switch (nodeTag(parsetree))
595 {
596 /*
597 * ******************** transactions ********************
598 */
600 {
601 TransactionStmt *stmt = (TransactionStmt *) parsetree;
602
603 switch (stmt->kind)
604 {
605 /*
606 * START TRANSACTION, as defined by SQL99: Identical
607 * to BEGIN. Same code for both.
608 */
609 case TRANS_STMT_BEGIN:
610 case TRANS_STMT_START:
611 {
612 ListCell *lc;
613
615 foreach(lc, stmt->options)
616 {
617 DefElem *item = (DefElem *) lfirst(lc);
618
619 if (strcmp(item->defname, "transaction_isolation") == 0)
620 SetPGVariable("transaction_isolation",
621 list_make1(item->arg),
622 true);
623 else if (strcmp(item->defname, "transaction_read_only") == 0)
624 SetPGVariable("transaction_read_only",
625 list_make1(item->arg),
626 true);
627 else if (strcmp(item->defname, "transaction_deferrable") == 0)
628 SetPGVariable("transaction_deferrable",
629 list_make1(item->arg),
630 true);
631 }
632 }
633 break;
634
636 if (!EndTransactionBlock(stmt->chain))
637 {
638 /* report unsuccessful commit in qc */
639 if (qc)
641 }
642 break;
643
645 if (!PrepareTransactionBlock(stmt->gid))
646 {
647 /* report unsuccessful commit in qc */
648 if (qc)
650 }
651 break;
652
654 PreventInTransactionBlock(isTopLevel, "COMMIT PREPARED");
656 break;
657
659 PreventInTransactionBlock(isTopLevel, "ROLLBACK PREPARED");
660 FinishPreparedTransaction(stmt->gid, false);
661 break;
662
665 break;
666
669 DefineSavepoint(stmt->savepoint_name);
670 break;
671
673 RequireTransactionBlock(isTopLevel, "RELEASE SAVEPOINT");
674 ReleaseSavepoint(stmt->savepoint_name);
675 break;
676
678 RequireTransactionBlock(isTopLevel, "ROLLBACK TO SAVEPOINT");
679 RollbackToSavepoint(stmt->savepoint_name);
680
681 /*
682 * CommitTransactionCommand is in charge of
683 * re-defining the savepoint again
684 */
685 break;
686 }
687 }
688 break;
689
690 /*
691 * Portal (cursor) manipulation
692 */
694 PerformCursorOpen(pstate, (DeclareCursorStmt *) parsetree, params,
695 isTopLevel);
696 break;
697
699 {
700 ClosePortalStmt *stmt = (ClosePortalStmt *) parsetree;
701
703 PerformPortalClose(stmt->portalname);
704 }
705 break;
706
707 case T_FetchStmt:
708 PerformPortalFetch((FetchStmt *) parsetree, dest, qc);
709 break;
710
711 case T_DoStmt:
712 ExecuteDoStmt(pstate, (DoStmt *) parsetree, isAtomicContext);
713 break;
714
716 /* no event triggers for global objects */
717 PreventInTransactionBlock(isTopLevel, "CREATE TABLESPACE");
719 break;
720
722 /* no event triggers for global objects */
723 PreventInTransactionBlock(isTopLevel, "DROP TABLESPACE");
724 DropTableSpace((DropTableSpaceStmt *) parsetree);
725 break;
726
728 /* no event triggers for global objects */
730 break;
731
732 case T_TruncateStmt:
733 ExecuteTruncate((TruncateStmt *) parsetree);
734 break;
735
736 case T_CopyStmt:
737 {
738 uint64 processed;
739
740 DoCopy(pstate, (CopyStmt *) parsetree,
741 pstmt->stmt_location, pstmt->stmt_len,
742 &processed);
743 if (qc)
744 SetQueryCompletion(qc, CMDTAG_COPY, processed);
745 }
746 break;
747
748 case T_PrepareStmt:
749 CheckRestrictedOperation("PREPARE");
750 PrepareQuery(pstate, (PrepareStmt *) parsetree,
751 pstmt->stmt_location, pstmt->stmt_len);
752 break;
753
754 case T_ExecuteStmt:
755 ExecuteQuery(pstate,
756 (ExecuteStmt *) parsetree, NULL,
757 params,
758 dest, qc);
759 break;
760
761 case T_DeallocateStmt:
762 CheckRestrictedOperation("DEALLOCATE");
763 DeallocateQuery((DeallocateStmt *) parsetree);
764 break;
765
766 case T_GrantRoleStmt:
767 /* no event triggers for global objects */
768 GrantRole(pstate, (GrantRoleStmt *) parsetree);
769 break;
770
771 case T_CreatedbStmt:
772 /* no event triggers for global objects */
773 PreventInTransactionBlock(isTopLevel, "CREATE DATABASE");
774 createdb(pstate, (CreatedbStmt *) parsetree);
775 break;
776
778 /* no event triggers for global objects */
779 AlterDatabase(pstate, (AlterDatabaseStmt *) parsetree, isTopLevel);
780 break;
781
783 /* no event triggers for global objects */
785 break;
786
788 /* no event triggers for global objects */
790 break;
791
792 case T_DropdbStmt:
793 /* no event triggers for global objects */
794 PreventInTransactionBlock(isTopLevel, "DROP DATABASE");
795 DropDatabase(pstate, (DropdbStmt *) parsetree);
796 break;
797
798 /* Query-level asynchronous notification */
799 case T_NotifyStmt:
800 {
801 NotifyStmt *stmt = (NotifyStmt *) parsetree;
802
803 Async_Notify(stmt->conditionname, stmt->payload);
804 }
805 break;
806
807 case T_ListenStmt:
808 {
809 ListenStmt *stmt = (ListenStmt *) parsetree;
810
811 CheckRestrictedOperation("LISTEN");
812
813 /*
814 * We don't allow LISTEN in background processes, as there is
815 * no mechanism for them to collect NOTIFY messages, so they'd
816 * just block cleanout of the async SLRU indefinitely.
817 * (Authors of custom background workers could bypass this
818 * restriction by calling Async_Listen directly, but then it's
819 * on them to provide some mechanism to process the message
820 * queue.) Note there seems no reason to forbid UNLISTEN.
821 */
825 /* translator: %s is name of a SQL command, eg LISTEN */
826 errmsg("cannot execute %s within a background process",
827 "LISTEN")));
828
829 Async_Listen(stmt->conditionname);
830 }
831 break;
832
833 case T_UnlistenStmt:
834 {
835 UnlistenStmt *stmt = (UnlistenStmt *) parsetree;
836
837 CheckRestrictedOperation("UNLISTEN");
838 if (stmt->conditionname)
839 Async_Unlisten(stmt->conditionname);
840 else
842 }
843 break;
844
845 case T_LoadStmt:
846 {
847 LoadStmt *stmt = (LoadStmt *) parsetree;
848
849 closeAllVfds(); /* probably not necessary... */
850 /* Allowed names are restricted if you're not superuser */
851 load_file(stmt->filename, !superuser());
852 }
853 break;
854
855 case T_CallStmt:
856 ExecuteCallStmt(castNode(CallStmt, parsetree), params, isAtomicContext, dest);
857 break;
858
859 case T_ClusterStmt:
860 cluster(pstate, (ClusterStmt *) parsetree, isTopLevel);
861 break;
862
863 case T_VacuumStmt:
864 ExecVacuum(pstate, (VacuumStmt *) parsetree, isTopLevel);
865 break;
866
867 case T_ExplainStmt:
868 ExplainQuery(pstate, (ExplainStmt *) parsetree, params, dest);
869 break;
870
872 PreventInTransactionBlock(isTopLevel, "ALTER SYSTEM");
874 break;
875
878 break;
879
881 {
882 VariableShowStmt *n = (VariableShowStmt *) parsetree;
883
884 GetPGVariable(n->name, dest);
885 }
886 break;
887
888 case T_DiscardStmt:
889 /* should we allow DISCARD PLANS? */
890 CheckRestrictedOperation("DISCARD");
891 DiscardCommand((DiscardStmt *) parsetree, isTopLevel);
892 break;
893
895 /* no event triggers on event triggers */
897 break;
898
900 /* no event triggers on event triggers */
902 break;
903
904 /*
905 * ******************************** ROLE statements ****
906 */
907 case T_CreateRoleStmt:
908 /* no event triggers for global objects */
909 CreateRole(pstate, (CreateRoleStmt *) parsetree);
910 break;
911
912 case T_AlterRoleStmt:
913 /* no event triggers for global objects */
914 AlterRole(pstate, (AlterRoleStmt *) parsetree);
915 break;
916
918 /* no event triggers for global objects */
919 AlterRoleSet((AlterRoleSetStmt *) parsetree);
920 break;
921
922 case T_DropRoleStmt:
923 /* no event triggers for global objects */
924 DropRole((DropRoleStmt *) parsetree);
925 break;
926
928 /* no event triggers for global objects */
930 break;
931
932 case T_LockStmt:
933
934 /*
935 * Since the lock would just get dropped immediately, LOCK TABLE
936 * outside a transaction block is presumed to be user error.
937 */
938 RequireTransactionBlock(isTopLevel, "LOCK TABLE");
939 LockTableCommand((LockStmt *) parsetree);
940 break;
941
943 WarnNoTransactionBlock(isTopLevel, "SET CONSTRAINTS");
945 break;
946
947 case T_CheckPointStmt:
948 ExecCheckpoint(pstate, (CheckPointStmt *) parsetree);
949 break;
950
951 /*
952 * The following statements are supported by Event Triggers only
953 * in some cases, so we "fast path" them in the other cases.
954 */
955
956 case T_GrantStmt:
957 {
958 GrantStmt *stmt = (GrantStmt *) parsetree;
959
961 ProcessUtilitySlow(pstate, pstmt, queryString,
962 context, params, queryEnv,
963 dest, qc);
964 else
966 }
967 break;
968
969 case T_DropStmt:
970 {
971 DropStmt *stmt = (DropStmt *) parsetree;
972
973 if (EventTriggerSupportsObjectType(stmt->removeType))
974 ProcessUtilitySlow(pstate, pstmt, queryString,
975 context, params, queryEnv,
976 dest, qc);
977 else
979 }
980 break;
981
982 case T_RenameStmt:
983 {
984 RenameStmt *stmt = (RenameStmt *) parsetree;
985
986 if (EventTriggerSupportsObjectType(stmt->renameType))
987 ProcessUtilitySlow(pstate, pstmt, queryString,
988 context, params, queryEnv,
989 dest, qc);
990 else
992 }
993 break;
994
996 {
998
999 if (EventTriggerSupportsObjectType(stmt->objectType))
1000 ProcessUtilitySlow(pstate, pstmt, queryString,
1001 context, params, queryEnv,
1002 dest, qc);
1003 else
1005 }
1006 break;
1007
1009 {
1011
1012 if (EventTriggerSupportsObjectType(stmt->objectType))
1013 ProcessUtilitySlow(pstate, pstmt, queryString,
1014 context, params, queryEnv,
1015 dest, qc);
1016 else
1018 }
1019 break;
1020
1021 case T_AlterOwnerStmt:
1022 {
1023 AlterOwnerStmt *stmt = (AlterOwnerStmt *) parsetree;
1024
1025 if (EventTriggerSupportsObjectType(stmt->objectType))
1026 ProcessUtilitySlow(pstate, pstmt, queryString,
1027 context, params, queryEnv,
1028 dest, qc);
1029 else
1031 }
1032 break;
1033
1034 case T_CommentStmt:
1035 {
1036 CommentStmt *stmt = (CommentStmt *) parsetree;
1037
1039 ProcessUtilitySlow(pstate, pstmt, queryString,
1040 context, params, queryEnv,
1041 dest, qc);
1042 else
1044 break;
1045 }
1046
1047 case T_SecLabelStmt:
1048 {
1049 SecLabelStmt *stmt = (SecLabelStmt *) parsetree;
1050
1052 ProcessUtilitySlow(pstate, pstmt, queryString,
1053 context, params, queryEnv,
1054 dest, qc);
1055 else
1057 break;
1058 }
1059
1060 case T_WaitStmt:
1061 {
1062 ExecWaitStmt(pstate, (WaitStmt *) parsetree, dest);
1063 }
1064 break;
1065
1066 default:
1067 /* All other statement types have event trigger support */
1068 ProcessUtilitySlow(pstate, pstmt, queryString,
1069 context, params, queryEnv,
1070 dest, qc);
1071 break;
1072 }
1073
1074 free_parsestate(pstate);
1075
1076 /*
1077 * Make effects of commands visible, for instance so that
1078 * PreCommit_on_commit_actions() can see them (see for example bug
1079 * #15631).
1080 */
1082}
void ExecuteGrantStmt(GrantStmt *stmt)
Definition aclchk.c:391
ObjectAddress ExecAlterOwnerStmt(AlterOwnerStmt *stmt)
Definition alter.c:831
ObjectAddress ExecAlterObjectDependsStmt(AlterObjectDependsStmt *stmt, ObjectAddress *refAddress)
Definition alter.c:465
ObjectAddress ExecRenameStmt(RenameStmt *stmt)
Definition alter.c:367
ObjectAddress ExecAlterObjectSchemaStmt(AlterObjectSchemaStmt *stmt, ObjectAddress *oldSchemaAddr)
Definition alter.c:528
void Async_UnlistenAll(void)
Definition async.c:1066
void Async_Unlisten(const char *channel)
Definition async.c:1048
void Async_Listen(const char *channel)
Definition async.c:1034
void Async_Notify(const char *channel, const char *payload)
Definition async.c:885
void DoCopy(ParseState *pstate, const CopyStmt *stmt, int stmt_location, int stmt_len, uint64 *processed)
Definition copy.c:63
void PrepareQuery(ParseState *pstate, PrepareStmt *stmt, int stmt_location, int stmt_len)
Definition prepare.c:59
void ExecuteQuery(ParseState *pstate, ExecuteStmt *stmt, IntoClause *intoClause, ParamListInfo params, DestReceiver *dest, QueryCompletion *qc)
Definition prepare.c:150
void DeallocateQuery(DeallocateStmt *stmt)
Definition prepare.c:505
Oid AlterTableSpaceOptions(AlterTableSpaceOptionsStmt *stmt)
void DropTableSpace(DropTableSpaceStmt *stmt)
Definition tablespace.c:395
Oid CreateTableSpace(CreateTableSpaceStmt *stmt)
Definition tablespace.c:208
uint64_t uint64
Definition c.h:547
void ExecCheckpoint(ParseState *pstate, CheckPointStmt *stmt)
void cluster(ParseState *pstate, ClusterStmt *stmt, bool isTopLevel)
Definition cluster.c:107
static void SetQueryCompletion(QueryCompletion *qc, CommandTag commandTag, uint64 nprocessed)
Definition cmdtag.h:37
ObjectAddress CommentObject(CommentStmt *stmt)
Definition comment.c:40
ObjectAddress AlterDatabaseRefreshColl(AlterDatabaseRefreshCollStmt *stmt)
Oid createdb(ParseState *pstate, const CreatedbStmt *stmt)
Definition dbcommands.c:685
Oid AlterDatabase(ParseState *pstate, AlterDatabaseStmt *stmt, bool isTopLevel)
void DropDatabase(ParseState *pstate, DropdbStmt *stmt)
Oid AlterDatabaseSet(AlterDatabaseSetStmt *stmt)
void load_file(const char *filename, bool restricted)
Definition dfmgr.c:149
void DiscardCommand(DiscardStmt *stmt, bool isTopLevel)
Definition discard.c:31
int errcode(int sqlerrcode)
Definition elog.c:863
int errmsg(const char *fmt,...)
Definition elog.c:1080
#define ERROR
Definition elog.h:39
#define ereport(elevel,...)
Definition elog.h:150
bool EventTriggerSupportsObjectType(ObjectType obtype)
Oid CreateEventTrigger(CreateEventTrigStmt *stmt)
Oid AlterEventTrigger(AlterEventTrigStmt *stmt)
void ExplainQuery(ParseState *pstate, ExplainStmt *stmt, ParamListInfo params, DestReceiver *dest)
Definition explain.c:177
void closeAllVfds(void)
Definition fd.c:3064
void ExecuteCallStmt(CallStmt *stmt, ParamListInfo params, bool atomic, DestReceiver *dest)
void ExecuteDoStmt(ParseState *pstate, DoStmt *stmt, bool atomic)
void AlterSystemSetConfigFile(AlterSystemStmt *altersysstmt)
Definition guc.c:4470
void GetPGVariable(const char *name, DestReceiver *dest)
Definition guc_funcs.c:408
void SetPGVariable(const char *name, List *args, bool is_local)
Definition guc_funcs.c:341
void ExecSetVariableStmt(VariableSetStmt *stmt, bool isTopLevel)
Definition guc_funcs.c:43
void LockTableCommand(LockStmt *lockstmt)
Definition lockcmds.c:41
@ B_BACKEND
Definition miscadmin.h:342
BackendType MyBackendType
Definition miscinit.c:64
#define copyObject(obj)
Definition nodes.h:232
#define castNode(_type_, nodeptr)
Definition nodes.h:182
void free_parsestate(ParseState *pstate)
Definition parse_node.c:72
ParseState * make_parsestate(ParseState *parentParseState)
Definition parse_node.c:39
#define list_make1(x1)
Definition pg_list.h:212
void PerformCursorOpen(ParseState *pstate, DeclareCursorStmt *cstmt, ParamListInfo params, bool isTopLevel)
Definition portalcmds.c:45
void PerformPortalClose(const char *name)
Definition portalcmds.c:225
void PerformPortalFetch(FetchStmt *stmt, DestReceiver *dest, QueryCompletion *qc)
Definition portalcmds.c:178
ObjectAddress ExecSecLabelStmt(SecLabelStmt *stmt)
Definition seclabel.c:115
void check_stack_depth(void)
Definition stack_depth.c:95
Node * arg
Definition parsenodes.h:845
QueryEnvironment * p_queryEnv
Definition parse_node.h:223
const char * p_sourcetext
Definition parse_node.h:195
bool superuser(void)
Definition superuser.c:46
void ExecuteTruncate(TruncateStmt *stmt)
Definition tablecmds.c:1857
void AfterTriggerSetState(ConstraintsSetStmt *stmt)
Definition trigger.c:5766
void FinishPreparedTransaction(const char *gid, bool isCommit)
Definition twophase.c:1497
void ReassignOwnedObjects(ReassignOwnedStmt *stmt)
Definition user.c:1612
Oid AlterRole(ParseState *pstate, AlterRoleStmt *stmt)
Definition user.c:620
Oid AlterRoleSet(AlterRoleSetStmt *stmt)
Definition user.c:1001
void DropRole(DropRoleStmt *stmt)
Definition user.c:1091
Oid CreateRole(ParseState *pstate, CreateRoleStmt *stmt)
Definition user.c:133
void GrantRole(ParseState *pstate, GrantRoleStmt *stmt)
Definition user.c:1481
static int ClassifyUtilityCommandAsReadOnly(Node *parsetree)
Definition utility.c:129
void PreventCommandIfReadOnly(const char *cmdname)
Definition utility.c:406
void PreventCommandIfParallelMode(const char *cmdname)
Definition utility.c:424
static void ExecDropStmt(DropStmt *stmt, bool isTopLevel)
Definition utility.c:1996
static void CheckRestrictedOperation(const char *cmdname)
Definition utility.c:461
void PreventCommandDuringRecovery(const char *cmdname)
Definition utility.c:443
static void ProcessUtilitySlow(ParseState *pstate, PlannedStmt *pstmt, const char *queryString, ProcessUtilityContext context, ParamListInfo params, QueryEnvironment *queryEnv, DestReceiver *dest, QueryCompletion *qc)
Definition utility.c:1090
#define COMMAND_IS_STRICTLY_READ_ONLY
Definition utility.h:65
void ExecVacuum(ParseState *pstate, VacuumStmt *vacstmt, bool isTopLevel)
Definition vacuum.c:162
void ExecWaitStmt(ParseState *pstate, WaitStmt *stmt, DestReceiver *dest)
Definition wait.c:33
void WarnNoTransactionBlock(bool isTopLevel, const char *stmtType)
Definition xact.c:3732
void UserAbortTransactionBlock(bool chain)
Definition xact.c:4226
bool PrepareTransactionBlock(const char *gid)
Definition xact.c:4014
void RequireTransactionBlock(bool isTopLevel, const char *stmtType)
Definition xact.c:3738
void DefineSavepoint(const char *name)
Definition xact.c:4395
bool XactReadOnly
Definition xact.c:83
void CommandCounterIncrement(void)
Definition xact.c:1101
void PreventInTransactionBlock(bool isTopLevel, const char *stmtType)
Definition xact.c:3669
void ReleaseSavepoint(const char *name)
Definition xact.c:4480
bool IsTransactionBlock(void)
Definition xact.c:4993
bool IsInParallelMode(void)
Definition xact.c:1090
void BeginTransactionBlock(void)
Definition xact.c:3946
void RollbackToSavepoint(const char *name)
Definition xact.c:4589
bool EndTransactionBlock(bool chain)
Definition xact.c:4066

References AfterTriggerSetState(), AlterDatabase(), AlterDatabaseRefreshColl(), AlterDatabaseSet(), AlterEventTrigger(), AlterRole(), AlterRoleSet(), AlterSystemSetConfigFile(), AlterTableSpaceOptions(), DefElem::arg, Async_Listen(), Async_Notify(), Async_Unlisten(), Async_UnlistenAll(), B_BACKEND, BeginTransactionBlock(), castNode, check_stack_depth(), CheckRestrictedOperation(), ClassifyUtilityCommandAsReadOnly(), closeAllVfds(), cluster(), COMMAND_IS_STRICTLY_READ_ONLY, COMMAND_OK_IN_PARALLEL_MODE, COMMAND_OK_IN_READ_ONLY_TXN, COMMAND_OK_IN_RECOVERY, CommandCounterIncrement(), CommentObject(), copyObject, CreateCommandTag(), createdb(), CreateEventTrigger(), CreateRole(), CreateTableSpace(), DeallocateQuery(), DefineSavepoint(), DefElem::defname, DiscardCommand(), DoCopy(), DropDatabase(), DropRole(), DropTableSpace(), EndTransactionBlock(), ereport, errcode(), errmsg(), ERROR, EventTriggerSupportsObjectType(), ExecAlterObjectDependsStmt(), ExecAlterObjectSchemaStmt(), ExecAlterOwnerStmt(), ExecCheckpoint(), ExecDropStmt(), ExecRenameStmt(), ExecSecLabelStmt(), ExecSetVariableStmt(), ExecuteCallStmt(), ExecuteDoStmt(), ExecuteGrantStmt(), ExecuteQuery(), ExecuteTruncate(), ExecVacuum(), ExecWaitStmt(), ExplainQuery(), fb(), FinishPreparedTransaction(), free_parsestate(), GetCommandTagName(), GetPGVariable(), GrantRole(), IsInParallelMode(), IsTransactionBlock(), lfirst, list_make1, load_file(), LockTableCommand(), make_parsestate(), MyBackendType, VariableShowStmt::name, nodeTag, ParseState::p_queryEnv, ParseState::p_sourcetext, PerformCursorOpen(), PerformPortalClose(), PerformPortalFetch(), PrepareQuery(), PrepareTransactionBlock(), PreventCommandDuringRecovery(), PreventCommandIfParallelMode(), PreventCommandIfReadOnly(), PreventInTransactionBlock(), PROCESS_UTILITY_QUERY_NONATOMIC, PROCESS_UTILITY_TOPLEVEL, ProcessUtilitySlow(), ReassignOwnedObjects(), ReleaseSavepoint(), RequireTransactionBlock(), RollbackToSavepoint(), SetPGVariable(), SetQueryCompletion(), stmt, PlannedStmt::stmt_len, PlannedStmt::stmt_location, superuser(), TRANS_STMT_BEGIN, TRANS_STMT_COMMIT, TRANS_STMT_COMMIT_PREPARED, TRANS_STMT_PREPARE, TRANS_STMT_RELEASE, TRANS_STMT_ROLLBACK, TRANS_STMT_ROLLBACK_PREPARED, TRANS_STMT_ROLLBACK_TO, TRANS_STMT_SAVEPOINT, TRANS_STMT_START, UserAbortTransactionBlock(), PlannedStmt::utilityStmt, WarnNoTransactionBlock(), and XactReadOnly.

Referenced by pgss_ProcessUtility(), ProcessUtility(), REGRESS_utility_command(), and sepgsql_utility_command().

◆ UtilityContainsQuery()

Query * UtilityContainsQuery ( Node parsetree)
extern

Definition at line 2186 of file utility.c.

2187{
2188 Query *qry;
2189
2190 switch (nodeTag(parsetree))
2191 {
2193 qry = castNode(Query, ((DeclareCursorStmt *) parsetree)->query);
2194 if (qry->commandType == CMD_UTILITY)
2195 return UtilityContainsQuery(qry->utilityStmt);
2196 return qry;
2197
2198 case T_ExplainStmt:
2199 qry = castNode(Query, ((ExplainStmt *) parsetree)->query);
2200 if (qry->commandType == CMD_UTILITY)
2201 return UtilityContainsQuery(qry->utilityStmt);
2202 return qry;
2203
2205 qry = castNode(Query, ((CreateTableAsStmt *) parsetree)->query);
2206 if (qry->commandType == CMD_UTILITY)
2207 return UtilityContainsQuery(qry->utilityStmt);
2208 return qry;
2209
2210 default:
2211 return NULL;
2212 }
2213}
CmdType commandType
Definition parsenodes.h:121
Node * utilityStmt
Definition parsenodes.h:141
Query * UtilityContainsQuery(Node *parsetree)
Definition utility.c:2186

References castNode, CMD_UTILITY, Query::commandType, fb(), nodeTag, UtilityContainsQuery(), and Query::utilityStmt.

Referenced by AcquireExecutorLocks(), AcquirePlannerLocks(), extract_query_dependencies_walker(), and UtilityContainsQuery().

◆ UtilityReturnsTuples()

bool UtilityReturnsTuples ( Node parsetree)
extern

Definition at line 2029 of file utility.c.

2030{
2031 switch (nodeTag(parsetree))
2032 {
2033 case T_CallStmt:
2034 {
2035 CallStmt *stmt = (CallStmt *) parsetree;
2036
2037 return (stmt->funcexpr->funcresulttype == RECORDOID);
2038 }
2039 case T_FetchStmt:
2040 {
2041 FetchStmt *stmt = (FetchStmt *) parsetree;
2042 Portal portal;
2043
2044 if (stmt->ismove)
2045 return false;
2046 portal = GetPortalByName(stmt->portalname);
2047 if (!PortalIsValid(portal))
2048 return false; /* not our business to raise error */
2049 return portal->tupDesc ? true : false;
2050 }
2051
2052 case T_ExecuteStmt:
2053 {
2054 ExecuteStmt *stmt = (ExecuteStmt *) parsetree;
2055 PreparedStatement *entry;
2056
2057 entry = FetchPreparedStatement(stmt->name, false);
2058 if (!entry)
2059 return false; /* not our business to raise error */
2060 if (entry->plansource->resultDesc)
2061 return true;
2062 return false;
2063 }
2064
2065 case T_ExplainStmt:
2066 return true;
2067
2068 case T_VariableShowStmt:
2069 return true;
2070
2071 case T_WaitStmt:
2072 return true;
2073
2074 default:
2075 return false;
2076 }
2077}
return true
Definition isn.c:130
#define PortalIsValid(p)
Definition portal.h:211
Portal GetPortalByName(const char *name)
Definition portalmem.c:130
TupleDesc resultDesc
Definition plancache.h:120
TupleDesc tupDesc
Definition portal.h:159
CachedPlanSource * plansource
Definition prepare.h:32

References fb(), FetchPreparedStatement(), GetPortalByName(), nodeTag, PreparedStatement::plansource, PortalIsValid, CachedPlanSource::resultDesc, stmt, true, and PortalData::tupDesc.

Referenced by ChoosePortalStrategy().

◆ UtilityTupleDescriptor()

TupleDesc UtilityTupleDescriptor ( Node parsetree)
extern

Definition at line 2088 of file utility.c.

2089{
2090 switch (nodeTag(parsetree))
2091 {
2092 case T_CallStmt:
2093 return CallStmtResultDesc((CallStmt *) parsetree);
2094
2095 case T_FetchStmt:
2096 {
2097 FetchStmt *stmt = (FetchStmt *) parsetree;
2098 Portal portal;
2099
2100 if (stmt->ismove)
2101 return NULL;
2102 portal = GetPortalByName(stmt->portalname);
2103 if (!PortalIsValid(portal))
2104 return NULL; /* not our business to raise error */
2105 return CreateTupleDescCopy(portal->tupDesc);
2106 }
2107
2108 case T_ExecuteStmt:
2109 {
2110 ExecuteStmt *stmt = (ExecuteStmt *) parsetree;
2111 PreparedStatement *entry;
2112
2113 entry = FetchPreparedStatement(stmt->name, false);
2114 if (!entry)
2115 return NULL; /* not our business to raise error */
2117 }
2118
2119 case T_ExplainStmt:
2120 return ExplainResultDesc((ExplainStmt *) parsetree);
2121
2122 case T_VariableShowStmt:
2123 {
2124 VariableShowStmt *n = (VariableShowStmt *) parsetree;
2125
2126 return GetPGVariableResultDesc(n->name);
2127 }
2128
2129 case T_WaitStmt:
2130 return WaitStmtResultDesc((WaitStmt *) parsetree);
2131
2132 default:
2133 return NULL;
2134 }
2135}
TupleDesc FetchPreparedStatementResultDesc(PreparedStatement *stmt)
Definition prepare.c:466
TupleDesc ExplainResultDesc(ExplainStmt *stmt)
Definition explain.c:255
TupleDesc CallStmtResultDesc(CallStmt *stmt)
TupleDesc GetPGVariableResultDesc(const char *name)
Definition guc_funcs.c:420
TupleDesc CreateTupleDescCopy(TupleDesc tupdesc)
Definition tupdesc.c:252
TupleDesc WaitStmtResultDesc(WaitStmt *stmt)
Definition wait.c:333

References CallStmtResultDesc(), CreateTupleDescCopy(), ExplainResultDesc(), fb(), FetchPreparedStatement(), FetchPreparedStatementResultDesc(), GetPGVariableResultDesc(), GetPortalByName(), VariableShowStmt::name, nodeTag, PortalIsValid, stmt, PortalData::tupDesc, and WaitStmtResultDesc().

Referenced by PlanCacheComputeResultDesc(), and PortalStart().

Variable Documentation

◆ ProcessUtility_hook

PGDLLIMPORT ProcessUtility_hook_type ProcessUtility_hook
extern

Definition at line 71 of file utility.c.

Referenced by _PG_init(), and ProcessUtility().