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!