The following bug has been logged online:
Bug reference: 2491
Logged by:
Email address: wizard580@gmail.com
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.