Changes for version 0.900007 - 2026-11-17

  • Fixed
    • No bound or quoted value is in the text of a server error, whatever language the server reports in (lc_messages). The masking holds on the SQLSTATE and the quoting marks of the text, not on the English wording: a short value, the key or row of a DETAIL and the quoted value of a data exception are masked in German, French and any other language, on the sync storage and on the future_io transport. mask_error_details and mask_detail_values take the SQLSTATE as an optional second argument, and error_sqlstate reads it from a handle; with one argument they work as before.
    • The bytes of an invalid or untranslatable character sequence (SQLSTATE 22021, 22P05) are in no language in the text of a server error, the name of the encoding stays. The masking cuts no character through, whether the text arrives as characters or as UTF-8 bytes.
  • Documentation
    • The skills dbio-postgresql and dbio-postgresql-database state the not-diffed list as CHECK constraints, pg_settings, FORCE RLS and a changed policy under an unchanged name, and name no live-test variable the suite does not read.
  • Dependencies
    • Requires DBD::Pg 3.19.0, which hands a quoted DSN value to libpq as given, with a ';' or a quote inside it; the DSN model of the driver and the broker relies on that. It also provides pg_error_field, which the error fields are read through.
  • Tests
    • The test suite passes on an install with only the required modules: the tests of the future_io transport skip when DBIO::Async is not installed, the storage half of the search_path test skips when DBIO-PostgreSQL-Age is not installed.
    • The tests that send a Unix-domain socket directory through libpq (the connection-parameter DSN test and the live-server helper test) skip when the libpq behind DBD::Pg has no Unix-domain sockets, and the helper test reads the reason of a failed connect by its meaning there. Its child-process output is read with CRLF line endings folded, as a pipe delivers them on Windows.
    • The tests that compare libpq's own wording run in any locale: they set the message locale to C, since libpq translates its messages by the locale of the process. On a perl without POSIX::LC_MESSAGES (Windows) that helper goes on through the environment alone; the error-text tests read libpq's reason of a failed connect by its meaning where libpq has no Unix-domain sockets; and where perl cannot read the mode of a socket (Windows: no fcntl), the checks on the mode are skipped in the future_io tests and everything else runs.

Documentation

Modules

PostgreSQL-specific schema management for DBIO
PostgreSQL base->native type resolver
Generate PostgreSQL DDL from DBIO schema classes
Deploy and upgrade PostgreSQL schemas via test-deploy-and-compare
Compare two introspected PostgreSQL models
A name that differs from one in the database only in case is not a new object
Diff operations for PostgreSQL columns
A drop that meets objects outside the model is refused, naming them
Diff operations for PostgreSQL extensions
Diff operations for PostgreSQL foreign keys
Diff operations for PostgreSQL functions
Diff operations for PostgreSQL indexes
An operation the diff has no statement for is refused, not written as a comment or a placeholder
Diff operations for PostgreSQL Row Level Security policies
Diff operations for PostgreSQL schemas
Diff operations for PostgreSQL sequences
Diff operations for the column a PostgreSQL sequence belongs to
Diff operations for PostgreSQL tables
Diff operations for PostgreSQL triggers
Diff operations for PostgreSQL types (enums, composites, ranges)
Diff operations for PostgreSQL views and materialized views
The extension class of a PostgreSQL extension without rules, and the driver's table of the family's classes
Auto-inflate/deflate PostgreSQL tsvector columns to/from Perl data structures
Auto-inflate/deflate pgvector columns to/from Perl data structures
Introspect a PostgreSQL database via pg_catalog
Introspect PostgreSQL CHECK constraints
Introspect PostgreSQL table columns
Introspect PostgreSQL extensions
Introspect PostgreSQL foreign keys
Introspect PostgreSQL functions
Introspect PostgreSQL indexes
Pure normalization helpers for PostgreSQL introspected metadata
Introspect what stands on a table, a type or a schema of the model and is not in it
Introspect the views outside the schema filter that read columns inside it
Pure parsers for raw PostgreSQL metadata strings
Introspect PostgreSQL Row Level Security policies
Introspect PostgreSQL schemas (namespaces)
Introspect PostgreSQL sequences
Introspect PostgreSQL tables
Introspect PostgreSQL triggers
Introspect PostgreSQL types (enums, composites, ranges)
JSONB path expression helpers for DBIO::PostgreSQL queries
JSONB path-extraction operator object built by jsonb()
Base class for PostgreSQL schema namespaces
PostgreSQL-specific Result component for DBIO
ResultSet with pgvector nearest-neighbor search
PostgreSQL-specific SQL generation for DBIO
PostgreSQL storage layer for DBIO
future_io async PostgreSQL transport over DBD::Pg's pg_async binding
Answers the shared conformance case table for the PostgreSQL driver
Test result class for PostgreSQL timezone-aware datetime inflation
Test result class for PostgreSQL sequence tests
Shared PostgreSQL-specific helper functions for DBIO
pgvector distance-query helpers for DBIO::PostgreSQL
pgvector distance-operator object built by vector()
`use DBIO -pg` shortcut for the PostgreSQL driver