drop index without accessexclusivelock in transaction (JAVA)

From: Emi <emilu(at)encs(dot)concordia(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: drop index without accessexclusivelock in transaction (JAVA)
Date: 2015-11-18 16:48:43
Message-ID: 564CABEB.4070207@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

Through java jdbc, is it possible that we do the following steps without
accessexclusivelock for index:

setautocommit(false);

drop index1, 2,....;
insert millions records
set index1,2...
commit;

Found this post, but it says only within psql block begin/commit, users
are able to do it.
http://stackoverflow.com/questions/19324637/postgres-transaction-seems-to-take-accessexclusivelock-for-no-reason

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Will McCormick 2015-11-18 16:54:20 Re: BDR and Backup and Recovery
Previous Message Jim Nasby 2015-11-18 16:19:51 Re: BDR and Backup and Recovery