Revisited: Does error within transaction imply restarting it?

From: Haroldo Stenger <hstenger(at)adinet(dot)com(dot)uy>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Revisited: Does error within transaction imply restarting it?
Date: 2000-06-12 21:12:43
Message-ID: 3945524B.FC28997F@adinet.com.uy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi everybody,

I'm the one seeking PostgreSQL not to fall in *ABORT STATE* after an erroneous
command within a transaction. Peter Eisentrout, suggested a couple of months
ago, to hack the backend in a very simple way (deleting the line which aborted
after an error). This worked well for me in 6.5.3 as far as I could test. But in
7.0, this doesn't perform well, as some other folk already reported. I'm willing
to do as much work as I can towards getting this behaviour change as soon as
possible. I would like you all to help me starting a discussion, where I could
find the central issues which will allow to get this done.

Specifically, the problem which generates deleting the above mentioned line, is
corrupted shared memory, and backend chrash and restart.

Any suggestions?

Regards,
Haroldo Stenger.

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2000-06-12 21:24:43 Re: [Fwd: PostgreSQL RPMS...]
Previous Message Lamar Owen 2000-06-12 21:09:45 Re: [Fwd: PostgreSQL RPMS...]