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=p

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 > > rec

[SQL] transaction locking

2003-09-17 Thread tom baker
query( $sql ) ; if (strlen ($r=pg_last_error( $db ) ) ) { $replaces.="SQL: $sql\n" ; $replaces.= $r."\n" ; pg_connection_reset( $db ) ; $failed = -1 ; } if ( $failed == 0 ) { ... -- tia, tom baker former ingres programmer... I'