SQLite (64-bit)

What's new in this version:

New features:
- Added Expression to CREATE INDEX
- Added cascade option while creating an extension
- Added ‘Ignore Grants’ option in the schema diff tool
- Added ‘Ignore Tablespace’ option in the schema diff tool
- Added support for ALTER INDEX column statistics
- Added unlogged option while creating a sequence
- Added all like options while creating a table
- Added support for SYSTEM, CONCURRENTLY and TABLESPACE options in REINDEX
- Added WAL option to EXPLAIN ANALYZE command
- Added new/missing options to the VACUUM command
- Added SKIP_LOCKED and BUFFER_USAGE_LIMIT option to Analyze command
- Add support for TRUNCATE trigger in foreign table
- Ensure that Schema Diff comparison results should be displayed in the sorted order

Housekeeping:
- Generate software bill of materials as part of the package builds
- Added support for PostgreSQL and EPAS 16 to ensure it works without any errors

Fixed:
- Fix incorrect redirection URL after authentication by removing fixed value set to SCRIPT_NAME environment variable in pgAdmin4.wsgi file
- Allow changing the POOL_SIZE and MAX_OVERFLOW config values of the pgAdmin config DB connection pool
- Fix an issue where query tool on shared server is throwing error if the pgAdmin config DB is external
- Fix the query tool issue where raise Notice from func/proc or code blocks are no longer displayed live
- Fix the issue where query tool window turns blank if the user tries to generate a graph on the result
- Fix an issue where changing MFA_SUPPORTED_METHODS breaks the MFA validation
- Fix an issue where pgAdmin 7.5 fails to render table SQL with extension loaded index method
- Fix an issue where cycle syntax was not added in SQL when creating new sequence from UI
- Fix an issue where the SET directive is excluded from the function header in the schema diff tool
- Fix a query tool error ‘pgAdminThread’ object has no attribute ‘native_id’
- Ensure keyboard shortcut for query execution is disabled when query execution is in progress