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