postgres transaction php trigger rollback
| From: | Igor Kryltsov | Date: | Fri, 26 Apr 2002 05:21:17 +0000 |
| Subject: | postgres transaction php trigger rollback | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18823@lists.php.net to get a copy of this message | ||
Hi,
1. User clicks edit_record.php page
2. Page starts transaction and SELECT FOR UPDATE (say this is PostgreSQL)
3. User instead of clicking Submit/Reset buttons goes to www.boyplay.com
4. Other users can not edit this record because it was locked.
If somebody can give me an idea how to trigger Rollback on server.
I see the only solution here -- using sessions with timeout equals to
reasonable value for each particular page which requires transaction.
Thank you,
Igor