Andrew Dunstan wrote: > Alvaro Herrera wrote: > >Alvaro Herrera wrote: > > > >>Note that it may fail! This seems to indicate that some platforms do > >>not provide either locking mechanism. > > > >(Which means the whole discussion is a waste of time) > > Umm, no, I don't think so. It will block instead of failing unless you > request a non blocking call. Failure means someone else holds the lock.
I removed the part of the manual I had written which said that it will raise an error if the platform it's running doesn't have any locking primitive. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend