ConfigureOTELTracer adds OTEL tracing to a pgx.ConnConfig.

ConfigurePGXLogger sets zerolog global logger into the connection pool configuration, and maps info level events to debug, as they are rather verbose for SpiceDB's info level.

ConnectWithInstrumentation returns a pgx.Conn that has been instrumented for observability.

ConnectWithInstrumentationAndTimeout returns a pgx.Conn that has been instrumented for observability.

ConvertToWriteConstraintError converts the given Postgres error into a CreateRelationshipExistsError if applicable.

IsCancellationError determines if an error returned by pgx has been caused by context cancellation.

IsConstraintFailureError returns true if the error is a Postgres error indicating a constraint failure.

IsQueryCanceledError returns true if the error is a Postgres error indicating a query was canceled.

IsReadOnlyTransactionError returns true if the error is a Postgres error indicating a read-only transaction.

NewPGXQueryRelationshipsExecutor creates an executor that uses the pgx library to make the specified queries.

ParseConfigWithInstrumentation returns a pgx.ConnConfig that has been instrumented for observability.

SleepOnErr sleeps for a short period of time after an error has occurred.

ComposedTracer allows adding multiple tracers to a pgx.ConnConfig.

PoolOptions is the set of configuration used for a pgx connection pool.

ConnPooler is an interface to pgx.Pool methods used by postgres-based datastores.

DBFuncQuerier is satisfied by RetryPool and QuerierFuncs (which can wrap a pgxpool or transaction).

Querier holds common methods for connections and pools, equivalent to Querier (which is deprecated for pgx v5).

QueryInterceptor exposes a mechanism to intercept all methods exposed in Querier This can be used as a sort of middleware layer for pgx queries.