Hi all I'm making some experiments with table archiving and I'd like to "replace" a full table F with an empty one E. In order to do this I see only one way: ALTER TABLE F RENAME TO T; ALTER TABLE E RENAME TO F; ALTER TABLE T RENAME TO E; -- optional This implies there's a moment when the full table doesn't exist. Would a transaction enclosure ensure that the table F will be always available to all clients? Thanks. -- Vincenzo Romano - NotOrAnd.IT Information Technologies -- NON QVIETIS MARIBVS NAVTA PERITVS -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
