Server Programming
II. Server Programming
This second part of the manual explains the PostgreSQL approach to extensibility and describe how users can extend PostgreSQL by adding user-defined types, operators, aggregates, and both query language and programming language functions. After a discussion of the PostgreSQL rule system, we discuss the trigger and SPI interfaces.
- Table of Contents
- 7. Architecture
- 8. Extending SQL: An Overview
- 9. Extending SQL: Functions
- 10. Extending SQL: Types
- 11. Extending SQL: Operators
- 11.1. Introduction
- 11.2. Example
- 11.3. Operator Optimization Information
- 12. Extending SQL: Aggregates
- 13. The Rule System
- 13.1. Introduction
- 13.2. What is a Query Tree?
- 13.3. Views and the Rule System
- 13.4. Rules on INSERT, UPDATE and DELETE
- 13.5. Rules and Permissions
- 13.6. Rules and Command Status
- 13.7. Rules versus Triggers
- 14. Interfacing Extensions To Indexes
- 15. Index Cost Estimation Functions
- 16. Triggers
- 16.1. Trigger Definition
- 16.2. Interaction with the Trigger Manager
- 16.3. Visibility of Data Changes
- 16.4. Examples
- 17. Server Programming Interface
- 17.1. Interface Functions
- 17.2. Interface Support Functions
- 17.3. Memory Management
- 17.4. Visibility of Data Changes
- 17.5. Examples