pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
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
Date: Sun, 28 Nov 1999 18:45:26 -0500
Message-ID: <9171.943832726@sss.pgh.pa.us> (raw)
In-Reply-To: <19991128231814.A487@ultra.hr>

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



view thread (3+ messages)  latest in thread

Message-ID: <9171.943832726@sss.pgh.pa.us>
Permalink:  ../9171.943832726@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/9171.943832726@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: tgl@sss.pgh.pa.us, ivo@ultra.hr
  Subject: Re: [INTERFACES] ERROR: cannot find attribute 1 of relation pg_temp.460.0
  In-Reply-To: <9171.943832726@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox