Part VIII. Appendixes

Part VIII. Appendixes#

Part VIII. Appendixes

Part VIII. Appendixes
Prev	Up	Tantor SE 17.10 Documentation	Home	Next

Part VIII. Appendixes

Table of Contents

A. Tantor SE Error Codes

B. Date/Time Support

B.1. Date/Time Input Interpretation
B.2. Handling of Invalid or Ambiguous Timestamps
B.3. Date/Time Key Words
B.4. Date/Time Configuration Files
B.5. POSIX Time Zone Specifications
B.6. History of Units
B.7. Julian Dates

C. SQL Key Words

D. SQL Conformance

D.1. Supported Features
D.2. Unsupported Features
D.3. XML Limits and Conformance to SQL/XML

E. Release Notes

E.1. Release Notes for Tantor SE 17.10.0
E.2. Release Notes for Tantor SE 17.9.0
E.3. Release Notes for Tantor SE 17.7.0
E.4. Release Notes for Tantor SE 17.6.0
E.5. Release Notes for Tantor SE 17.5.2
E.6. Release Notes for Tantor SE 17.5.0
E.7. Release 17.10
E.8. Release 17.9
E.9. Release 17.8
E.10. Release 17.7
E.11. Release 17.6
E.12. Release 17.5
E.13. Release 17.4
E.14. Release 17.3
E.15. Release 17.2
E.16. Release 17.1
E.17. Release 17
E.18. Prior Releases

F. Additional Supplied Modules and Extensions

F.1. amcheck — tools to verify table and index consistency
F.2. auth_delay — pause on authentication failure
F.3. auto_dump — extension with ProcessInterrupts hook
F.4. auto_explain — log execution plans of slow queries
F.5. basebackup_to_shell — example "shell" pg_basebackup module
F.6. basic_archive — an example WAL archive module
F.7. bloom — bloom filter index access method
F.8. btree_gin — GIN operator classes with B-tree behavior
F.9. btree_gist — GiST operator classes with B-tree behavior
F.10. citext — a case-insensitive character string type
F.11. spi — Server Programming Interface features/examples
F.12. credcheck — Tantor SE username/password checks
F.13. cube — a multi-dimensional cube data type
F.14. dbcopies_decoding — database copy mechanism and data accelerator
F.15. dblink — connect to other PostgreSQL databases
F.16. dict_int — example full-text search dictionary for integers
F.17. dict_xsyn — example synonym full-text search dictionary
F.18. earthdistance — calculate great-circle distances
F.19. fasttrun — function to truncate temporary tables without growing pg_class size
F.20. file_fdw — access data files in the server's file system
F.21. fulleq — equivalence operator for compatibility with Microsoft SQL Server
F.22. fuzzystrmatch — determine string similarities and distance
F.23. hstore — hstore key/value datatype
F.24. hydra (columnar) — hydra optimized row columnar (ORC)
F.25. HypoPG — support for hypothetical indexes
F.26. intagg — integer aggregator and enumerator
F.27. intarray — manipulate arrays of integers
F.28. isn — data types for international standard numbers (ISBN, EAN, UPC, etc.)
F.29. lo — manage large objects
F.30. ltree — hierarchical tree-like data type
F.31. mchar — additional data types for compatibility with Microsoft SQL Server (MS SQL)
F.32. oauth_validator — OAuth 2.0 Basic Token Validator for Tantor SE
F.33. online_analyze — statistic collection right after INSERT/UPDATE/DELETE/SELECT
F.34. orafce — set of functions that provide compatibility with Oracle databases
F.35. pageinspect — low-level inspection of database pages
F.36. page_repair — individual page repair using standby’s data
F.37. passwordcheck — verify password strength
F.38. pg_archive — automatically archive historical data from partitioned tables
F.39. pgAudit — detailed session and/or object audit logging
F.40. pgauditlogtofile — pgAudit addon for redirect audit log lines to an independent file
F.41. pg_background — run commands in background workers
F.42. pg_buffercache — inspect Tantor SE buffer cache state
F.43. pg_cron — cron-based job scheduler working within the database
F.44. pgcrypto — cryptographic functions
F.45. pg_freespacemap — examine the free space map
F.46. pg_hint_plan — configuring plans of SQL queries in SQL comments
F.47. pg_ivm — Incremental View Maintenance (IVM) feature for Tantor SE
F.48. pgl_ddl_deploy — transparent logical DDL replication
F.49. pg_partman — create and manage time-based and number-based table partition sets
F.50. pg_prewarm — preload relation data into buffer caches
F.51. PGQ — generic, high-performance lockless queue with simple API based on SQL functions
F.52. pg_qualstats — statistics on predicates found in WHERE statements and JOIN clauses
F.53. pg_query_id — manipulate aspects of query id computation
F.54. pg_repack — remove bloat from tables and indexes
F.55. pgrowlocks — show a table's row locking information
F.56. pgsql-http — Tantor SE HTTP Client
F.57. pg_stat_advisor — Tantor SE advisor to create extended statistics
F.58. pg_stat_kcache — statistics about real reads and writes
F.59. pg_stat_statements — track statistics of SQL planning and execution
F.60. pgstattuple — obtain tuple-level statistics
F.61. pg_store_plans — means for tracking execution plan statistics of all SQL statements
F.62. pg_surgery — perform low-level surgery on relation data
F.63. pg_tde — Transparent Data Encryption for Tantor SE
F.64. pg_throttle — extension which add query throttling feature
F.65. pg_trace — Real-time filtered query tracing for Tantor SE
F.66. pg_trgm — support for similarity of text using trigram matching
F.67. pg_uuidv7 — extension to generate UUID version 7 and some other functions
F.68. pg_variables — work with variables of different types
F.69. pg_visibility — visibility map information and utilities
F.70. pg_wait_profile — sample-based profiling of database activity
F.71. pg_wait_sampling — sampling based statistics of wait events
F.72. pg_walinspect — low-level WAL inspection
F.73. plantuner — planner hints
F.74. postgres_fdw — access data stored in external Tantor SE servers
F.75. seg — a datatype for line segments or floating point intervals
F.76. sepgsql — SELinux-, label-based mandatory access control (MAC) security module
F.77. sslinfo — obtain client SSL information
F.78. tablefunc — functions that return tables (crosstab and others)
F.79. tcn — a trigger function to notify listeners of changes to table content
F.80. test_decoding — SQL-based test/example module for WAL logical decoding
F.81. transp_anon — mask or replace personally identifiable information or commercially sensitive data
F.82. tsm_system_rows — the SYSTEM_ROWS sampling method for TABLESAMPLE
F.83. tsm_system_time — the SYSTEM_TIME sampling method for TABLESAMPLE
F.84. unaccent — a text search dictionary which removes diacritics
F.85. uuid-ossp — a UUID generator
F.86. vector (pgvector) — search vector similarity
F.87. xml2 — XPath querying and XSLT functionality

