[GENERAL] optimising the pl/pgsql function

[VENKTESH GUTTEDAR]

Hello,

We are running a pretty big plsql function, we are fetching data from
some tables based on certain conditions. And using that data in a for loop
within the function.
the problem we are facing is when the no of records are more the function
ction is taking too much time, is there a solution to this problem? Can we
replace the for loop with something else?

[GENERAL] - Regarding Schema ROLLBACK

[VENKTESH GUTTEDAR]

Hello All,


I have run CREATE SCHEMA xyz accidentally, and it replaced my existing
schema (xyz) with tables, and i have lost all my data.

Is there any way to rollback or get the schema back with old tables and
data.

Any help would be appreciated.

-- 
Regards :
Venktesh Guttedar.