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