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
It seems that the above steps caused a lock for the tableX. Could
someone give me some ideas please?
Thanks a lot!
pgsql-sql by date
|Next:||From: Ruben Gouveia||Date: 2008-09-10 23:11:13|
|Subject: Aggregates in WHERE clause?|
|Previous:||From: Ruben Gouveia||Date: 2008-09-10 19:08:45|
|Subject: Re: Function Syntax involving pipes and ' marks?|