PostgreSQL Source Code

Hacking PostgreSQL

Final Code

PostgreSQL Subsystems

Hacking the PostgreSQL Way

Memory Management

Error Handling / Logging

Catalog Lookups

Nodes

Datums and Tuples

Other Subsystems

SysCache and Scanning Catalogs

General function ’SearchSysCache’

Defined in utils/cache/syscache.c

Search a system catalog based on some key

Up to four keys can be used

Helper routines for fewer keys available (SearchSysCache1, etc)

Must call ReleaseSysCache() when done with a tuple

Also some convenience routines in lsyscache.c

Look for existing routines before implementing a new one