Re: [GENERAL] Connecting to an existing transaction state.

2008-07-30 Thread Craig Ringer
Alvaro Herrera wrote: > Alex Gen wrote: >> Hello, >> >> I’m in the process of creating a set of scripts for testing certain locking >> features in an application. >> What I would like to do: >> 1. Start a connection from machine-01 through the m01-s1.sql script. >> 2.While (1) is running, start an

Re: [GENERAL] Connecting to an existing transaction state.

2008-07-30 Thread Alvaro Herrera
Alex Gen wrote: > Hello, > > I’m in the process of creating a set of scripts for testing certain locking > features in an application. > What I would like to do: > 1. Start a connection from machine-01 through the m01-s1.sql script. > 2.While (1) is running, start another transaction on the same

Re: [GENERAL] Connecting to an existing transaction state.

2008-07-30 Thread Francisco Reyes
On 10:37 am 07/28/08 Alex Gen <[EMAIL PROTECTED]> wrote: > 3. Using m01-s2.sql I would like to execute a certain SQL statement > – BUT within the scope of the transaction begun by m01-s1.sql. I believe that is not possible. Specially if you are within a transaction on each of the scripts. As far

[GENERAL] Connecting to an existing transaction state.

2008-07-30 Thread Alex Gen
Hello, I’m in the process of creating a set of scripts for testing certain locking features in an application. What I would like to do: 1. Start a connection from machine-01 through the m01-s1.sql script. 2.While (1) is running, start another transaction on the same database from machine-02 usin

[GENERAL] Connecting to an existing transaction state.

2008-07-28 Thread Alex Gen
Hello, I’m in the process of creating a set of scripts for testing certain locking features in an application. What I would like to do: 1. Start a connection from machine-01 through the m01-s1.sql script. 2.While (1) is running, start another transaction on the same database from machine-02 usin