On 12/01/2010 2:04 AM, Francisco Reyes wrote:
I need to replace a table with a new one. Example.. I create a script that continously does selects like select count(*) from tmp_deleteme_francisco; .... enough selects to last the duration of second script select count(*) from tmp_deleteme_francisco; Another script then does begin; select * into tmp_deleteme_francisco_2 from xxx; alter table tmp_deleteme_francisco rename to tmp_deleteme_francisco_old; alter table tmp_deleteme_francisco_2 rename to tmp_deleteme_francisco; drop table tmp_deleteme_francisco_old; commit; That results in the script doing the selects getting could not open relation with OID ####.
Possible workaround: Instead of your table creation, renaming and dropping, use TRUNCATE.
-- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
