Hi,
I don't know about the crashes, but try using 'SELECT'
instead of 'SALACT' (where the hell did you get *that*
from??).
Maarten
> 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]
--
Maarten Boekhold, boekhold@tibco.com
TIBCO Finance Technology Inc.
The Atrium
Strawinskylaan 3051
1077 ZX Amsterdam, The Netherlands
tel: +31 20 3012158, fax: +31 20 3012358
http://www.tibco.com