pg_restore in java connection (auto_commit = false)

Поиск
Список
Период
Сортировка
От Emi Lu
Тема pg_restore in java connection (auto_commit = false)
Дата
Msg-id 48C83889.8090109@encs.concordia.ca
обсуждение исходный текст
Ответы Re: pg_restore in java connection (auto_commit = false)  (Craig Ringer <craig@postnewspapers.com.au>)
Список 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!




В списке pgsql-sql по дате отправления:

Предыдущее
От: "Ruben Gouveia"
Дата:
Сообщение: Re: Function Syntax involving pipes and ' marks?
Следующее
От: "Ruben Gouveia"
Дата:
Сообщение: Aggregates in WHERE clause?