Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA13807; Tue, 18 Feb 92 08:27:44 -0800
Date: Tue, 18 Feb 92 08:27:44 -0800
Message-Id: <9202181627.AA13807@postgres.Berkeley.EDU>
From: joseash@bush.tamu.edu (Alfredo Sanchez)
Subject: Re: no response from backend, exiting...
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu


i have created a new db and changed my query from

	PQexec("destroy temp1 destroy temp2 destroy temp3");
to:

	PQexec("destroy temp1");
	PQexec("destroy temp2");
	PQexec("destroy temp3");

and now my program runs as i expected. thanks.

nonetheless, if i am also running the monitor while i execute
my program, and then i submit any query using the monitor, it
still crashes, issuing the same message as before ("I have been
signalled by the postmaster. Some backend process has died
unexpectedly and ...). 
when i run the monitor again, it works ok.

btw, what are all those temp_* files created in the data/base/mydb
directory? can i delete them? (i have not touched them this time)

and for my old database, when i run the backend standalone,
following your advise, and i type any query, it dies with a
	Bus error (core dumped)
message. do you think there is any way to recover this db?

thanks a lot for your help.

J Alfredo Sanchez H
-------------------
Hypertext Research Lab
Department of Computer Science
Texas A&M University