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