Skip site navigation (1) Skip section navigation (2)

ERROR: cannot find attribute 1 of relation pg_temp.460.0

From: Ivo Simicevic <ivo(at)ultra(dot)hr>
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: ERROR: cannot find attribute 1 of relation pg_temp.460.0
Date: 1999-11-28 22:18:14
Message-ID: 19991128231814.A487@ultra.hr (view raw or flat)
Thread:
Lists: pgsql-interfaces
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.

pgsql-interfaces by date

Next:From: Tom LaneDate: 1999-11-28 23:45:26
Subject: Re: [INTERFACES] ERROR: cannot find attribute 1 of relation pg_temp.460.0
Previous:From: Brian HaneyDate: 1999-11-28 08:07:18
Subject: RE: pgsql-interfaces-digest V1 #562

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group