Re: [GENERAL] Lock rekord

2000-06-19 Thread Herbert Liechti
"Pawe³ Dubin" wrote: > List z dnia: Sat, 17 Jun 2000, : > > > I usually prefer the following trick for preventing long locking > > > times. On every > > > table I define a timestamp field which is updated every time the record is > > > written to the database. If a user edits a record (without

RE: [GENERAL] Lock rekord

2000-06-18 Thread Pawe³ Dubin
List z dnia: Sat, 17 Jun 2000, : > > I usually prefer the following trick for preventing long locking > > times. On every > > table I define a timestamp field which is updated every time the record is > > written to the database. If a user edits a record (without > > locking) and commit his chan

RE: [GENERAL] Lock rekord

2000-06-17 Thread Andrew Snow
> I usually prefer the following trick for preventing long locking > times. On every > table I define a timestamp field which is updated every time the record is > written to the database. If a user edits a record (without > locking) and commit his changes > the timestamp is returned from the cli

Re: [GENERAL] Lock rekord

2000-06-17 Thread Herbert Liechti
"Pawe³ Dubin" wrote: > Hello > > I was listening Your discusion. I have practical problem for which I write my > own locking system: > > Now A change zip and write all > B change adress and write > > so zip is unchanged. > > In pgsql I can solve it by SELECT FOR UPDATE but if user A goes for caff