Return-Path: owner-postman Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id IAA02563 for postgres-redist; Wed, 10 Aug 1994 08:08:06 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199408101508.IAA02563@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from cheviot.ncl.ac.uk (cheviot.ncl.ac.uk [128.240.2.10]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id IAA02553 for ; Wed, 10 Aug 1994 08:08:04 -0700 Received: from bowes.ncl.ac.uk by cheviot.ncl.ac.uk id (5.65cVUW/NCL-CMA.1.35 for ) with SMTP; Wed, 10 Aug 1994 15:38:07 +0100 From: "David Alan Nelson" Message-Id: Subject: Temporary Relations To: postgres@postgres.Berkeley.EDU (Postgres) Date: Wed, 10 Aug 1994 14:46:57 +0100 (BST) Cc: n.s.smith@newcastle.ac.uk (Neville Smith) X-Mailer: ELM [version 2.4 PL23] Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Length: 496 Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Wed, 10 Aug 94 08:08:06 -0700 Resent-XMts: smtp In a definition of a function, I have a line such as retrieve into temp .... and then later on, in the same function, or a function nested either below it, or above it, I need to retrieve from that table. Unfortunately though, I get an error message 'heap openr on temp failed', presumably this is a scoping problem. Anyone know how I can get round it. cheers Dave Nelson -- Mail ID : D.A.Nelson@newcastle.ac.uk Computing Science, University of Newcastle upon Tyne, UK. (091) 222 8789 ============================================================================== To add/remove yourself to/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. ==============================================================================