any idea regarding this error? - Mailing list pgsql-novice

TIA:

PostgreSQL 7.2; OS Red Hat Linux release 7.3 (Valhalla); 2016 MB Memory;
15% Disk Space Usage

description: an insert into a table fires a trigger that creates other
tables.  same script works in 7.1 & 7.3;

LOGS:

NOTICE:  CREATE TABLE / UNIQUE will create implicit index
'dc_ls_isay_igreet_id_key' for table 'dc_ls_isay_igreet'
NOTICE:  CREATE TABLE will create implicit sequence
'mt_ls_isay_igreet_id_seq' for SERIAL column 'mt_ls_isay_igreet.id'
NOTICE:  CREATE TABLE / UNIQUE will create implicit index
'mt_ls_isay_igreet_id_key' for table 'mt_ls_isay_igreet'
NOTICE:  CREATE TABLE will create implicit sequence
'cm_ls_igreet_message_id_seq' for SERIAL column 'cm_ls_igreet_message.id'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'cm_ls_igreet_message_pkey' for table 'cm_ls_igreet_message'
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
NOTICE:  CREATE TABLE will create implicit sequence
'tb_ls_isay_igreet_id_seq' for SERIAL column 'tb_ls_isay_igreet.id'
NOTICE:  CREATE TABLE / UNIQUE will create implicit index
'tb_ls_isay_igreet_id_key' for table 'tb_ls_isay_igreet'
DEBUG:  server process (pid 5203) was terminated by signal 11
DEBUG:  terminating any other active server processes
DEBUG:  all server processes terminated; reinitializing shared memory and
semaphores
DEBUG:  database system was interrupted at 2003-07-29 17:42:21 PHT
DEBUG:  checkpoint record is at 0/33EA050
DEBUG:  redo record is at 0/33EA050; undo record is at 0/0; shutdown TRUE
DEBUG:  next transaction id: 1425; next oid: 740388
DEBUG:  database system was not properly shut down; automatic recovery in
progress
DEBUG:  redo starts at 0/33EA090
FATAL 1:  The database system is starting up
DEBUG:  ReadRecord: invalid magic number 0000 in log file 0, segment 3,
offset 4440064
DEBUG:  redo done at 0/343BFA8
DEBUG:  database system is ready

PSQL:

mel=# insert into rs_keyword (keyword,pretty_name,
description,service_type_id, service_start, service_end) values
mel-# ('igreet','Greetings','Greeting Service',1,now(),'2003-08-01');
NOTICE:  CREATE TABLE will create implicit sequence
'dc_ls_isay_igreet_id_seq' for SERIAL column 'dc_ls_isay_igreet.id'
NOTICE:  CREATE TABLE / UNIQUE will create implicit index
'dc_ls_isay_igreet_id_key' for table 'dc_ls_isay_igreet'
NOTICE:  CREATE TABLE will create implicit sequence
'mt_ls_isay_igreet_id_seq' for SERIAL column 'mt_ls_isay_igreet.id'
NOTICE:  CREATE TABLE / UNIQUE will create implicit index
'mt_ls_isay_igreet_id_key' for table 'mt_ls_isay_igreet'
NOTICE:  CREATE TABLE will create implicit sequence
'cm_ls_igreet_message_id_seq' for SERIAL column 'cm_ls_igreet_message.id'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'cm_ls_igreet_message_pkey' for table 'cm_ls_igreet_message'
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
NOTICE:  CREATE TABLE will create implicit sequence
'tb_ls_isay_igreet_id_seq' for SERIAL column 'tb_ls_isay_igreet.id'
NOTICE:  CREATE TABLE / UNIQUE will create implicit index
'tb_ls_isay_igreet_id_key' for table 'tb_ls_isay_igreet'
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!#

Regards,

Mel Jamero