Postgres Pro
Downloads
Home   >   mailing lists

Re: table locks - Mailing list pgsql-general

From Ilja Golshtein
Subject Re: table locks
Date
Msg-id 4590C4C7.000004.06314@ariel.yandex.ru
Whole thread Raw
In response to Re: table locks  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: table locks  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
>But seriously, why block autovacuum? It no visible effect on the table.

I DO NOT want to block autovacuum.
I need lock modes do not interfere with anything else just to use in my application.

user_locks is fine, while it does not provide waiting (only immediate Yes or No).

>Why do you want to lock at all?

It's long and sad story ;(

--
Best regards
Ilja Golshtein

pgsql-general by date:

Previous
From: "Henrique P Machado"
Date:
Subject: Re: NEED URGENT HELP....
Next
From: Tom Lane
Date:
Subject: Re: table locks