"Gnanakumar" <[email protected]> wrote: > Instead of touching/refactoring all the 35 functions just to > rename the table name, we decided to create the temporary table > name same as that of existing permanent table for running this > complex report alone If it were me I would be running some global search and replace on the scripts which create those functions. At a bare minimum you should be running these reports under a login without rights to drop permanent production tables. (We never let applications connect with a login which can do DDL except on temporary tables.) -Kevin
-- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
