protocol.sgml

PostgreSQL7.4.6 for Linux

<ListItem>
<Para>
                Length of message contents in bytes, including self.
</Para>
</ListItem>
</VarListEntry>
<VarListEntry>
<Term>
        String
</Term>
<ListItem>
<Para>
                The name of the destination portal
		(an empty string selects the unnamed portal).
</Para>
</ListItem>
</VarListEntry>
<VarListEntry>
<Term>
        String
</Term>
<ListItem>
<Para>
                The name of the source prepared statement
		(an empty string selects the unnamed prepared statement).
</Para>
</ListItem>
</VarListEntry>
<VarListEntry>
<Term>
        Int16
</Term>
<ListItem>
<Para>
		The number of parameter format codes that follow
		(denoted <replaceable>C</> below).
		This can be zero to indicate that there are no parameters
		or that the parameters all use the default format (text);
		or one, in which case the specified format code is applied
		to all parameters; or it can equal the actual number of
		parameters.
</Para>
</ListItem>
</VarListEntry>
<VarListEntry>
<Term>
        Int16[<replaceable>C</>]
</Term>
<ListItem>
<Para>
                The parameter format codes.  Each must presently be
		zero (text) or one (binary).
</Para>
</ListItem>
</VarListEntry>
<VarListEntry>
<Term>
        Int16
</Term>
<ListItem>
<Para>
                The number of parameter values that follow (possibly zero).
		This must match the number of parameters needed by the query.
</Para>
</ListItem>
</VarListEntry>
</VariableList>
        Next, the following pair of fields appear for each parameter:
<VariableList>
<VarListEntry>
<Term>
        Int32
</Term>
<ListItem>
<Para>
                The length of the parameter value, in bytes (this count
		does not include itself).  Can be zero.
		As a special case, -1 indicates a NULL parameter value.
		No value bytes follow in the NULL case.
</Para>
</ListItem>
</VarListEntry>
<VarListEntry>
<Term>
        Byte<Replaceable>n</Replaceable>
</Term>
<ListItem>
<Para>
                The value of the parameter, in the format indicated by the
		associated format code.
                <Replaceable>n</Replaceable> is the above length.
</Para>
</ListItem>
</VarListEntry>
</VariableList>
        After the last parameter, the following fields appear:
<VariableList>
<VarListEntry>
<Term>
        Int16
</Term>
<ListItem>
<Para>
		The number of result-column format codes that follow
		(denoted <replaceable>R</> below).
		This can be zero to indicate that there are no result columns
		or that the result columns should all use the default format
		(text); 
		or one, in which case the specified format code is applied
		to all result columns (if any); or it can equal the actual
		number of result columns of the query.
</Para>
</ListItem>
</VarListEntry>
<VarListEntry>
<Term>
        Int16[<replaceable>R</>]
</Term>
<ListItem>
<Para>
                The result-column format codes.  Each must presently be
		zero (text) or one (binary).
</Para>
</ListItem>
</VarListEntry>
</VariableList>
</Para>
</ListItem>
</VarListEntry>


<VarListEntry>
<Term>
BindComplete (B)
</Term>
<ListItem>
<Para>

<VariableList>
<VarListEntry>
<Term>
        Byte1('2')
</Term>
<ListItem>
<Para>
                Identifies the message as a Bind-complete indicator.
</Para>
</ListItem>
</VarListEntry>
<VarListEntry>
<Term>
        Int32(4)
</Term>
<ListItem>
<Para>
                Length of message contents in bytes, including self.
</Para>
</ListItem>
</VarListEntry>
</VariableList>

</Para>
</ListItem>
</VarListEntry>


<VarListEntry>
<Term>
CancelRequest (F)
</Term>
<ListItem>
<Para>

<VariableList>
<VarListEntry>
<Term>
        Int32(16)
</Term>
<ListItem>
<Para>
                Length of message contents in bytes, including self.
</Para>
</ListItem>
</VarListEntry>
<VarListEntry>
<Term>
        Int32(80877102)
</Term>
<ListItem>
<Para>
                The cancel request code.  The value is chosen to contain
                <literal>1234</> in the most significant 16 bits, and <literal>5678</> in the
                least 16 significant bits.  (To avoid confusion, this code
                must not be the same as any protocol version number.)
</Para>
</ListItem>
</VarListEntry>
<VarListEntry>
<Term>
        Int32
</Term>
<ListItem>
<Para>
                The process ID of the target backend.
