Re: [INTERFACES] ERROR: cannot find attribute 1 of relation pg_temp.460.0 - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: [INTERFACES] ERROR: cannot find attribute 1 of relation pg_temp.460.0
Date
Msg-id 9171.943832726@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: cannot find attribute 1 of relation pg_temp.460.0  (Ivo Simicevic <ivo@ultra.hr>)
Responses Re: [INTERFACES] ERROR: cannot find attribute 1 of relation pg_temp.460.0  (Michael Meskes <meskes@postgresql.org>)
Re: [INTERFACES] ERROR: cannot find attribute 1 of relation pg_temp.460.0  (Michael Meskes <meskes@postgresql.org>)
List pgsql-interfaces
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


pgsql-interfaces by date:

Previous
From: Ivo Simicevic
Date:
Subject: ERROR: cannot find attribute 1 of relation pg_temp.460.0
Next
From: The Hermit Hacker
Date:
Subject: libpq + multiple connections ...