Gecko [ tanishkshah.com ]

Name	Size	Permission	Date
README.PSQL_stack_trace.txt	1.96 KB	-rw-r--r--	2026-04-17 16:36
README.aggregate_filter.md	941 B	-rw-r--r--	2026-04-17 16:36
README.aggregate_tracking	3.88 KB	-rw-r--r--	2026-04-17 16:36
README.alternate_string_quoting.txt	846 B	-rw-r--r--	2026-04-17 16:36
README.autonomous_transactions.txt	1.31 KB	-rw-r--r--	2026-04-17 16:36
README.blob_append.md	4.99 KB	-rw-r--r--	2026-04-17 16:36
README.builtin_functions.txt	29.49 KB	-rw-r--r--	2026-04-17 16:36
README.case	1.71 KB	-rw-r--r--	2026-04-17 16:36
README.coalesce	1.04 KB	-rw-r--r--	2026-04-17 16:36
README.column_type_psql.txt	871 B	-rw-r--r--	2026-04-17 16:36
README.common_table_expressions	4.78 KB	-rw-r--r--	2026-04-17 16:36
README.context_variables	4.66 KB	-rw-r--r--	2026-04-17 16:36
README.context_variables2	8.47 KB	-rw-r--r--	2026-04-17 16:36
README.cumulative_roles.txt	2.27 KB	-rw-r--r--	2026-04-17 16:36
README.current_time	814 B	-rw-r--r--	2026-04-17 16:36
README.cursor_variables.txt	2.75 KB	-rw-r--r--	2026-04-17 16:36
README.cursors	2.43 KB	-rw-r--r--	2026-04-17 16:36
README.data_type_results_of_aggregations.txt	1.56 KB	-rw-r--r--	2026-04-17 16:36
README.data_types	8.31 KB	-rw-r--r--	2026-04-17 16:36
README.db_triggers.txt	1.8 KB	-rw-r--r--	2026-04-17 16:36
README.ddl.txt	22.52 KB	-rw-r--r--	2026-04-17 16:36
README.ddl_access.txt	1.53 KB	-rw-r--r--	2026-04-17 16:36
README.ddl_triggers.txt	11.67 KB	-rw-r--r--	2026-04-17 16:36
README.default_parameters	1.91 KB	-rw-r--r--	2026-04-17 16:36
README.derived_tables.txt	2.69 KB	-rw-r--r--	2026-04-17 16:36
README.distinct	813 B	-rw-r--r--	2026-04-17 16:36
README.domains_psql.txt	933 B	-rw-r--r--	2026-04-17 16:36
README.exception_handling	2.44 KB	-rw-r--r--	2026-04-17 16:36
README.execute_block	1.45 KB	-rw-r--r--	2026-04-17 16:36
README.execute_statement	4.24 KB	-rw-r--r--	2026-04-17 16:36
README.execute_statement2	9.54 KB	-rw-r--r--	2026-04-17 16:36
README.explicit_locks	5.91 KB	-rw-r--r--	2026-04-17 16:36
README.expression_indices	1.3 KB	-rw-r--r--	2026-04-17 16:36
README.external_connections_pool	4.31 KB	-rw-r--r--	2026-04-17 16:36
README.floating_point_types.md	2.33 KB	-rw-r--r--	2026-04-17 16:36
README.global_temporary_tables	3.43 KB	-rw-r--r--	2026-04-17 16:36
README.hex_literals.txt	1.13 KB	-rw-r--r--	2026-04-17 16:36
README.identity_columns.txt	3.24 KB	-rw-r--r--	2026-04-17 16:36
README.iif	541 B	-rw-r--r--	2026-04-17 16:36
README.isc_info_xxx	3.61 KB	-rw-r--r--	2026-04-17 16:36
README.joins.txt	1.23 KB	-rw-r--r--	2026-04-17 16:36
README.keywords	5.26 KB	-rw-r--r--	2026-04-17 16:36
README.leave_labels	1.68 KB	-rw-r--r--	2026-04-17 16:36
README.length	486 B	-rw-r--r--	2026-04-17 16:36
README.linger	1.34 KB	-rw-r--r--	2026-04-17 16:36
README.list	1.04 KB	-rw-r--r--	2026-04-17 16:36
README.management_statements_psql.md	925 B	-rw-r--r--	2026-04-17 16:36
README.mapping.html	14.91 KB	-rw-r--r--	2026-04-17 16:36
README.merge.txt	1.77 KB	-rw-r--r--	2026-04-17 16:36
README.null_value	23 B	-rw-r--r--	2026-04-17 16:36
README.nullif	611 B	-rw-r--r--	2026-04-17 16:36
README.offset_fetch.txt	1.69 KB	-rw-r--r--	2026-04-17 16:36
README.order_by_expressions_nulls	1.67 KB	-rw-r--r--	2026-04-17 16:36
README.packages.txt	5.12 KB	-rw-r--r--	2026-04-17 16:36
README.plan	3.49 KB	-rw-r--r--	2026-04-17 16:36
README.regr_functions.txt	1.14 KB	-rw-r--r--	2026-04-17 16:36
README.returning	2.91 KB	-rw-r--r--	2026-04-17 16:36
README.rows	1.34 KB	-rw-r--r--	2026-04-17 16:36
README.savepoints	4.08 KB	-rw-r--r--	2026-04-17 16:36
README.scrollable_cursors.txt	3.06 KB	-rw-r--r--	2026-04-17 16:36
README.select_expressions	2.18 KB	-rw-r--r--	2026-04-17 16:36
README.sequence_generators	1.68 KB	-rw-r--r--	2026-04-17 16:36
README.set_bind.md	4.49 KB	-rw-r--r--	2026-04-17 16:36
README.set_role	768 B	-rw-r--r--	2026-04-17 16:36
README.set_transaction.txt	1.63 KB	-rw-r--r--	2026-04-17 16:36
README.similar_to.txt	9.53 KB	-rw-r--r--	2026-04-17 16:36
README.sql_security.txt	5.51 KB	-rw-r--r--	2026-04-17 16:36
README.statistical_functions.txt	1.6 KB	-rw-r--r--	2026-04-17 16:36
README.subroutines.txt	4.23 KB	-rw-r--r--	2026-04-17 16:36
README.substring_similar.txt	1.2 KB	-rw-r--r--	2026-04-17 16:36
README.time_zone.md	14.34 KB	-rw-r--r--	2026-04-17 16:36
README.trim	997 B	-rw-r--r--	2026-04-17 16:36
README.universal_triggers	2.77 KB	-rw-r--r--	2026-04-17 16:36
README.update_or_insert	1.38 KB	-rw-r--r--	2026-04-17 16:36
README.user_management	4.43 KB	-rw-r--r--	2026-04-17 16:36
README.view_updates	23 B	-rw-r--r--	2026-04-17 16:36
README.window_functions.md	14.92 KB	-rw-r--r--	2026-04-17 16:36

