0.6.0

PgDD 0.6.0

• Adds support for Postgres 17! 🎉 #50, #52, #55, #57
• Replaces Ubuntu Lunar (23.04) installer with Unbutu Noble (24.04) installer
• ⚠️ Breaking Change ⚠️ Refactored SRFs into views (more below) #55

⚠️ Breaking Change ⚠️

The Set Returning Functions (SRFs) were converted into normal views in #55 which necessitated adding the _all suffix to preserve the main view functionality without name collisions. Example, this query worked prior to PgDD 0.6.0:

SELECT *
FROM dd.tables()
;

The equivalent query in PgDD 0.6.0 is:

SELECT *
FROM dd.tables_all
;

This change is not expected to impact most uses because the main views to use (e.g. dd.tables) filters out the system objects that are rarely required to query.

0.5.2

PgDD 0.5.2

The main reason to upgrade is to fix the broken partition queries. The other improvements were already live via current documentation and installers on 0.5.1.

• Fix partition queries #47/#48
• Add Ubuntu Lunar (23.04) installer (Docker) #43/#44. Thank you @pdgonzalez872 for testing!
• Improved Documentation #46
• Fix Postgres 16 build #49

---

Full Changelog: 0.5.1...0.5.2

0.5.1

PgDD 0.5.1

• Adds new view dd.index
• Adds support for Postgres 16
• Removes support for Postgres 11
• Bumps PostGIS versions to latest Docker image (16-3.4)

---

Full Changelog: 0.5.0...0.5.1

0.5.0

PgDD 0.5.0

This release has no functional changes from PgDD 0.4.1. This release keeps up with pgrx releases (formally pgx) and improves the build process via better documentation.

---

Full Changelog: 0.4.1...0.5.0

0.4.1

PgDD 0.4.1

Finally getting this release out.

• Now using pgx version 0.6.0 #30, #32, #33, #34
• Partitions #7
• Add database view #8
• Add size_bytes_plus_indexes calculation - #23
• Now building for Ubuntu Jammy (22.04)

0.4.0

PgDD Version 0.4.0

Highlights

• Now using pgx
• Supports Postgres 10 through Postgres 14

Now using Pgx!

This is the first version of PgDD using the pgx framework instead of the raw SQL method. This rewrite sets the stage for improved support across a variety of Postgres versions and functionality.

Blog post: PgDD extension moves to Pgx

Upgrade path

Upgrading from Raw SQL version of PgDD (v0.3) to the pgx version (v0.4.0) is done with DROP EXTENSION pgdd; CREATE EXTENSION pgdd;

If custom attributes were stored in the dd tables you will need to use pg_dump to export the data and reload after recreating the extension with pgx.

SELECT COUNT(*)
    FROM dd.meta_table
    WHERE s_name <> 'dd';
SELECT COUNT(*)
    FROM dd.meta_column
    WHERE s_name <> 'dd';
SELECT COUNT(*)
    FROM dd.meta_schema
    WHERE s_name <> 'dd';

⚠️ Other breaking changes

• PKs changed from SERIAL to BIGINT via IDENTITY - #21

0.4.0.rc4

PgDD Version 0.4.0 RC 4 notes

Highlights

• Now using pgx
• Supports Postgres 10 through Postgres 14

Now using Pgx!

This is the first version of PgDD using the pgx framework instead of the raw SQL method. This rewrite sets the stage for improved support across a variety of Postgres versions and functionality.

Blog post: PgDD extension moves to Pgx

Upgrade path

Upgrading from Raw SQL version of PgDD (v0.3) to the pgx version (v0.4.0) is done with DROP EXTENSION pgdd; CREATE EXTENSION pgdd;

If custom attributes were stored in the dd tables you will need to use pg_dump to export the data and reload after recreating the extension with pgx.

SELECT COUNT(*)
    FROM dd.meta_table
    WHERE s_name <> 'dd';
SELECT COUNT(*)
    FROM dd.meta_column
    WHERE s_name <> 'dd';
SELECT COUNT(*)
    FROM dd.meta_schema
    WHERE s_name <> 'dd';

⚠️ Other breaking changes

• PKs changed from SERIAL to BIGINT via IDENTITY - #21

0.4.0.rc3

PgDD Version 0.4.0 RC 3 notes

Now using Pgx!

This is the first version of PgDD using the pgx framework instead of the raw SQL method. This rewrite sets the stage for improved support across a variety of Postgres versions and functionality.

Upgrade path

Upgrading from Raw SQL version of PgDD (v0.3) to the pgx version (v0.4.0) is done with DROP EXTENSION pgdd; CREATE EXTENSION pgdd;

If custom attributes were stored in the dd tables you will need to use pg_dump to export the data and reload after recreating the extension with pgx.

SELECT COUNT(*)
    FROM dd.meta_table
    WHERE s_name <> 'dd';
SELECT COUNT(*)
    FROM dd.meta_column
    WHERE s_name <> 'dd';
SELECT COUNT(*)
    FROM dd.meta_schema
    WHERE s_name <> 'dd';

⚠️ Other breaking changes

• PKs changed from SERIAL to BIGINT via IDENTITY - #21

0.4.0.rc2

PgDD Version 0.4.0 RC 2 notes

Now using Pgx!

This is the first version of PgDD using the pgx framework instead of the raw SQL method. This rewrite sets the stage for improved support across a variety of Postgres versions and functionality.

Upgrade path

Upgrading from Raw SQL version of PgDD (v0.3) to the pgx version (v0.4.0) is done with DROP EXTENSION pgdd; CREATE EXTENSION pgdd;

If custom attributes were stored in the dd tables you will need to use pg_dump to export the data and reload after recreating the extension with pgx.

SELECT COUNT(*)
    FROM dd.meta_table
    WHERE s_name <> 'dd';
SELECT COUNT(*)
    FROM dd.meta_column
    WHERE s_name <> 'dd';
SELECT COUNT(*)
    FROM dd.meta_schema
    WHERE s_name <> 'dd';

0.4-rc1

PgDD Version 0.4 RC 1 Release notes

Now using Pgx!

This is the first version of PgDD using the pgx framework instead of the raw SQL method. This rewrite sets the stage for improved support across a variety of Postgres versions and functionality.

Update: Removed binaries. Packages were broken. :(