Subject: Probably a naive LIBPQ problem/question...

From: [email-masked]
Date: Mon, 21 Oct 91 22:10:29 EDT

I have been attempting to use the programmer's interface into POSTGRES,
libpq.  I seemed to be running into the following problem:
Any suggestions or comments or usual netwisdom would be appreciated.

(The database exists and tuples can be retrieved via interactive commands
 from the frontend)
 
Actual output follows....

Database Accessed: jmcfoo
Start Retrieve
NOTICE:Oct 21 21:47:36:RelationBuildDesc: (relation name student) nonexistent
 
WARN:Oct 21 21:47:36:heap_openr on student failed

End Retrieve and Begin Fetch
NOTICE:Oct 21 21:47:36:(transaction aborted): queries ignored until END
 
End Fetch
NOTICE:Oct 21 21:47:36:(transaction aborted): queries ignored until END
 
output end....

Program which created the output follows...

#include <stdio.h>
#include "libpq.h"

main ()
{
  int i,j,k,g,n,m,t ;
  PortalBuffer *p ;
  char pnames[MAXPORTALS][portal_name_length];

  PQsetdb("jmcfoo");

  printf("Database Accessed: %s\n",PQdb ());

  PQexec("begin");
  printf("Start Retrieve\n");
  PQexec("retrieve portal eportal (student.all)");

  printf("End Retrieve and Begin Fetch\n");
  PQexec("fetch all in eportal");
 
  printf("End Fetch and Close Portal\n");
  PQexec("close eportal");
  PQexec("end");
}

program listing end...

 
 -- 
 John M. Connors, Systems Programmer, Student of Computer Science
 University Computing,University of Vermont, Burlington, VT  05405-0160
 [email-masked], [email-masked]
 Work: 656-2012 Home: 656-2012

-- 
John M. Connors, Systems Programmer, UVM, 113J Waterman Building
[email-masked], [email-masked]
Work: 656-2012 Home: 656-2012