Without a core dump or a repeatable test case, there's not really
anything we can do to help you here.
On Jun 23, 2006, at 12:42 AM, "" <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]> wrote:
The following bug has been logged online:
Bug reference: 2491
Logged by:
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.4
Operating system: Debian sid unstable
Description: Database crash and restart
Details:
Situation:
I have running transaction which makes a frequently calls to a pl/
pgSQL
functions via several triggers. All in one transaction. Transaction
running
for a 30 sec - 1 min time longs. Then I have a file with this
functions.
CREATE OR REPLACE FUNCTION ........
I made this: cat <my_file> | psql <base> -U postgres
SQL server crashed.
When no transaction active, all fine.
I can not wait a transaction to finish, because it may begin again
immediately, and again, and again. Untill "system" decided to make
some
waiting for a some event.
---------------------------(end of
broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
