why my postgresql auto crashed???

hi, all
when I do the command from a sql file by psql client, I got the message:
----
psql:/home/zhay/insert.sql:8: server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
psql:/home/zhay/insert.sql:8: connection to server was lost
----
my sql file is :
set search_path to lives;

insert into store_all select c.*, z.t from  (
        select b.*, y.t from (
                select a.*,  x.t from store a
                        left join (select pid,
array_to_string(array_accum(anchor), ' ') as t
from recommend group by pid)x on x.pid = a.id
        )b left join (select pid, array_to_string(array_accum(anchor), '
') as
t from tag group by pid)y on y.pid = b.id
)c left join (select pid, array_to_string(array_accum(anchor), ' ') as t
from categorie group by pid)z on z.pid = c.id;



so, I check the pg_log
------------
TRAP: FailedAssertion("!(file->curFile >= 0)", File: "buffile.c", Line:
317)
LOG:  server process (PID 4121) was terminated by signal 6: Aborted
LOG:  terminating any other active server processes
WARNING:  terminating connection because of crash of another server
process
DETAIL:  The postmaster has commanded this server process to roll back
the current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT:  In a moment you should be able to reconnect to the database and
repeat your command.
WARNING:  terminating connection because of crash of another server
process
DETAIL:  The postmaster has commanded this server process to roll back
the current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT:  In a moment you should be able to reconnect to the database and
repeat your command.
HINT:  In a moment you should be able to reconnect to the database and
repeat your command.
LOG:  all server processes terminated; reinitializing
LOG:  database system was interrupted; last known up at 2008-07-27
07:36:16 UTC
LOG:  database system was not properly shut down; automatic recovery in
progress
FATAL:  the database system is in recovery mode
LOG:  redo starts at D/3FB00BC0
LOG:  record with zero length at D/3FB59898
LOG:  redo done at D/3FB59868
LOG:  last completed transaction was at log time 2008-07-27
07:40:53.70866+00
LOG:  autovacuum launcher started
LOG:  database system is ready to accept connections
------------

thanks all.

regards.