> 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
quanzongliang@gmail.com
CIT Japan: http://www.cit.co.jp
CIT China: http://www.citbj.com.cn