How to crash postgres using savepoints

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: How to crash postgres using savepoints
Date: 2004-08-03 01:44:05
Message-ID: 410EEDE5.20204@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 while processing 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2004-08-03 02:00:41 Re: pg_dump bug fixing
Previous Message Tom Lane 2004-08-03 01:24:29 Re: Anybody have an Oracle PL/SQL reference at hand?