"Gnanakumar" <gnanam@xxxxxxxxxx> 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 (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
