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.