Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA09895; Wed, 2 Sep 92 05:51:14 -0700
Date: Wed, 2 Sep 92 05:51:14 -0700
Message-Id: <9209021251.AA09895@postgres.Berkeley.EDU>
From: neve@nlm.nih.gov (Leif Neve)
Subject: heap_openr failure with portals
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu

 
> I was fiddling with the testlibpq.c sample code on page 100 of the Postgres
> Reference. It was getting a heap_openr failure on 'retrieve portal':
> 
>       21       PQexec ("retrieve portal eportal (EMP.all)");
>    (dbx) n
>    WARN:Sep  1 14:23:51:heap_openr on EMP failed
> 
> So I tried it in the monitor. Initially it worked fine.  But as soon as I
> tried it a second time, it failed with the same error:
> 
>      * begin \g
> 
>      Query sent to backend is "begin "
>      BEGIN
>      Go
>      * retrieve portal eportal (EMP.all) \g
> 
>      Query sent to backend is "retrieve portal eportal (EMP.all) "
>      WARN:Sep  1 14:39:38:heap_openr on EMP failed
> 
> I recreated the demo database and restarted the postmaster, and I still get
> the same error. A simple "retrieve (emp.all)" still works.

I guess relation names are case sensitive? Anyway, try changing "EMP.all"
to "emp.all" in your test program.

Leif Neve