Reporting Errors Within the Server
  • References/Database/PostgreSQL/PostgreSQL Coding Conventions

Error, warning, and log messages generated within the server code should be created using ereport, or its older cousin elog

2025-01-10 15:47:30
test_decoding
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

test_decoding is an example of a logical decoding output plugin. It doesn't do anything especially useful, but can serve as a starting point for

2025-01-10 15:47:30
Catalogs: pg_class
  • References/Database/PostgreSQL/Internals: Catalogs

The catalog pg_class catalogs tables and most everything else that has columns or is otherwise similar to a table. This includes indexes (but

2025-01-10 15:47:30
ALTER FUNCTION
  • References/Database/PostgreSQL/Commands

NameALTER FUNCTION -- change the definition of a function Synopsis

2025-01-10 15:47:30
Catalogs: pg_indexes
  • References/Database/PostgreSQL/Internals: Catalogs

The view pg_indexes provides access to useful information about each index in the database.

2025-01-10 15:47:30
4.
  • References/Database/PostgreSQL/Tutorial/Advanced Features

Transactions are a fundamental concept of all database systems. The essential point of a transaction is that it bundles multiple steps into a single

2025-01-10 15:47:30
Internals//GiST Indexes
  • References/Database/PostgreSQL/Internals/GiST Indexes

GiST stands for Generalized Search Tree. It is a balanced, tree-structured access method, that acts as a base template in which to implement

2025-01-10 15:47:30
DROP FOREIGN DATA WRAPPER
  • References/Database/PostgreSQL/Commands

NameDROP FOREIGN DATA WRAPPER -- remove a foreign-data wrapper Synopsis

2025-01-10 15:47:30
vacuumdb
  • References/Database/PostgreSQL/Applications

Namevacuumdb -- garbage-collect and analyze a PostgreSQL database

2025-01-10 15:47:30
Catalogs: pg_constraint
  • References/Database/PostgreSQL/Internals: Catalogs

The catalog pg_constraint stores check, primary key, unique, foreign key, and exclusion constraints on tables. (Column constraints are not treated

2025-01-10 15:47:30