How to crash postgres using savepoints - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject How to crash postgres using savepoints
Date
Msg-id 410EEDE5.20204@familyhealth.com.au
Whole thread Raw
Responses Re: How to crash postgres using savepoints
List pgsql-hackers
test=# begin;
BEGIN
test=# savepoint "A";
SAVEPOINT
test=# rollback to a;
server closed the connection unexpectedly        This probably means the server terminated abnormally        before or
whileprocessing the request.
 
LOG:  server process (PID 45905) was terminated by signal 11
LOG:  terminating any other active server processes
The connection to the server was lost. Attempting reset: LOG: 
background writer process (PID 45899) exited with exit code 1
LOG:  all server processes terminated; reinitializing
LOG:  database system was interrupted at 2004-08-03 09:42:11 WST
LOG:  checkpoint record is at 0/A7067C

Chris


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Anybody have an Oracle PL/SQL reference at hand?
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: pg_dump bug fixing