Thread: lock row

lock row

From
Jonathan Davic
Date:
hello

how to lock a row in the table in postgresql ?

thanks


Re: [INTERFACES] lock row

From
José Soares
Date:
Jonathan Davic ha scritto:

> hello
>
> how to lock a row in the table in postgresql ?
>
> thanks

PostgreSQL current version allows only table locks.
If you need row-level locking you have to wait for v6.5 (1 Jun).
______________________________________________________________
PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jose'