Received: from punta.ultra.hr (postfix@pp1m8.zadarnet.hr [195.29.197.148]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA72335 for ; Sun, 28 Nov 1999 16:49:24 -0500 (EST) (envelope-from ivo@punta.ultra.hr) Received: by punta.ultra.hr (Postfix, from userid 1001) id 253B13C8FC; Sun, 28 Nov 1999 23:18:15 +0100 (CET) Date: Sun, 28 Nov 1999 23:18:14 +0100 From: Ivo Simicevic To: pgsql-interfaces@postgreSQL.org Subject: ERROR: cannot find attribute 1 of relation pg_temp.460.0 Message-ID: <19991128231814.A487@ultra.hr> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/0.95.7i Sender: ivo@punta.ultra.hr After creating temporary table with CREATE TEMP TABLE command in ECPG I get following error when disconnecting / exiting program: query: close C1 ProcessUtility: close C1 CommitTransactionCommand proc_exit(0) [#0] shmem_exit(0) [#0] ERROR: cannot find attribute 1 of relation pg_temp.460.0 pq_flush: send() failed: Bad file descriptor AbortCurrentTransaction pq_flush: send() failed: Bad file descriptor FATAL 1: Socket command type pq_flush: send() failed: Bad file descriptor proc_exit(0) [#1] ERROR: unknown frontend message was received pq_flush: send() failed: Bad file descriptor AbortCurrentTransaction NOTICE: AbortTransaction and not in in-progress state pq_flush: send() failed: Bad file descriptor /usr/lib/postgresql/bin/postmaster: reaping dead processes... /usr/lib/postgresql/bin/postmaster: CleanupProc: pid 460 exited with status 11 /usr/lib/postgresql/bin/postmaster: CleanupProc: reinitializing shared memory and semaphores shmem_exit(0) [#0] binding ShmemCreate(key=52e519, size=4794368) If I try to delete temporary table before disconnecting things get even worse - it enters infinite loop of errors. Any clue what is wrong? Regards, Ivo Simicevic.