Posts

Showing posts with the label Postgres Plus

Tip:: PPAS 9.4 and Global Temporary Table

Customers who moved/migrated their database from Oracle to PPAS frequently ask for Global Temporary Table in PPAS. Currently, PPAS doesn't support Global Temporary tables. However, there is a way user can achieve this functionality in PPAS. Before we continue with the implementation, lets first understand characteristics of Global Temporary Table. Following are the important characteristics of Global Temporary Table. 1. Global Temporary Table gives predefined structure for storing data. 2. It's an unlogged table which means any activity on this table will not be logged. 3. The data in a global temporary table are private, such that data inserted by a session can only be accessed by that session. Based on the above characteristics of Global Temporary Table AKA GTT, we can define similar kind of work by using the following method: 1. Create UNLOGGED TABLE in PPAS, which activity won't be logged. 2. Create Row Level Security in such a way that session should be