CREATE TEMPORARY TABLE

• added support for virtual generated columns on Postgres 18
• grants to roles now support INHERIT and SET options on Postgres 16
• removed function ddlx_grants(regclass) as it now handled by ddlx_grants(oid)
• ddlx_grants(oid) fixes, now handles materialized views too.
• added data option to attempt to preserve table data
• added noindexes option to omit indexes
• added grantor option to show GRANTED BY which is now ommited by default
• added support for missing tsearch mappings in pg_ts_config_map
• removed unsupported ALTER EXTENSION SET OWNER
• indentation improvements in generated DDL

CREATE TYPE

• improvements in ddlx_create_subscription(), support for new options
• improvements in ddlx_script_parts(), better handling of extensions
• bug fixes in ddlx_create_type_range(), MULTIRANGE_TYPE_NAME support
• bug fixes in SET COMPRESSION
• bug fixes in GRANTED BY

SET COMPRESSION

• column compression support with ALTER COLUMN SET COMPRESSION
• use correct routine type in ddlx_grants()
• test updates for Postgres 17
• fixed bug with duplicate foreign key constraints for self referencing tables
• few more functions have comments

GRANTED BY

This release contains a lot of improvements and bugfixes and is recommended for all users.

Changes include:

• include GRANTED BY when grantor is distinct from current role
• include table partitions in a script, nopartitions option to omit
• new nocomments option to hide all comments
• new comments option to show all comments, even null ones
• more execute tests
• bug fixes in script order, now much better!
• bug fixes in GENERATED columns
• improved CREATE TYPE for base types, shell types support
• improved dropping of indexes which are really constraints
• improved support for publications (columns and qualifiers)
• improved handling of owned sequences
• compatibility improvements with old postgres versions

EXECUTE

• added new lite option, which moves defaults and constraints into create table section and removes some postgres specific things (such as settings and storage)
• nowrap option for scripts to omit begin/end
• nostorage option to omit storage settings
• nosettings option to omit settings
• notriggers option to omit triggers
• added 'CREATE SEQUENCE'+'ALTER SEQUENCE' for owned sequences
• new execute tests which actually runs generated scripts
• updated tests for postgres 16
• bug fixes

DEFAULTS

Release for postgres 16

New lite option to move defaults and constraints into create table section.

CREATEONLY

• added ddlx_createonly() function, to create only pre-data stuff
• few small fixes and improvements

CREATE OPERATOR CLASS

Objects from pg_amop and pg_amproc now handled by create_operator_class().

New option nodrop to omit drop statements alltogether.

Bug fixes with respect to partitions, where too many constraint/indexes were dumped.

CREATE SUBSCRIPTION

Extensions are now supported.

New options: nodcl, noowner, nogrants, noalter.

Bug fixes.

CREATE TABLE

New option ie will add IF EXISTS to a bunch of places.
New option ine will add IF NOT EXISTS to a bunch of places.
New option drop will add drop statements in the beginning of the script.

One can pass options as text array to ddlx_create and ddlx_script and other functions. Like:

mydb=# select ddlx_create('my_table'::regclass , '{ine}')

Now one can get individual parts of object definition. Try:

mydb=# select * from ddlx_definitions('my_table'::regclass)

Some internal factorization to make this more sensible.