>>I have other concerns: atomar transaction. Movement should happen completely or not all.
>>I don't think you can do this reliable (atomic transaction) with "copy table_name".
>
> You can if you wrap it in a transaction:
I want to **move** the data. The data should get deleted on the satellite after transfer.
I don't know how to delete the data which was copied, since inserts can happen during the copy statement.
Regards,
Thomas Güttler
--
Thomas Guettler http://www.thomas-guettler.de/
