agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: perera@pollux.cs.uga.edu
To: postgres@postgres.Berkeley.EDU
Subject: libpq question.
Date: Tue, 3 May 1994 22:22:28 -0400 (EDT)
Message-ID: <9405040222.AA21010@pollux.cs.uga.edu> (raw)

Hi:

I am having a problem with the mesg that I get back from PQexec.
	...
	char *q1 = "define view toy ( sno = s.sno, city = s.city )";
	char *q2 = "retrieve ( toy.all )";
	char *response = NULL;
	response = (char *) PQexec(q1);  /*  response has CAPPEND 373920 */
	response = (char *) PQexec(q2);  /*  response has CDEFINE */
	response = (char *) PQexec(q2);  /*  response has Pblank */
	...

Why is that the first time I do query q2 I get a CDEFINE and the next time
I get a Pblank ? I thought that doing a retrieve gives a "Pblank" from PQexec.
Am I doing something incorrectly here ?

postgres version 4.1, on a SUN 690MP.

Thanks,

-- Niranjan

-- 
 _   /|
 \'o.O'  Niranjan Perera, 415 GSRC Bldg,CS Dept | EMAIL: perera@cs.uga.edu
 =(_^_)= University Of Georgia, Athens GA30602. | PHONE: [+1] 706-548-5826
    U

===============================================================================
    To add/remove yourself from the POSTGRES mailing list: send mail with 
    the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"

    If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
    a human will deal with it.  DO NOT post to the "postgres" mailing list.
===============================================================================

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: perera@pollux.cs.uga.edu
  Subject: Re: libpq question.
  In-Reply-To: <9405040222.AA21010@pollux.cs.uga.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox