Skip site navigation (1) Skip section navigation (2)

pg_restore in java connection (auto_commit = false)

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: pg_restore in java connection (auto_commit = false)
Date: 2008-09-10 21:13:45
Message-ID: 48C83889.8090109@encs.concordia.ca (view raw or flat)
Thread:
Lists: 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!



Responses

pgsql-sql by date

Next:From: Ruben GouveiaDate: 2008-09-10 23:11:13
Subject: Aggregates in WHERE clause?
Previous:From: Ruben GouveiaDate: 2008-09-10 19:08:45
Subject: Re: Function Syntax involving pipes and ' marks?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group