Struct SearchPath 

pub struct SearchPath(/* private fields */);

A validated PostgreSQL search_path, applied at connection establishment.

Why this is a type and not a SET statement

SET search_path is session-scoped, and a connection pool is N independent sessions. Issuing the SET through a pooled query configures whichever single connection was checked out and leaves every other connection — including ones the pool opens later, and every replacement created after a backend disconnects — on the server default. Schema-per-tenant isolation built that way resolves most queries against public: silently wrong rows where public shadows the relation, an intermittent relation ... does not exist where it does not (#809).

Lowering the path into the startup options parameter instead makes it a property of how connections are made, so it cannot be missed by a connection and cannot be lost to recycling — RESET/DISCARD ALL restore the startup value, not the server default.

Example

use fraiseql_db::postgres::SearchPath;

let path = SearchPath::new(["tenant_acme", "public"])?;
assert_eq!(path.as_str(), "tenant_acme,public");

// Anything that is not a bare identifier is refused rather than escaped.
assert!(SearchPath::new(["public; DROP SCHEMA x"]).is_err());

Implementations

impl SearchPath

pub fn new<I, S>(schemas: I) -> Result<SearchPath, FraiseQLError>

where I: IntoIterator<Item = S>, S: AsRef<str>,

Build a search path from schema names, in resolution order.

Errors

Returns FraiseQLError::Validation if the list is empty or any entry is not a bare, unquoted PostgreSQL identifier ([A-Za-z_][A-Za-z0-9_]*, at most 63 characters). Rejecting rather than quoting keeps the emitted startup option free of characters that could terminate it.

pub fn as_str(&self) -> &str

The comma-separated path, as it is written into -c search_path=….

Trait Implementations

impl Clone for SearchPath

fn clone(&self) -> SearchPath

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for SearchPath

fn fmt(&self, f: &mut Formatter<'_>) -> Result<(), Error>

Formats the value using the given formatter.

impl Display for SearchPath

fn fmt(&self, f: &mut Formatter<'_>) -> Result<(), Error>

Formats the value using the given formatter.

impl Eq for SearchPath

impl PartialEq for SearchPath

fn eq(&self, other: &SearchPath) -> bool

Equality operator ==.

fn ne(&self, other: &Rhs) -> bool

Inequality operator !=.

impl StructuralPartialEq for SearchPath