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!
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
