PostgreSQL - Revision history

Wikiadmin: /* Enabled Trigger secara massal */

2024-05-26T18:18:34Z

‎Enabled Trigger secara massal

2024-05-26T18:18:19Z

‎How to

2024-01-24T12:25:26Z

‎Validation

2024-01-24T12:23:56Z

2024-01-24T12:22:18Z

‎Check Trigger Status

2024-01-24T12:21:30Z

‎Check Trigger Status

2024-01-24T12:21:12Z

‎Check Trigger Status

2023-10-26T06:55:23Z

‎Terminate Idle Transactions for Postgres version 12 and previous

2023-10-26T06:55:04Z

‎Terminate Idle Transactions for Postgres version 12 and previous

2023-10-26T06:52:51Z

‎Terminate Idle Transactions for Postgres version 12 and previous

@@ Line 327: / Line 327: @@
 = How to =
 == Enabled Trigger secara massal ==
-'''Background''':
+'''Background''': <br>
 Dalam kasus tertentu selama compile terkadang terdapat problem sehingga menyebabkan ada beberapa Trigger yang tidak di Enable kembali:
 Berikut adalah PostgreSQL command untuk ENABLE semua trigger yang statusnya masih DISABLE:
@@ Line 347: / Line 348: @@
 END $$;
 </pre>
 == Terminate Idle Transactions for Postgres version 12 and previous ==

← Older revision		Revision as of 18:18, 26 May 2024
Line 326:		Line 326:

	= How to =		= How to =
		+	== Enabled Trigger secara massal ==
		+	'''Background''':
		+	Dalam kasus tertentu selama compile terkadang terdapat problem sehingga menyebabkan ada beberapa Trigger yang tidak di Enable kembali:
		+	Berikut adalah PostgreSQL command untuk ENABLE semua trigger yang statusnya masih DISABLE:
		+
		+	<pre>
		+	DO $$
		+	DECLARE
		+	r RECORD;
		+	BEGIN
		+	FOR r IN
		+	select
		+	table_name as tablename,
		+	trigger_name as trigger_name
		+	from user_triggers
		+	where status!='ENABLED'
		+	LOOP
		+	EXECUTE 'ALTER TABLE ' \|\| r.tablename \|\| ' ENABLE TRIGGER ' \|\| r.trigger_name;
		+	END LOOP;
		+	END $$;
		+	</pre>
	== Terminate Idle Transactions for Postgres version 12 and previous ==		== Terminate Idle Transactions for Postgres version 12 and previous ==

← Older revision		Revision as of 12:25, 24 January 2024
Line 4:		Line 4:

	== Validation ==		== Validation ==
		+
		+	=== Check: Columns with search reference and reference value null ===
		+	Setiap Column yang ada dalam daftar hasil query harus diperbaiki sesuai standard Openbravo Development
		+	<pre>
		+
		+	SELECT AD_COLUMN_ID AS referencekey_id, TABLENAME \|\| ' - ' \|\| COLUMNNAME AS RECORD_ID, 0 AS AD_ROLE_ID, NULL AS AD_USER_ID,
		+	'The column ' \|\| COLUMNNAME \|\| ' in table ' \|\| TABLENAME \|\| ' is referenced as search and doesn''t have an associated reference value while having active updateable fields.' AS DESCRIPTION,
		+	'Y' AS ISACTIVE, 0 AS AD_ORG_ID, 0 AS AD_CLIENT_ID, now() AS CREATED, 0 AS CREATEDBY, now() AS UPDATED, 0 AS UPDATEDBY
		+	FROM AD_COLUMN, AD_TABLE
		+	WHERE AD_REFERENCE_ID = '30'
		+	AND AD_COLUMN.AD_TABLE_ID = AD_TABLE.AD_TABLE_ID
		+	AND AD_REFERENCE_VALUE_ID IS NULL
		+	AND AD_TABLE.ISACTIVE = 'Y'
		+	AND AD_COLUMN.ISACTIVE = 'Y'
		+	AND AD_COLUMN.ISPARENT = 'N'
		+	--AND AD_COLUMN.ISUPDATEABLE = 'Y'
		+	AND EXISTS (SELECT 1
		+	FROM AD_FIELD, aD_TAB, AD_WINDOW
		+	WHERE AD_FIELD.AD_COLUMN_ID = AD_COLUMN.AD_COLUMN_ID
		+	AND AD_FIELD.AD_TAB_ID = AD_TAB.AD_TAB_ID
		+	AND AD_WINDOW.AD_WINDOW_ID = AD_TAB.AD_WINDOW_ID
		+	AND AD_FIELD.ISREADONLY = 'N'
		+	AND AD_TAB.ISREADONLY = 'N'
		+	AND AD_TAB.ISACTIVE = 'Y'
		+	AND AD_FIELD.ISACTIVE = 'Y'
		+	AND AD_WINDOW.ISACTIVE = 'Y'
		+	AND ISDISPLAYED = 'Y')
		+
		+	</pre>

	= Database Maintenance and Monitoring script =		= Database Maintenance and Monitoring script =

← Older revision		Revision as of 12:23, 24 January 2024
Line 1:		Line 1:
	= Introduction =		= Introduction =
		+
		+	= Database Development =
		+
		+	== Validation ==

	= Database Maintenance and Monitoring script =		= Database Maintenance and Monitoring script =

@@ Line 235: / Line 235: @@
 </pre>
-=== More advance: ===
+=== More advance ===
 <pre>

@@ Line 233: / Line 233: @@
 -- Disable trigger
 -- ALTER TABLE m_product DISABLE TRIGGER m_product_trg;
 </pre>

← Older revision		Revision as of 06:55, 26 October 2023
Line 269:		Line 269:

	'''Background''':		'''Background''':
		+	<br>
	since configuration '''idle_in_transaction_session_timeout''' on available at version 13 and above, here is the workaround solutions		since configuration '''idle_in_transaction_session_timeout''' on available at version 13 and above, here is the workaround solutions

@@ Line 284: / Line 284: @@
 To use this function, you can call it with your desired idle timeout value. For example, to terminate sessions idle for more than 5 minutes, you can call the function like this:
 <pre>
-SELECT terminate_idle_sessions(5); -- Terminate idle sessions idle for more than 5 minutes
+SELECT oez_terminate_idle_sessions(5); -- Terminate idle sessions idle for more than 5 minutes
 </pre>