Bug#1023453: pgcli: Can't handle PostgreSQL "special" commands

[Yannick Roehlly]

Package: pgcli
Version: 3.5.0-2
Severity: normal

Hi,

PostgreSQL "special" command (like `\d`) executed inside pgcli fails with this
error:

'ProtocolSafeCursor' object has no attribute 'mogrify'

The behaviour was changed during the psycopg3 port [1] and I suppose that the
problem comes form the fact that the python3-pgspecial is still in the version
using psycopg2.

It's not a big problem and we can wait that python3-pgspecial is updated, I'm
just submitting this bug so that users can understand why the special commands
fail.

Best,

Yannick

[1] https://github.com/dbcli/pgcli/commit/18071754bc0c79a7109c5ccfdaa74ed913c343ba

-- System Information:
Debian Release: bookworm/sid
APT prefers unstable
APT policy: (500, 'unstable'), (1, 'experimental')
Architecture: amd64 (x86_64)

Kernel: Linux 6.0.6 (SMP w/12 CPU threads; PREEMPT)
Kernel taint flags: TAINT_PROPRIETARY_MODULE, TAINT_OOT_MODULE,
TAINT_UNSIGNED_MODULE
Locale: LANG=fr_FR.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8),
LANGUAGE=fr:en_GB
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages pgcli depends on:
ii python3 3.10.6-1
ii python3-cli-helpers 2.3.0-1
ii python3-click 8.1.3-0.1
ii python3-configobj 5.0.6-5
ii python3-pendulum 2.1.2-4
ii python3-pgspecial 1.13.0-0.1
ii python3-pkg-resources 65.5.0-1
ii python3-prompt-toolkit 3.0.31-1
ii python3-psycopg3 3.1.3-0.1
ii python3-pygments 2.12.0+dfsg-2
ii python3-setproctitle 1.3.1-1
ii python3-sqlparse 0.4.2-1
ii python3-tabulate 0.8.9-1
ii python3-terminaltables 3.1.10-1

pgcli recommends no packages.

pgcli suggests no packages.

-- no debconf information