pg_fetch_cycle PostgreSQL Extension

A PostgreSQL extension for managing fetch cycles with pg_net.

Documentation

• SUMMARY.md - Overview of what this extension does
• DIAGRAM.md - System architecture diagram
• PATTERN_RELOAD.md - Hot-reload development pattern using "noop" versions

Dependencies

• pg_net: PostgreSQL HTTP client extension
• citext: Case-insensitive text type extension

Installation

1. Install the extension files to your PostgreSQL extensions directory:

   # Development mode - create symbolic links for easy reloading
   ./install.sh
   

2. Install the pg_fetch_cycle extension (dependencies will be installed automatically):

   create extension pg_fetch_cycle version 'noop';
   select pg_fetch_cycle_reload();
   

Development

Reloading During Development

To reload the extension during development:

1. For reloading procedures and functions:

   select pg_fetch_cycle_reload();
   

2. For completely dropping and recreating the extension:

   select pg_fetch_cycle_recreate();