G. Additional Supplied Programs

G.1. Client Applications
G.2. Server Applications

H. Additional Supplied Utilities

H.1. columnar_migrator
H.2. data_generator
H.3. pg_diag_setup
H.4. pg_sec_check
H.5. pgcompacttable
H.6. pgcopydb
H.7. slru_upgrader

I. Tantor Additional Programs Distributed as Separate Packages

I.1. Tantor Platform
I.2. PipelineDB
I.3. pg_anon
I.4. pg_cluster
I.5. pg_configurator

J. Additional External Modules Distributed as Separate Packages

J.1. ldap2pg
J.2. mysql_fdw
J.3. oracle_fdw
J.4. pg_timetable
J.5. pgbouncer
J.6. tds_fdw
J.7. wal-g

K. External Projects

K.1. Client Interfaces
K.2. Administration Tools
K.3. Procedural Languages
K.4. Extensions

L. Tantor SE Limits

M. Acronyms

N. Glossary

O. Color Support

O.1. When Color is Used
O.2. Configuring the Colors

P. Obsolete or Renamed Features

P.1. recovery.conf file merged into postgresql.conf
P.2. Default Roles Renamed to Predefined Roles
P.3. pg_xlogdump renamed to pg_waldump
P.4. pg_resetxlog renamed to pg_resetwal
P.5. pg_receivexlog renamed to pg_receivewal

Prev	Up	Next
69.3. Backup Manifest WAL Range Object	Home	Appendix A. Tantor SE Error Codes