pgquarrel 0.7.0

Notable changes in this release include:

• sequence owner should have schema
• improve build system
  • fix Windows build
  • fix Debian/Ubuntu build
  • fix FreeBSD build
• fix TRANSFORM query
• fix prompt password
• fix some bugs spotted by Coverity

Thanks to all users that submitted patches and also to all users who reported bugs.

pgquarrel 0.6.0

Notable changes in this release include:

• ACCESS METHOD
• FOREIGN TABLE
• POLICY
• PUBLICATION
• SUBSCRIPTION
• PROCEDURE
• TRANSFORM
• Debian package
• quote role names
• escape strings in comments and security labels
• PostgreSQL 12 support
• improve tests
• various bug fixes

This release completes the list of PostgreSQL commands (excluding global commands such as DATABASE, ROLE, and TABLESPACE).

Thanks to all users that submitted patches and also to all users who reported bugs and feature requests.

pgquarrel 0.5.0

Notable changes in this release include:

• prompt for password
• option to avoid password prompt (useful for scripts)
• fix add/drop primary key
• fix add/drop foreign key
• fix single transaction option
• PostgreSQL 11 support
• improve building process (detect static libs in Debian/Ubuntu)
• update Travis CI (trusty -> xenial / pg 10 -> pg 11)

Observe the following incompatibilities:

• ask for password if it is required (--source-no-password and --target-no-password should be used to restore the old behavior).

pgquarrel 0.4.0

Notable changes in this release include:

• typed table support
• extended statistics support
• partitioning support
• selective object options
• compare only the most used objects
• command line options
• output to stdout by default
• single transaction option
• usage documentation
• improve Windows build

Observe the following incompatibilities:

• rename statistics option to summary

The configuration file is optional from now on. It is also possible to specify all options from the configuration file as command line options. The changes default to stdout.

pgquarrel 0.3.0

This new release implements some important features:

• version 10 support
• Windows support
• OPERATOR
• OPERATOR CLASS
• OPERATOR FAMILY
• TEXT SEARCH CONFIGURATION
• TEXT SEARCH DICTIONARY
• TEXT SEARCH PARSER
• TEXT SEARCH TEMPLATE

pgquarrel 0.2.0

This new release implements some important features:

• 9.6 support
• privileges (GRANT/REVOKE)
• column level privileges
• reloptions
• ALTER ... SET
• CAST
• CONVERSION
• COLLATION
• REPLICA IDENTITY
• SECURITY LABEL
• FDW commands
• AGGREGATE
• tests overhaul
• valgrind support on tests
• build and test pgquarrel (Travis CI)
• decrease memory footprint
• fix leaks (spotted by Coverity)