drop index without accessexclusivelock in transaction (JAVA) - Mailing list pgsql-general

From Emi
Subject drop index without accessexclusivelock in transaction (JAVA)
Date
Msg-id 564CABEB.4070207@encs.concordia.ca
Whole thread Raw
Responses Re: drop index without accessexclusivelock in transaction (JAVA)  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List 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





pgsql-general by date:

Previous
From: Jim Nasby
Date:
Subject: Re: BDR and Backup and Recovery
Next
From: Will McCormick
Date:
Subject: Re: BDR and Backup and Recovery