Re: [BUGS] How to crash postgres using savepoints

2006-11-16 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> ... Did we explicitly decide >> to do this differently from spec, and if so why? > Yeah, we did. I think the rationale was what happens when you have > another savepoint in the middle, say > SAVEPOINT foo; > SAVEPOINT bar; > SAVEPOI

Re: [BUGS] How to crash postgres using savepoints

2006-11-16 Thread Alvaro Herrera
Tom Lane wrote: > Actually, I'd say the dubious behavior here is that > > SAVEPOINT foo; > SAVEPOINT foo; > SAVEPOINT foo; > > creates three nested savepoints ... it might be better if it > automatically released any existing savepoint of the same name. > I notice that the SAVE

Re: [BUGS] How to crash postgres using savepoints

2006-11-16 Thread Joseph Shraibman
Tom Lane wrote: Joseph Shraibman writes: See example below. At the very least the documentation needs to tell users that savepoints use shared memory, and the cofusing HINT string needs to be changed to something more useful. Which part of "You may need to increase max_locks_per_transactio

Re: [BUGS] How to crash postgres using savepoints

2006-11-16 Thread Tom Lane
Joseph Shraibman writes: > See example below. At the very least the documentation needs to tell > users that savepoints use shared memory, and the cofusing HINT string > needs to be changed to something more useful. Which part of "You may need to increase max_locks_per_transaction" do you find

[BUGS] How to crash postgres using savepoints

2006-11-15 Thread Joseph Shraibman
See example below. At the very least the documentation needs to tell users that savepoints use shared memory, and the cofusing HINT string needs to be changed to something more useful. When run on a machine running 8.2b3 version: PostgreSQL 8.2beta3 on i686-pc-linux-gnu, compiled by GCC gcc