Hello everybody,
I trying to run PostgreSQL 6.4 (or 6.4.2) on a HP-Ux 10.10. The
problem is that the backend process is dieing after two SQL errors.
When I do the following the backend will die:
psql test
=> SALACT * FROM test;
Error ....
=> SALACT * FROM test;
Error ....
Well nobody is using a database in this way nevertheless I feel that
my something in my system is not configured the way it should be.
I tried to compile version 6.4 and 6.4.2 either with gcc 2.7.2.3 and
2.8.1. The result is the same.
The exit code of the backend process is 138.
Any help welcome.
Reiner Nippes
UMS GmbH, Ulm - Germnay
From the log file:
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
ERROR: pg_atoi: error in "34.5": can't parse ".5"
AbortCurrentTransaction
StartTransactionCommand
query: INSERT INTO INT2_TBL(f1) VALUES ('32767');
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
query: INSERT INTO INT2_TBL(f1) VALUES ('-32767');
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
ERROR: pg_atoi: error reading "100000": Result too large
AbortCurrentTransaction
/data/app/postgres/bin/postmaster: reaping dead processes...
/data/app/postgres/bin/postmaster: CleanupProc: pid 17725 exited with status 138
/data/app/postgres/bin/postmaster: CleanupProc: reinitializing shared memory and semaphores
shmem_exit(0) [#0]