> The second way is to use SAVEPOINT. > You can use savepoints: > http://www.postgresql.org/docs/8.3/interactive/sql-savepoint.html
This a good idea. I forgot it. > I think you should take a look at pgloader: > http://pgfoundry.org/projects/pgloader/ Ok, before the work go on, I study from them. And more one question: I think the import work should get a new PGconn instance before it starts. in document: http://www.postgresql.org/docs/8.3/static/libpq-copy.html said: It is not possible to execute other SQL commands using the same connection while the COPY operation is in progress. How about the INSERT command? When them start work within a new transaction. It seems to fall into same situation. ----------------------------------------------- Quan Zongliang quanzongli...@gmail.com CIT Japan: http://www.cit.co.jp CIT China: http://www.citbj.com.cn -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
