Pgddl Versions Save

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

• 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

Release for postgres 16

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

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

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.

Extensions are now supported.

New options: nodcl, noowner, nogrants, noalter.

Bug fixes.

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.

Tests on Postgres 14 no longer fail.

ddlx_apropos() function now uses POSIX regular expressions.

A bug in generated create event trigger was fixed. Objects from extensions are now excluded from script unless 'ext' option is specified.

Improved compatibility with PostgreSQL 13. All tests pass now.