Re: [GENERAL] using column as 'mutex'

2009-12-06 Thread Dennis Gearon
RE all below: (hand assembled reply) I looked through all the documentation, and I did not find 'WITH UPDATE' as part of any transaction type, so I didn't end up using that information. For the record, (in the mail lists), I am using symfony/Doctrine ORM. I used something like this:     try {

Re: [GENERAL] using column as 'mutex'

2009-11-30 Thread Merlin Moncure
On Mon, Nov 30, 2009 at 9:02 PM, Dennis Gearon wrote: > I want to use a dbase record in Postgresql as a mutex in a garbage > collection/file upload system. > > If I tranfer an uploaded file to a directory, write all its meta information > and file name in a record, the user should have 5 minutes

[GENERAL] using column as 'mutex'

2009-11-30 Thread Dennis Gearon
I want to use a dbase record in Postgresql as a mutex in a garbage collection/file upload system. If I tranfer an uploaded file to a directory, write all its meta information and file name in a record, the user should have 5 minutes to finish inputting the required info for the record. (I want