> See:
> http://www.postgresql.org/docs/8.3/interactive/explicit-locking.html
>
> where it says that ALTER TABLE obtains the ACCESS EXCLUSIVE lock. You
> can confirm this by issuing the command of interest then running:
>
> SELECT * from pg_catalog.pg_locks;
>
> With that transaction still open,
Emi Lu wrote:
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 ta
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
