citusdata / citusdata/pg_cron

Support using custom schema when creating extension

Open
#225 3 comments 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
3.9k
Forks
260
Avg merge
5d 5h
Merged PRs (30d)
1

Description

pg_cron always uses a schema named "cron" to house it's tables and functions. If you run `create extension pg_cron schema extension_pg_cron`, it still uses it's default cron schema, ignoring the specified desired schema. I think that pg_cron should work like other extensions, defaulting to the public schema and allowing users to override this default by specifying a schema on the create extension command.

Contributor guide

No contributing guide indexed for this repository

Research direction

Read the extension creation behavior and existing schema setup first; no file or test is named in the issue, so locate those entry points in the repository. Done means pg_cron uses public by default and honors a schema supplied to CREATE EXTENSION, with coverage for both cases.

Written by the indexing model from the issue text.

Assessment

Tech stack
c, postgresql
Domain
databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.