Re: Concurrent update to database (PostgreSQL or MySQL) ??
| From: | Cornelia Boenigk | Date: | Wed, 18 Apr 2001 12:45:36 +0000 |
| Subject: | Re: Concurrent update to database (PostgreSQL or MySQL) ?? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-8653@lists.php.net to get a copy of this message | ||
Hi Nicolas
> Ideally, I would like to lock the record when a user open
it for
> modification.
Normally this is done by the database-management-system
itself, so you dont't have to deal with it. Each system has
it's own built-in locking mechanism.
If you use PostgreSQL, you can put your queries into a
transaction, then no other process can get access to the
affected records during the operations in the transaction.
Greetings
Conni