</Para>
</ListItem>
</VarListEntry>
<VarListEntry>
<Term>
        Int32
</Term>
<ListItem>
<Para>
                The secret key for the target backend.
</Para>
</ListItem>
</VarListEntry>
</VariableList>

</Para>
</ListItem>
</VarListEntry>


<VarListEntry>
<Term>
Close (F)
</Term>
<ListItem>
<Para>

<VariableList>
<VarListEntry>
<Term>
        Byte1('C')
</Term>
<ListItem>
<Para>
                Identifies the message as a Close command.
</Para>
</ListItem>
</VarListEntry>
<VarListEntry>
<Term>
        Int32
</Term>
<ListItem>
<Para>
                Length of message contents in bytes, including self.
</Para>
</ListItem>
</VarListEntry>
<VarListEntry>
<Term>
        Byte1
</Term>
<ListItem>
<Para>
                '<literal>S</>' to close a prepared statement; or
                '<literal>P</>' to close a portal.
</Para>
</ListItem>
</VarListEntry>
<VarListEntry>
<Term>
        String
</Term>
<ListItem>
<Para>
                The name of the prepared statement or portal to close
		(an empty string selects the unnamed prepared statement
		or portal).
</Para>
</ListItem>
</VarListEntry>
</VariableList>
</Para>
</ListItem>
</VarListEntry>


<VarListEntry>
<Term>
CloseComplete (B)
</Term>
<ListItem>
<Para>

<VariableList>
<VarListEntry>
<Term>
        Byte1('3')
</Term>
<ListItem>
<Para>
                Identifies the message as a Close-complete indicator.
</Para>
</ListItem>
</VarListEntry>
<VarListEntry>
<Term>
        Int32(4)
</Term>
<ListItem>
<Para>
                Length of message contents in bytes, including self.
</Para>
</ListItem>
</VarListEntry>
</VariableList>

</Para>
</ListItem>
</VarListEntry>


<VarListEntry>
<Term>
CommandComplete (B)
</Term>
<ListItem>
<Para>

<VariableList>
<VarListEntry>
<Term>
        Byte1('C')
</Term>
<ListItem>
<Para>
                Identifies the message as a command-completed response.
</Para>
</ListItem>
</VarListEntry>
<VarListEntry>
<Term>
        Int32
</Term>
<ListItem>
<Para>
                Length of message contents in bytes, including self.
</Para>
</ListItem>
</VarListEntry>
<VarListEntry>
<Term>
        String
</Term>
<ListItem>
<Para>
        The command tag.  This is usually a single
        word that identifies which SQL command was completed.
       </Para>

       <Para>
        For an <command>INSERT</command> command, the tag is
        <literal>INSERT <replaceable>oid</replaceable>
        <replaceable>rows</replaceable></literal>, where
        <replaceable>rows</replaceable> is the number of rows
        inserted. <replaceable>oid</replaceable> is the object ID
        of the inserted row if <Replaceable>rows</Replaceable> is 1
	and the target table has OIDs;
	otherwise <Replaceable>oid</Replaceable> is 0.
       </Para>

       <Para>
        For a <command>DELETE</command> command, the tag is
	<literal>DELETE <Replaceable>rows</Replaceable></literal> where
        <Replaceable>rows</Replaceable> is the number of rows deleted.
       </Para>

       <Para>
        For an <command>UPDATE</command> command, the tag is
	<literal>UPDATE <Replaceable>rows</Replaceable></literal> where
        <Replaceable>rows</Replaceable> is the number of rows updated.
       </Para>

       <para>
        For a <command>MOVE</command> command, the tag is
        <literal>MOVE <replaceable>rows</replaceable></literal> where
        <replaceable>rows</replaceable> is the number of rows the
        cursor's position has been changed by.
       </para>

       <para>
        For a <command>FETCH</command> command, the tag is
        <literal>FETCH <replaceable>rows</replaceable></literal> where
        <replaceable>rows</replaceable> is the number of rows that
        have been retrieved from the cursor.
</Para>
</ListItem>
</VarListEntry>
</VariableList>

</Para>
</ListItem>
</VarListEntry>


<VarListEntry>
<Term>
CopyData (F &amp; B)
</Term>
<ListItem>
<Para>
<VariableList>
<VarListEntry>
<Term>
        Byte1('d')
</Term>
<ListItem>
<Para>
                Identifies the message as COPY data.
</Para>
</ListItem>
</VarListEntry>
<VarListEntry>
<Term>
        Int32
</Term>
<