Samuel Gendler <sgendler@xxxxxxxxxxxxxxxx> writes: > Is there some way to do the drop+rename in a manner which will preserve the > OID or otherwise allow blocked queries to execute correctly once they > unblock? No, but you could consider begin; truncate original_table; insert into original_table select * from new_data; commit; > A secondary issue is that if permissions were granted to a role on the old > table, the new table does not acquire those permissions and they must be > granted again. Not to mention foreign keys ... regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
