supabase/supavisor

Connection Pooler string does not honor options parameter with search_path

Open

#206 opened on Nov 24, 2023

View on GitHub
 (4 comments) (10 reactions) (0 assignees)Elixir (106 forks)batch import
buggood first issue

Repository metrics

Stars
 (2,191 stars)
PR merge metrics
 (Avg merge 4d 9h) (31 merged PRs in 30d)

Description

Bug report

  • [ x] I confirm this is a bug with Supabase, not with my own application.
  • [ x] I confirm I have searched the Docs, GitHub Discussions, and Discord.

Describe the bug

Postgres connection strings support an options query parameter where one can add a specific search_path to be used for the connection:

POSTGRES_CONNECTION_STRING?options=-c%20search_path=custom_schema

This works if I use the direct Postgres connection string shown on the Supabase dashboard but does not work with the connection pooler string (Supavisor). Is this by design? I ran multiple tests and the search path in my connection only updates when I use the direct connection string.

Expected behavior

The search path to be set as specified in the additional parameters passed to the connection pooler string.

Additional context

I am using the connection pooler in Transaction mode.

Contributor guide

Research direction
Investigate how Supavisor parses the 'options' parameter in the connection string. Check if the parameter is being forwarded to the actual PostgreSQL backend connection. Look for any filtering or overriding of parameters in the pooler's configuration or code.
Tech stack
elixirpostgresql
Domain
backendinfrastructuredatabase
Issue type
Bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
Half day
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
PostgreSQL connection stringsElixir basics
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
65