v1.4.0

Harlequin-Postgres CHANGELOG

All notable changes to this project will be documented in this file.

Unreleased

1.4.0 - 2026-08-29

• This adapter now supports Harlequin's --read-only option and declares IMPLEMENTS_READ_ONLY. Read-only connections are enforced by the server, using set session characteristics as transaction read only (#58).
• This adapter now implements search_catalog() and declares IMPLEMENTS_CATALOG_SEARCH, so hsql --catalog-search TERM finds databases, schemas, relations (including materialized views), and columns in one query, instead of walking the catalog a level at a time (#59).
• Catalog items now set type_name, the full type that their short type_label is shortened from: BASE TABLE, VIEW, MATERIALIZED VIEW, etc. for relations, and the column's type, as Postgres spells it, for columns.
• This adapter now requires harlequin>=2.11, the first version with CatalogSearchResult.

1.3.1 - 2026-04-19

• Fixes a bug causing user schemas starting with "pg" to be filtered out of the catalog. (#50)

1.3.0 - 2025-10-29

• Drops support for Python 3.9; adds support for Python 3.14.
• This project is now built using uv.

1.2.2 - 2025-09-12

• Adds materialized views to the Data Catalog. Note: Harlequin can only show Materialized Views in the catalog for the currently-connected database (#40 - thank you @PadenZach!).

1.2.1 - 2025-09-12

• Fixes a bug where Harlequin would crash if you execute a query against a closed/lost database connection (#42).

1.2.0 - 2025-02-27

• Adds interactions to list relations, indexes, constraints, and to describe relations (similar to psql's \d+) (tconbeer/harlequin#586 - thank you @JPFrancoia!).

1.1.1 - 2025-02-05

• This adapter now supports infinity and -infinity dates and timestamps by loading their values as date[time].max or date[time].min (tconbeer/harlequin#690).

1.1.0 - 2025-01-27

• This adapter now lazy-loads the catalog, which will dramatically improve the catalog performance for large databases with thousands of objects.
• This adapter now implements interactions for catalog items, like dropping tables, setting the search path, etc.

1.0.0 - 2025-01-07

• Drops support for Python 3.8
• Adds support for Python 3.13
• Adds support for Harlequin 2.X

0.4.0 - 2024-08-20

• Upgrades client library to psycopg3 (from psycopg2).
• Adds an implementation of connection_id to improve catalog and history persistence.
• Implements cancel() to interrupt in-flight queries.

0.3.0 - 2024-07-22

• Adds an implementation of close to gracefully close the connection pool on Harlequin shut-down.
• Adds support for Harlequin Transaction Modes and manual transactions.

0.2.2 - 2024-01-09

• Sorts databases, schemas, and relations alphabetically; sorts columns ordinally. (#10 - thank you @frankbreetz!)

0.2.1 - 2023-12-14

• Lowercases inserted values for keyword completions.

0.2.0 - 2023-12-14

Features

• Implements get_completions for keywords, functions, and settings.

0.1.3 - 2023-11-28

Bug fixes

• Implements connection pools instead of sharing a connection across threads.

0.1.2 - 2023-11-27

Bug fixes

• Fixes issues with package metadata.

0.1.1 - 2023-11-27

Bug fixes

• Fixes typo in release script.

0.1.0 - 2023-11-27

Features

• Adds a basic Postgres adapter with most common connection options.