Rename

PSQL stack trace

Function: 
	Send to client within status-vector simple stack trace with names of stored procedures
	and/or triggers. Status-vector appends with following items :

isc_stack_trace, isc_arg_string, <string length>, <string>

isc_stack_trace is a new error code with value of 335544842L

Stack trace is represented by one string and consists from all the sp/trigger names 
	starting from point where exception occurred up to most outer caller. Maximum length of 
	that string is 2048 bytes. If actual trace is longer then it will be truncated to this limit.

Author:
	Vlad Khorsun <hvlad at users.sourceforge.net>

Examples:

0. Create metadata:

CREATE TABLE ERR (ID INT NOT NULL PRIMARY KEY, NAME VARCHAR(16));

CREATE EXCEPTION EX '!';

CREATE OR ALTER PROCEDURE ERR_1 AS
BEGIN
  EXCEPTION EX 'ID = 3';
END;

CREATE OR ALTER TRIGGER ERR_BI FOR ERR BEFORE INSERT AS
BEGIN
  IF (NEW.ID = 2)
  THEN EXCEPTION EX 'ID = 2';

IF (NEW.ID = 3)
  THEN EXECUTE PROCEDURE ERR_1;

IF (NEW.ID = 4)
  THEN NEW.ID = 1 / 0;
END;

CREATE OR ALTER PROCEDURE ERR_2 AS
BEGIN
  INSERT INTO ERR VALUES (3, '333');
END;

1. User exception from trigger:

SQL> INSERT INTO ERR VALUES (2, '2');
Statement failed, SQLCODE = -836
exception 3
-ID = 2
-At trigger 'ERR_BI'

2. User exception from procedure called by trigger:

SQL> INSERT INTO ERR VALUES (3, '3');
Statement failed, SQLCODE = -836
exception 3
-ID = 3
-At procedure 'ERR_1'
At trigger 'ERR_BI'

3. Division by zero occurred in trigger:

SQL> INSERT INTO ERR VALUES (4, '4');
Statement failed, SQLCODE = -802
arithmetic exception, numeric overflow, or string truncation
-At trigger 'ERR_BI'

4. User exception from procedure:

SQL> EXECUTE PROCEDURE ERR_1;
Statement failed, SQLCODE = -836
exception 3
-ID = 3
-At procedure 'ERR_1'

5. User exception from procedure with more deep call stack:

SQL> EXECUTE PROCEDURE ERR_2;
Statement failed, SQLCODE = -836
exception 3
-ID = 3
-At procedure 'ERR_1'
At trigger 'ERR_BI'
At procedure 'ERR_2'