Am 23.02.2017 um 10:33 schrieb Francisco Olarte:
Thomas:
On Wed, Feb 22, 2017 at 1:51 PM, Thomas Güttler
<guettliml@xxxxxxxxxxxxxxxxxx> wrote:
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.
Depending on the structure / control / kind of ops you have on the
satellite you can try a two-table trick, similar to a common one used
to process files in spool directories.
> [cut]
This sound good. Is there a name for this trick, to find more details?
Regards,
Thomas
--
Thomas Guettler http://www.thomas-guettler.de/
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
