granicus.if.org Git - postgresql/blob - src/include/commands/prepare.h

   1 /*-------------------------------------------------------------------------
   2  *
   3  * prepare.h
   4  *        PREPARE, EXECUTE and DEALLOCATE commands, and prepared-stmt storage
   5  *
   6  *
   7  * Copyright (c) 2002-2010, PostgreSQL Global Development Group
   8  *
   9  * src/include/commands/prepare.h
  10  *
  11  *-------------------------------------------------------------------------
  12  */
  13 #ifndef PREPARE_H
  14 #define PREPARE_H
  15
  16 #include "commands/explain.h"
  17 #include "utils/plancache.h"
  18 #include "utils/timestamp.h"
  19
  20 /*
  21  * The data structure representing a prepared statement.  This is now just
  22  * a thin veneer over a plancache entry --- the main addition is that of
  23  * a name.
  24  *
  25  * Note: all subsidiary storage lives in the referenced plancache entry.
  26  */
  27 typedef struct
  28 {
  29         /* dynahash.c requires key to be first field */
  30         char            stmt_name[NAMEDATALEN];
  31         CachedPlanSource *plansource;           /* the actual cached plan */
  32         bool            from_sql;               /* prepared via SQL, not FE/BE protocol? */
  33         TimestampTz prepare_time;       /* the time when the stmt was prepared */
  34 } PreparedStatement;
  35
  36
  37 /* Utility statements PREPARE, EXECUTE, DEALLOCATE, EXPLAIN EXECUTE */
  38 extern void PrepareQuery(PrepareStmt *stmt, const char *queryString);
  39 extern void ExecuteQuery(ExecuteStmt *stmt, const char *queryString,
  40                          ParamListInfo params,
  41                          DestReceiver *dest, char *completionTag);
  42 extern void DeallocateQuery(DeallocateStmt *stmt);
  43 extern void ExplainExecuteQuery(ExecuteStmt *execstmt, ExplainState *es,
  44                                         const char *queryString, ParamListInfo params);
  45
  46 /* Low-level access to stored prepared statements */
  47 extern void StorePreparedStatement(const char *stmt_name,
  48                                            Node *raw_parse_tree,
  49                                            const char *query_string,
  50                                            const char *commandTag,
  51                                            Oid *param_types,
  52                                            int num_params,
  53                                            int cursor_options,
  54                                            List *stmt_list,
  55                                            bool from_sql);
  56 extern PreparedStatement *FetchPreparedStatement(const char *stmt_name,
  57                                            bool throwError);
  58 extern void DropPreparedStatement(const char *stmt_name, bool showError);
  59 extern TupleDesc FetchPreparedStatementResultDesc(PreparedStatement *stmt);
  60 extern List *FetchPreparedStatementTargetList(PreparedStatement *stmt);
  61
  62 void            DropAllPreparedStatements(void);
  63
  64 #endif   /* PREPARE_H */