Skip to content

Version 4.2
Compare
Choose a tag to compare
@darold darold released this 26 Jan 09:54
· 217 commits to master since this release
v4.2
951d011

January 26 2020 - v4.2

This is a maintenance release to fix issues reported by users since
the last three months. As usual there is also some improvements and
more formatting supported.

New option:

  * -U | --type-case N    : Change the case of the data type name. Default is
                            lowercase: 1. Values: 0=>unchanged, 1=>lowercase,
                            2=>uppercase, 3=>capitalize.

also avalaible in CGI mode as a select box option.

Here is the complete list of changes and acknowledgments:

  - Fix indentation if CASE clause when there is ; in statement.
    Thanks to Sergey Shepelev for the report.
  - Fix indentation of ORDER BY in OVER() clause. Thanks to Giorgi
    Modebadze for the report.
  - Keep CREATE STATISTICS statement on a single line.
  - Restore CREATE INDEX on a single line (no newline before using)
    to conform to pg_dump output.
  - Fix indentation when IF NOT EXISTS clause is present.
  - Add execution of regression tests through call to: make test.
    Thanks to Christoph Berg for the feature request.
  - Fix uninitialized variable error.
  - Fix identation of VALUES clause for INSERT statement in function
   code. Thanks to Sergey Shepelev for the report.
  - Fix indentation between comment and closed parenthesis before a
    column alias. Thanks to Laszlo Zsolt Nagy for the report.
  - Fix indentation of a FOR UPDATE clause in plpgsql function and
    after a LIMIT clause. Thanks to Sergey Shepelev.
  - Remove extra newline on inline comment. Thanks to prichardson211
    for the report.
  - Fix indentation of VALUES in some cases of INSERT statements
  - Fix wrong current statement assignment with comment keywword.
  - Fix invalid indentation of INSERT into function.
  - Dump array values in _dump_var() function.
  - Add RAISE to keywords.
  - Fix indentation in function with nested BEGIN/END blocks. Thanks
    to prichardson211 for the reports.
  - Fix other bad formatting in CREATE TYPE statements.
  - Indent AS followed by code delimiter in CREATE PROCEDURE statement
    just like with CREATE FUNCTION.
  - Fix indentation after a function/procedure with single quote as
    delimiter.
  - Prevent newline between open and close parenthesis in create
    function clause when there is no parameters.
  - Apply same behavior than previous commit for colon followed by the
    variable name in double quotes
  - Fix formatting of psql variable used in sql file. Thanks to Girish
    Pasupathy for the report.
  - Add detection of cast in token for keyword and function formatting
    Do not treat TRUE/FALSE as keyword when used a column aliases.
  - Fix formatting with casts type after case when using ::. Thanks to
    Giorgi Modebadze for the report.
  - Fix wrong detection as keyword or column name of tokens COMMENT,
    INDEX and CONSTRAINT.
  - Add debug information for SQL keyword detection.
  - Fix new line in FK constrains between ON and UPDATE.
  - Remove newline between UPDATE and the relation name, they appears
    now on the same line.
  - Fix formatting of ON CONFLICT DO clause. Thanks to prichardson211
    for the report.
  - Fix formatting of PREPARE ... AS UPDATE
  - Replace double quote in functions that has single quote as quote
    separator as we replace it by $$.
  - Fix wrong formatting with CREATE TABLE in EXPLAIN statement.
  - Add newline between AS and WITH keywords. Thanks to Andriy Diulin
    for the report.
  - Fix indent of RETURNS TABLE clause. Thanks to Ziyaddin Sadigov for
    the report.
  - Fix formatting of trigger with INSTEAD OF.
  - Fix indentation of SELECT inside INSERT statement. Thanks to
    Laszlo Zsolt Nagy for the report.
  - Fix case where formatting adds a newline before ASC or DESC.
    Thanks to Giorgi Modebadze for the report.
  - Fix formatting in CREATE TABLE statement with no indent after
    first foreign key.
  - Fix parsing of function with internal language that was breaking
    formatting of subsequent statements.
  - Fix formatting of CONSTRAINT TRIGGER.
  - Add more debug capabilities.
  - Fix wrap in compound FOREIGN KEY. Thanks to Victor Andree for the
    report.
  - Fix exception when the statement does not end with a semi colon.
    Thanks to Ralph R. for the report.
  - Allow testing installed binary in /usr/bin required for Debian
  - package testsuite. Thanks to Christoph Berg for the patch.
  - Reflect test result in exit code of regress_test.pl. Thanks to
    Christoph Berg for the patch.
Assets 2
Loading