Subject Re: [firebird-support] Lock conflicts
Author Martijn Tonies
Hi Tim,

> Is this field level, record level or table level?

As far as I know, Firebird doesn't have table-level
locks, but only record-level locks.


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

> At 04:13 PM 6/17/2003 +0200, you wrote:
>
> >Hi Tim,
> >
> > > I am getting the following error :
> > >
> > > "lock conflict on no wait transaction"
> > >
> > > What causes it? How can I resolve it?
> >
> >It's caused by a deadlock:
> >
> >1 transaction having changed a record but not committed yet,
> >and another transaction attempting to change this record as well.
> >
> >
> >With regards,
> >
> >Martijn Tonies
> >Database Workbench - the developer tool for InterBase & Firebird
> >Upscene Productions
> >http://www.upscene.com
> >
> >
> >To unsubscribe from this group, send an email to:
> >firebird-support-unsubscribe@yahoogroups.com
> >
> >
> >
> >Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
> >
> >
> >
> >---
> >Incoming mail is certified Virus Free.
> >Checked by AVG anti-virus system (http://www.grisoft.com).
> >Version: 6.0.489 / Virus Database: 288 - Release Date: 6/10/2003
>
>
> [Non-text portions of this message have been removed]
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>