Server IP : 103.119.228.120 / Your IP : 3.144.93.34 Web Server : Apache System : Linux v8.techscape8.com 3.10.0-1160.119.1.el7.tuxcare.els2.x86_64 #1 SMP Mon Jul 15 12:09:18 UTC 2024 x86_64 User : nobody ( 99) PHP Version : 5.6.40 Disable Function : shell_exec,symlink,system,exec,proc_get_status,proc_nice,proc_terminate,define_syslog_variables,syslog,openlog,closelog,escapeshellcmd,passthru,ocinum cols,ini_alter,leak,listen,chgrp,apache_note,apache_setenv,debugger_on,debugger_off,ftp_exec,dl,dll,myshellexec,proc_open,socket_bind,proc_close,escapeshellarg,parse_ini_filepopen,fpassthru,exec,passthru,escapeshellarg,escapeshellcmd,proc_close,proc_open,ini_alter,popen,show_source,proc_nice,proc_terminate,proc_get_status,proc_close,pfsockopen,leak,apache_child_terminate,posix_kill,posix_mkfifo,posix_setpgid,posix_setsid,posix_setuid,dl,symlink,shell_exec,system,dl,passthru,escapeshellarg,escapeshellcmd,myshellexec,c99_buff_prepare,c99_sess_put,fpassthru,getdisfunc,fx29exec,fx29exec2,is_windows,disp_freespace,fx29sh_getupdate,fx29_buff_prepare,fx29_sess_put,fx29shexit,fx29fsearch,fx29ftpbrutecheck,fx29sh_tools,fx29sh_about,milw0rm,imagez,sh_name,myshellexec,checkproxyhost,dosyayicek,c99_buff_prepare,c99_sess_put,c99getsource,c99sh_getupdate,c99fsearch,c99shexit,view_perms,posix_getpwuid,posix_getgrgid,posix_kill,parse_perms,parsesort,view_perms_color,set_encoder_input,ls_setcheckboxall,ls_reverse_all,rsg_read,rsg_glob,selfURL,dispsecinfo,unix2DosTime,addFile,system,get_users,view_size,DirFiles,DirFilesWide,DirPrintHTMLHeaders,GetFilesTotal,GetTitles,GetTimeTotal,GetMatchesCount,GetFileMatchesCount,GetResultFiles,fs_copy_dir,fs_copy_obj,fs_move_dir,fs_move_obj,fs_rmdir,SearchText,getmicrotime MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/local/ssl/local/ssl/share/doc/postgresql-9.2.24/html/ |
Upload File : |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML ><HEAD ><TITLE >Canceling Queries in Progress</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK REV="MADE" HREF="mailto:pgsql-docs@postgresql.org"><LINK REL="HOME" TITLE="PostgreSQL 9.2.24 Documentation" HREF="index.html"><LINK REL="UP" TITLE="libpq - C Library" HREF="libpq.html"><LINK REL="PREVIOUS" TITLE="Retrieving Query Results Row-By-Row" HREF="libpq-single-row-mode.html"><LINK REL="NEXT" TITLE="The Fast-Path Interface" HREF="libpq-fastpath.html"><LINK REL="STYLESHEET" TYPE="text/css" HREF="stylesheet.css"><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1"><META NAME="creation" CONTENT="2017-11-06T22:43:11"></HEAD ><BODY CLASS="SECT1" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="5" ALIGN="center" VALIGN="bottom" ><A HREF="index.html" >PostgreSQL 9.2.24 Documentation</A ></TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="top" ><A TITLE="Retrieving Query Results Row-By-Row" HREF="libpq-single-row-mode.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="10%" ALIGN="left" VALIGN="top" ><A HREF="libpq.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="60%" ALIGN="center" VALIGN="bottom" >Chapter 31. <SPAN CLASS="APPLICATION" >libpq</SPAN > - C Library</TD ><TD WIDTH="20%" ALIGN="right" VALIGN="top" ><A TITLE="The Fast-Path Interface" HREF="libpq-fastpath.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="SECT1" ><H1 CLASS="SECT1" ><A NAME="LIBPQ-CANCEL" >31.6. Canceling Queries in Progress</A ></H1 ><P > A client application can request cancellation of a command that is still being processed by the server, using the functions described in this section. <P ></P ></P><DIV CLASS="VARIABLELIST" ><DL ><DT ><A NAME="LIBPQ-PQGETCANCEL" ></A ><CODE CLASS="FUNCTION" >PQgetCancel</CODE > </DT ><DD ><P > Creates a data structure containing the information needed to cancel a command issued through a particular database connection. </P><PRE CLASS="SYNOPSIS" >PGcancel *PQgetCancel(PGconn *conn);</PRE ><P> </P ><P > <CODE CLASS="FUNCTION" >PQgetCancel</CODE > creates a <TT CLASS="STRUCTNAME" >PGcancel</TT > object given a <TT CLASS="STRUCTNAME" >PGconn</TT > connection object. It will return <TT CLASS="SYMBOL" >NULL</TT > if the given <TT CLASS="PARAMETER" >conn</TT > is <TT CLASS="SYMBOL" >NULL</TT > or an invalid connection. The <TT CLASS="STRUCTNAME" >PGcancel</TT > object is an opaque structure that is not meant to be accessed directly by the application; it can only be passed to <CODE CLASS="FUNCTION" >PQcancel</CODE > or <CODE CLASS="FUNCTION" >PQfreeCancel</CODE >. </P ></DD ><DT ><A NAME="LIBPQ-PQFREECANCEL" ></A ><CODE CLASS="FUNCTION" >PQfreeCancel</CODE > </DT ><DD ><P > Frees a data structure created by <CODE CLASS="FUNCTION" >PQgetCancel</CODE >. </P><PRE CLASS="SYNOPSIS" >void PQfreeCancel(PGcancel *cancel);</PRE ><P> </P ><P > <CODE CLASS="FUNCTION" >PQfreeCancel</CODE > frees a data object previously created by <CODE CLASS="FUNCTION" >PQgetCancel</CODE >. </P ></DD ><DT ><A NAME="LIBPQ-PQCANCEL" ></A ><CODE CLASS="FUNCTION" >PQcancel</CODE > </DT ><DD ><P > Requests that the server abandon processing of the current command. </P><PRE CLASS="SYNOPSIS" >int PQcancel(PGcancel *cancel, char *errbuf, int errbufsize);</PRE ><P> </P ><P > The return value is 1 if the cancel request was successfully dispatched and 0 if not. If not, <TT CLASS="PARAMETER" >errbuf</TT > is filled with an explanatory error message. <TT CLASS="PARAMETER" >errbuf</TT > must be a char array of size <TT CLASS="PARAMETER" >errbufsize</TT > (the recommended size is 256 bytes). </P ><P > Successful dispatch is no guarantee that the request will have any effect, however. If the cancellation is effective, the current command will terminate early and return an error result. If the cancellation fails (say, because the server was already done processing the command), then there will be no visible result at all. </P ><P > <CODE CLASS="FUNCTION" >PQcancel</CODE > can safely be invoked from a signal handler, if the <TT CLASS="PARAMETER" >errbuf</TT > is a local variable in the signal handler. The <TT CLASS="STRUCTNAME" >PGcancel</TT > object is read-only as far as <CODE CLASS="FUNCTION" >PQcancel</CODE > is concerned, so it can also be invoked from a thread that is separate from the one manipulating the <TT CLASS="STRUCTNAME" >PGconn</TT > object. </P ></DD ></DL ></DIV ><P> <P ></P ></P><DIV CLASS="VARIABLELIST" ><DL ><DT ><A NAME="LIBPQ-PQREQUESTCANCEL" ></A ><CODE CLASS="FUNCTION" >PQrequestCancel</CODE > </DT ><DD ><P > <CODE CLASS="FUNCTION" >PQrequestCancel</CODE > is a deprecated variant of <CODE CLASS="FUNCTION" >PQcancel</CODE >. </P><PRE CLASS="SYNOPSIS" >int PQrequestCancel(PGconn *conn);</PRE ><P> </P ><P > Requests that the server abandon processing of the current command. It operates directly on the <TT CLASS="STRUCTNAME" >PGconn</TT > object, and in case of failure stores the error message in the <TT CLASS="STRUCTNAME" >PGconn</TT > object (whence it can be retrieved by <CODE CLASS="FUNCTION" >PQerrorMessage</CODE >). Although the functionality is the same, this approach creates hazards for multiple-thread programs and signal handlers, since it is possible that overwriting the <TT CLASS="STRUCTNAME" >PGconn</TT >'s error message will mess up the operation currently in progress on the connection. </P ></DD ></DL ></DIV ><P> </P ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="libpq-single-row-mode.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="libpq-fastpath.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Retrieving Query Results Row-By-Row</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="libpq.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >The Fast-Path Interface</TD ></TR ></TABLE ></DIV ></BODY ></HTML >