Return-Path: paxson
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA18444; Wed, 11 Aug 93 17:57:28 -0700
Message-Id: <9308120057.AA18444@postgres.Berkeley.EDU>
From: "Caroline M. Paxson" <paxson@postgres.Berkeley.EDU>
Subject: Re: Odd result code from PQexec
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
Date: Wed, 11 Aug 1993 18:04:51 -0700
From: "Caroline M. Paxson" <paxson@postgres.Berkeley.EDU>


You write:
>From time to time I get a return value of "I" from PQexec().
>I thought the valid results where "R" and "C" followed by the name 
>of the portal or the command.
>In this case, I just get an "I".

The frontend PQexec() routine can return 'E' (fatal error - the
backend died), 'R' (non-fatal error), 'C<command>', 'BCOPY',
'DCOPY', and 'I'.  'I' means that the query it got was empty.
The backend decides that a query is empty if its first character
is a space and the second character is \0.  The query in your
example seems non-empty to me, but perhaps the first two characters
in your query buffer were as I just described.


Carol Paxson
paxson@postgres.berkeley.edu