[GENERAL] optimising the pl/pgsql function

2018-09-18 Thread 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 solut

[GENERAL] - Regarding Schema ROLLBACK

2017-11-28 Thread 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.