Re: [SQL] transaction locking

2003-09-18 Thread tom baker
On Thursday 18 September 2003 11:24, Stephan Szabo pronounced: > On Thu, 18 Sep 2003, tom baker wrote: > > ah, yes, i DID not see the NOT. that is fixed. here is the code that is > > having problems (paired down; all error checking has been removed!) > > > > $res=pg_query( "BEGIN TRANSACTION" ) ; >

Re: [SQL] transaction locking

2003-09-18 Thread Stephan Szabo
On Thu, 18 Sep 2003, tom baker wrote: > ah, yes, i DID not see the NOT. that is fixed. here is the code that is having > problems (paired down; all error checking has been removed!) > > $res=pg_query( "BEGIN TRANSACTION" ) ; > > $sql = "LOCK TABLE parts IN SHARE ROW EXCLUSIVE MODE" ; > $res = pg_q

Re: [SQL] transaction locking

2003-09-18 Thread tom baker
On Wednesday 17 September 2003 22:33, Stephan Szabo pronounced: > On Wed, 17 Sep 2003, tom baker wrote: > > i am (probably) shooting myself in the foot, but here goes the question. > > > > inside of a begin transaction/commit block, i am attempting to insert a > > record into a parts table, and the

Re: [SQL] transaction locking

2003-09-17 Thread Stephan Szabo
On Wed, 17 Sep 2003, tom baker wrote: > i am (probably) shooting myself in the foot, but here goes the question. > > inside of a begin transaction/commit block, i am attempting to insert a record > into a parts table, and then insert a record that references the part into an > application table.

[SQL] transaction locking

2003-09-17 Thread tom baker
hello all i am (probably) shooting myself in the foot, but here goes the question. inside of a begin transaction/commit block, i am attempting to insert a record into a parts table, and then insert a record that references the part into an application table. and the transaction fails with this