LOCK TABLE yourtable <a suitable LOCKMODE>; CREATE TEMPORARY TABLE keep AS SELECT * FROM yourtable WHERE <keep>; TRUNCATE yourtable; INSERT INTO yourtable SELECT * from keep; COMMIT; === the above snippet assumes truncate in PG can be in a transaction. In other words, while truncate by itself is atomic, it can't be rolled back. So in the above case, if "INSERT INTO yourtable SELECT * from keep;" and we rollback, will it rollback yourtable.
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
