pg_restore in java connection (auto_commit = false) - Mailing list pgsql-sql

Good afternoon,

I have a question about pg_restore in JAVA and need your help.

I planed to do:
==================
1. pg_dump each tables (done successfully)
2. start a java connection   auto_commit = false

3.for(Table1... ... TableN)  {     drop primary key
     pg_restore table  (dead lock here)
     add primary key
     Connection.commit  }

It seems that the above steps caused a lock for the tableX. Could 
someone give me some ideas please?

Thanks a lot!