Postgres Pro
Downloads
Home   >   mailing lists

FATAL 2: RelationPutHeapTuple: failed to add tuple - Mailing list pgsql-general

From Andrew Bartley
Subject FATAL 2: RelationPutHeapTuple: failed to add tuple
Date
Msg-id 00ce01c1c3f5$0a73ce50$3200a8c0@abartleypc
Whole thread Raw
Responses Re: FATAL 2: RelationPutHeapTuple: failed to add tuple  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
Hi,
 
I'm having trouble creating temp tables.
 
Can anyone help me with this?
 
Short of Dumping, dropping, creating and restoring the DB, I'm not sure what to do from here.
 
We have been running this particular function for months.  Today it just does't want to play the game.
 
2002-03-05 14:09:02 [1014]   DEBUG:  query: create temp table request_transnumbers ( transnumber int8 )
2002-03-05 14:09:02 [1014]   FATAL 2:  RelationPutHeapTuple: failed to add tuple
2002-03-05 14:09:02 [1014]   DEBUG:  proc_exit(2)
2002-03-05 14:09:02 [1014]   DEBUG:  shmem_exit(2)
/usr/lib/postgresql/bin/postmaster: ServerLoop:         handling reading 5
/usr/lib/postgresql/bin/postmaster: ServerLoop:         handling reading 5
/usr/lib/postgresql/bin/postmaster: ServerLoop:         handling reading 5
/usr/lib/postgresql/bin/postmaster: ServerLoop:         handling reading 5
/usr/lib/postgresql/bin/postmaster: ServerLoop:         handling writing 5
/usr/lib/postgresql/bin/postmaster: BackendStartup: pid 1016 user postgres db evolvo socket 5
/usr/lib/postgresql/bin/postmaster child[1016]: starting with (postgres -d2 -v131072 -p evolvo )
FindExec: found "/usr/lib/postgresql/bin/postgres" using argv[0]
2002-03-05 14:09:02 [1016]   DEBUG:  connection: host=[local] user=postgres database=evolvo
2002-03-05 14:09:02 [1016]   DEBUG:  InitPostgres
2002-03-05 14:09:02 [1016]   DEBUG:  StartTransactionCommand
Thanks
 
Andrew Bartley

pgsql-general by date:

Previous
From: "otisg"
Date:
Subject: Re: Help with SET TRANSACTION in a function
Next
From: Darren Ferguson
Date:
Subject: Re: Help with SET TRANSACTION in a function