changelog.rst

2.1.2 (2024-05-15)

Bug fixes:

• Fix d when used with a pattern

2.1.1 (2023-10-29)

• Added build-system section to pyproject.toml to use the modern setuptools backend.
• Fix SyntaxWarning with Python 3.12.
• Fix test_slash_l* to support non-en_US locales (#140).
• Release script uses build module.

2.1.0 (2023-03-31)

• Fixed displaying verbose view definitions when running d+.
• Use psycopg.sql for constructing queries.

2.0.1 (2022-06-17):

Internal:

• Added argument to open_external_editor to specifiy desired editor.

2.0.0 (2022-06-03):

Bug fixes:

• Add pytest mark dbtest to test_slash_dp_pattern_schema so it can be skipped when necessary. (Thanks: Benjamin Beasley)

Internal:

• Switch to psycopg3 - breaking change.

1.13.1

Bug fixes:

• Throw an exception if the TO/FROM keyword is missing in the copy command. (Thanks: `Amjith`_)
• Allow multiline SQL and use default of 2s timing for the watch command. (Thanks: `Saif Hakim`_)
• Fix for the dp metacommand to properly work with the schema name as pattern (Thanks: Roberto Dedoro)

Internal:

• Drop unused dev/test dependency on mock (Thanks: Benjamin Beasley).

1.13.0

Features:

• Add support for the ddp metacommand that lists the default privileges of Postgres objects (Thanks: Roberto Dedoro)
• Add support for named query positional parameters aggregation (Thanks: Guilhem Charles)

1.12.1

• Fix for broken MANIFEST.in that prevented source installation (#101. Thanks: Dave Hirschfeld).

Bug fixes:

• Fix deprecation warnings with stricter backslash escaping in strings. (Thanks: Benjamin Beasley)

1.12.0

Features:

• Add support for the dp metacommand that lists the privileges of Postgres objects (Thanks: `Guru Devanla`_)
• Add support for the np <named_query_pattern> metacommand that returns named queries matching the pattern (Thanks: `Guru Devanla`_)

Internal:

• Use Black to format the code and run CI style checks.

1.11.10

Bug fixes:

• Allows d foo to display information about IDENTITY columns. (Thanks: `Denis Gantsev`_)

1.11.9

Bug fixes:

• Fix for d foo command crash in PostgreSQL 12. (Thanks: Irina Truong)

1.11.8

Bug fixes:

• \d some_schema.some_table will now work when some_schema is not in your search_path.

1.11.7

Internal:

• Allow usage of newer versions of psycopg2. (Thanks: Aluísio Augusto Silva Gonçalves).

1.11.6

Bug fixes:

• Scope the results of d foo command to the current schema. (Thanks: Amjith Ramanujam)

Internal:

• Add missing psycopg2 dependency. (Thanks: Dick Marinus).
• Fix issues when using the \dx+ command. (Thanks: Ignacio Campabadal).

1.11.5

Features:

• Add support for the \! command. (Thanks: Ignacio Campabadal).
• Add support for describing text search configurations dF`. (Thanks: Ignacio Campabadal).
• Add support for the \dE command. (Thanks: Catherine Devlin).

1.11.4

Bug fixes:

• Fixed broken completion for special commands with prompt-toolkit 2.0. (Thanks: Amjith Ramanujam)

1.11.3

Bug fixes:

• Fixed the IndexError caused by \ef without a function name. (Thanks: Amjith Ramanujam)

1.11.2

Bug fixes:

• Support for PG 10 partitioning and fix for OmniDB/OmniDB#424. (Thanks: William Ivanski).

1.11.1

Bug fixes:

• Remove pycache files from release (Thanks: Dick Marinus).
• Fix \df under PG11. (Thanks: Lele Gaifax).

1.11.0

Features:

• Add support for \ev, \ef commands. (Thanks: Catherine Devlin).

Bug fixes:

• Avoid the need to escape "%" in named queries (dbcli/pgcli#865). (Thanks: Jason Ribeiro).

1.10.0

Features:

• Add support for \dD command. (Thanks: Lele Gaifax).
• Add support parameter $1...$n in query (Thanks: Frederic Aoustin).

Bug fixes:

• Fix listing of table inheritance in \d command. (Thanks: Lele Gaifax).

1.9.0

Features:

• Change \l command behavior, and add \list alias. (Thanks: François Pietka).

Bug fixes:

• Be less strict when searching for the \watch command. (Thanks: Irina Truong).
• Fix glitch in EXCLUDE index description emitted by \d command. (Thanks: Lele Gaifax).
• Fix \e command handling. (Thanks: François Pietka).
• Fix UnicodeEncodeError when opening sql statement in editor (Thanks: Klaus Wünschel).
• Fix listing of child tables in \d command. (Thanks: Lele Gaifax).

1.8.0

Features:

• Implement \sf+ function_name. (Thanks: Lele Gaifax).
• Separate check constraints with newlines. (Thanks: Joakim Koljonen).
• Enabled \dm command, corrections to \d+, extended tests. (Thanks: rsc).
• Opening an external editor will edit default text. (Thanks: Thomas Roten).

1.7.0

Features:

• Handling saved queries with parameters. (Thanks: Marcin Sztolcman).

Bug fixes:

• Fix bug where \d called valid indices invalid & vice versa. (Thanks: Joakim Koljonen).
• Fix typo in pset description. (Thanks: Lele Gaifax).

1.6.0

Features:

• Add a function to extract the sql from \watch command. (Thanks: stuartquin).

1.5.0

Features:

• Add support for \db command. (Thanks: Irina Truong).

1.4.0

Features:

• Add support for \copy command. (Thanks: Catherine Devlin).
• Add support for \dx command. (Thanks: Darik Gamble).

1.3.0

Features:

• Add initial support for Postgres 8.4 and above.(Thanks: Timothy Cleaver, darikg). This enables us to add support for Amazon Redshift. If things look broken please report.
• Add \pset pager command. (Thanks: pik).

Bug fixes:

• Fix 'ftoptions' not defined error with FDW. (Thanks: François Pietka).

1.2.0

Features:

• Add support for \h. (Thanks: stuartquin). Users can now run \h [keyword] to checkout the help for a keyboard.

1.1.0

Features:

• Support for \x auto by stuartquin with darikg (ported over from pgcli).

1.0.0

Features:

• First release as an independent package.