>>> Why do you want to lock at all? > >> It's long and sad story ;( > >If you don't explain what you're trying to accomplish, you're unlikely >to get useful advice.
Tom, I need table level locks for cooperative usage in my application. LOCK TABLE table_name in EXCLUSIVE MODE and LOCK TABLE table_name in SHARED MODE perfectly suit my needs. The only drawback - interference with VACUUM and other system processes with obvious performance/response time penalty. So I need very simple thing: locks behave exactly like EXCLUSIVE and SHARED I can use to control my own application processes. Honestly I've already introduced such locks with syntax LOCK TABLE table_name in APPLICATION EXCLUSIVE MODE and LOCK TABLE table_name in APPLICATION SHARED MODE Does publishing of this patch make any sense? I can explain what is the reason of table locks usage (briefly I need this thing to provide transaction isolation). Story is long and sad indeed, though I can retell it if it seems to be useful. Thanks a lot for your response. -- Best regards Ilja Golshtein ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly