Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2])
	by hub.org (8.9.3/8.9.3) with ESMTP id SAA00564
	for <pgsql-interfaces@postgreSQL.org>;
	Sun, 28 Nov 1999 18:46:36 -0500 (EST)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id SAA09173;
	Sun, 28 Nov 1999 18:45:26 -0500 (EST)
To: Ivo Simicevic <ivo@ultra.hr>
cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] ERROR: cannot find attribute 1 of relation
	pg_temp.460.0
In-reply-to: Your message of Sun, 28 Nov 1999 23:18:14 +0100
	<19991128231814.A487@ultra.hr>
Date: Sun, 28 Nov 1999 18:45:26 -0500
Message-ID: <9171.943832726@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

Ivo Simicevic <ivo@ultra.hr> writes:
> After creating temporary table with CREATE TEMP TABLE command in ECPG
> I get following error when disconnecting / exiting program:

I believe this is triggered by ecpg's autocommit feature, and that
you could work around it by ensuring that at least one commit occurs
between creation of the temp table and application exit.  It looks
like 6.5.* gets confused if it has to delete a never-yet-committed
temp table :-(.

I don't see any such problem with current sources, but I dunno if it's
practical to back-patch a fix into 6.5.*.  The current sources have
diverged quite a bit in that area...

			regards, tom lane