* Package: dev-python/pgspecial-2.0.1:0 * Repository: gentoo * Maintainer: python@gentoo.org * USE: abi_x86_64 amd64 elibc_glibc kernel_linux python_targets_python3_10 python_targets_python3_8 python_targets_python3_9 test userland_GNU * FEATURES: network-sandbox preserve-libs sandbox test userpriv usersandbox @@@@@ PLEASE PAY ATTENTION HERE!!! @@@@@ This information may help you to understand if this is a duplicate or if this bug exists after you pushed a fix; This ebuild was merged at the following commit: https://github.com/gentoo-mirror/gentoo/commit/45e6f766480cab7759e4dcc1004a6adaec855c52 (Sat Dec 24 13:47:01 UTC 2022) @@@@@ END @@@@@ ################## # emerge --info: # ################## Portage 3.0.41 (python 3.10.9-final-0, default/linux/amd64/17.1, gcc-12, glibc-2.36-r6, 5.15.77-gentoo-dist x86_64) ================================================================= System uname: Linux-5.15.77-gentoo-dist-x86_64-AMD_EPYC_7513_32-Core_Processor-with-glibc2.36 KiB Mem: 263533016 total, 88560448 free KiB Swap: 0 total, 0 free Timestamp of repository gentoo: Sat, 24 Dec 2022 13:32:06 +0000 sh dash 0.5.12 ld GNU ld (Gentoo 2.39 p5) 2.39.0 app-misc/pax-utils: 1.3.5::gentoo app-shells/bash: 5.2_p15::gentoo dev-lang/perl: 5.36.0-r1::gentoo dev-lang/python: 3.8.16::gentoo, 3.9.16::gentoo, 3.10.9::gentoo, 3.11.1::gentoo dev-util/cmake: 3.25.1::gentoo dev-util/meson: 0.64.1::gentoo sys-apps/baselayout: 2.9::gentoo sys-apps/openrc: 0.45.2-r2::gentoo sys-apps/sandbox: 2.29::gentoo sys-devel/autoconf: 2.71-r5::gentoo sys-devel/automake: 1.16.5::gentoo sys-devel/binutils: 2.39-r4::gentoo sys-devel/binutils-config: 5.4.1::gentoo sys-devel/clang: 15.0.6::gentoo sys-devel/gcc: 12.2.1_p20221210::gentoo sys-devel/gcc-config: 2.8::gentoo sys-devel/libtool: 2.4.7-r1::gentoo sys-devel/llvm: 15.0.6::gentoo sys-devel/make: 4.4::gentoo sys-kernel/linux-headers: 6.1::gentoo (virtual/os-headers) sys-libs/glibc: 2.36-r6::gentoo Repositories: gentoo location: /usr/portage sync-type: rsync sync-uri: rsync://rsync.gentoo.org/gentoo-portage priority: -1000 sync-rsync-verify-jobs: 1 sync-rsync-verify-metamanifest: yes sync-rsync-extra-opts: sync-rsync-verify-max-age: 24 ACCEPT_KEYWORDS="amd64 ~amd64" ACCEPT_LICENSE="* BSD MIT" CBUILD="x86_64-pc-linux-gnu" CFLAGS="-O2 -pipe -pipe -march=x86-64 -frecord-gcc-switches -fno-diagnostics-color -fmessage-length=0" CHOST="x86_64-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/share/gnupg/qualified.txt" CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo" CXXFLAGS="-O2 -pipe -pipe -march=x86-64 -frecord-gcc-switches -fno-diagnostics-color -fmessage-length=0" DISTDIR="/var/tmp/portage/dev-python/pgspecial-2.0.1/distdir" EMERGE_DEFAULT_OPTS="--with-bdeps=y -1 -k -b" ENV_UNSET="CARGO_HOME DBUS_SESSION_BUS_ADDRESS DISPLAY GOBIN GOPATH PERL5LIB PERL5OPT PERLPREFIX PERL_CORE PERL_MB_OPT PERL_MM_OPT XAUTHORITY XDG_CACHE_HOME XDG_CONFIG_HOME XDG_DATA_HOME XDG_RUNTIME_DIR XDG_STATE_HOME" FCFLAGS="-O2 -pipe -pipe -march=x86-64 -frecord-gcc-switches -fno-diagnostics-color -fmessage-length=0" FEATURES="assume-digests binpkg-docompress binpkg-dostrip binpkg-logs binpkg-multi-instance buildpkg buildpkg-live config-protect-if-modified distlocks ebuild-locks fixlafiles ipc-sandbox merge-sync multilib-strict network-sandbox news parallel-fetch pid-sandbox preserve-libs protect-owned qa-unresolved-soname-deps sandbox sfperms sign split-log strict test unknown-features-warn unmerge-logs unmerge-orphans userfetch userpriv usersandbox usersync xattr" FFLAGS="-O2 -pipe -pipe -march=x86-64 -frecord-gcc-switches -fno-diagnostics-color -fmessage-length=0" GENTOO_MIRRORS="http://mirror.leaseweb.com/gentoo/ http://ftp.snt.utwente.nl/pub/os/linux/gentoo/ http://ftp.belnet.be/pub/rsync.gentoo.org/gentoo/ http://distfiles.gentoo.org" LANG="C.UTF8" LDFLAGS="-Wl,-O1 -Wl,--as-needed -Wl,--defsym=__gentoo_check_ldflags__=0" LEX="flex" MAKEOPTS="-j16" PKGDIR="/root/tbci/binpkg" PORTAGE_CONFIGROOT="/" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --omit-dir-times --compress --force --whole-file --delete --stats --human-readable --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages --exclude=/.git" PORTAGE_TMPDIR="/var/tmp" SHELL="/bin/bash" USE="acl amd64 bzip2 cli crypt dri elogind fortran gdbm iconv ipv6 jumbo-build libglvnd libtirpc multilib native-symlinks ncurses nls nptl openmp pam pcre readline seccomp split-usr ssl test test-rust unicode xattr zlib" ABI_X86="64" ELIBC="glibc" KERNEL="linux" PYTHON_TARGETS="python3_8 python3_9 python3_10" USERLAND="GNU" Unset: ADDR2LINE, AR, ARFLAGS, AS, ASFLAGS, CC, CCLD, CONFIG_SHELL, CPP, CPPFLAGS, CTARGET, CXX, CXXFILT, ELFEDIT, EXTRA_ECONF, F77FLAGS, FC, GCOV, GPROF, INSTALL_MASK, LC_ALL, LD, LFLAGS, LIBTOOL, LINGUAS, MAKE, MAKEFLAGS, NM, OBJCOPY, OBJDUMP, PORTAGE_BINHOST, PORTAGE_BUNZIP2_COMMAND, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS, RANLIB, READELF, RUSTFLAGS, SIZE, STRINGS, STRIP, YACC, YFLAGS ############################## # emerge history (qlop -mv): # ############################## 2022-12-24T15:10:15 >>> acct-group/postgres-0-r1 2022-12-24T15:10:16 >>> app-eselect/eselect-postgresql-2.4-r1 2022-12-24T15:10:16 >>> dev-python/click-8.1.3 2022-12-24T15:10:18 >>> dev-python/backports-zoneinfo-0.2.1-r2 2022-12-24T15:10:17 >>> dev-python/sqlparse-0.4.3 2022-12-24T15:10:22 >>> acct-user/postgres-0-r1 2022-12-24T15:10:30 >>> dev-db/postgresql-15.1 2022-12-24T15:10:18 >>> dev-python/configobj-5.0.6-r2 2022-12-24T15:10:36 >>> dev-python/psycopg-3.1.7 2022-12-24T15:10:48 >>> dev-python/pgspecial-2.0.1 2022-12-24T15:11:03 >>> dev-python/iniconfig-1.1.1-r1 2022-12-24T15:11:04 >>> dev-python/pluggy-1.0.0-r2 2022-12-24T15:11:04 >>> dev-python/exceptiongroup-1.1.0 2022-12-24T15:11:05 >>> dev-python/zope-interface-5.5.2 2022-12-24T15:11:06 >>> dev-python/flit_scm-1.7.0 2022-12-24T15:11:14 >>> dev-python/attrs-22.2.0 2022-12-24T15:11:17 >>> dev-python/pytest-7.2.0 ####################################### # installed packages (qlist -ICvUSS): # ####################################### acct-group/audio-0-r1:0 acct-group/cdrom-0-r1:0 acct-group/dialout-0-r1:0 acct-group/disk-0-r1:0 acct-group/input-0-r1:0 acct-group/kmem-0-r1:0 acct-group/kvm-0-r1:0 acct-group/lp-0-r1:0 acct-group/man-0-r1:0 acct-group/messagebus-0-r1:0 acct-group/polkitd-0-r1:0 acct-group/portage-0:0 acct-group/postgres-0-r1:0 acct-group/render-0-r1:0 acct-group/sgx-0:0 acct-group/sshd-0-r1:0 acct-group/tape-0-r1:0 acct-group/tty-0-r1:0 acct-group/video-0-r1:0 acct-user/man-1-r1:0 acct-user/messagebus-0-r1:0 acct-user/polkitd-0-r1:0 acct-user/portage-0:0 acct-user/postgres-0-r1:0 acct-user/sshd-0-r1:0 app-admin/eselect-1.4.20:0 -doc -emacs -vim-syntax app-admin/perl-cleaner-2.30:0 app-alternatives/awk-4:0 -busybox gawk -mawk -nawk split-usr app-alternatives/bc-0:0 -gh gnu app-alternatives/bzip2-1:0 -lbzip2 -pbzip2 reference split-usr app-alternatives/gzip-0:0 -pigz reference split-usr app-alternatives/lex-0-r1:0 flex -reflex app-alternatives/sh-0:0 -bash dash -ksh -lksh -mksh app-alternatives/tar-0:0 gnu -libarchive split-usr app-alternatives/yacc-1-r2:0 bison -byacc -reference app-arch/bzip2-1.0.8-r4:0/1 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 split-usr -static -static-libs -verify-sig app-arch/gzip-1.12-r3:0 -pic -static -verify-sig app-arch/libarchive-3.6.1-r1:0/13 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 acl -blake2 bzip2 e2fsprogs -expat iconv -lz4 lzma -lzo -nettle -static-libs -verify-sig xattr -zstd app-arch/tar-1.34-r2:0 acl -minimal nls -selinux -verify-sig xattr app-arch/unzip-6.0_p27-r1:0 bzip2 -natspec unicode app-arch/xz-utils-5.4.0:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 extra-filters nls split-usr -static-libs -verify-sig app-arch/zstd-1.5.2-r3:0/1 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -lz4 split-usr -static-libs app-crypt/gnupg-2.4.0:0 bzip2 -doc -ldap nls readline -selinux smartcard ssl -test tofu -tools -tpm -usb -user-socket -verify-sig -wks-server app-crypt/gpgme-1.18.0-r2:1/11.6.15.1 -common-lisp cxx -python python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -qt5 -static-libs -test -verify-sig app-crypt/libb2-0.98.1-r3:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -native-cflags openmp -static-libs app-crypt/pinentry-1.2.1-r1:0 -caps -efl -emacs -gnome-keyring -gtk ncurses -qt5 -verify-sig app-crypt/rhash-1.4.3:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -debug nls ssl -static-libs app-editors/nano-7.1:0 -debug -justify -magic -minimal ncurses nls spell -static unicode app-eselect/eselect-fontconfig-20220403:0 app-eselect/eselect-iptables-20220320:0 app-eselect/eselect-lib-bin-symlink-0.1.1-r1:0 app-eselect/eselect-pinentry-0.7.2:0 app-eselect/eselect-postgresql-2.4-r1:0 app-i18n/man-pages-ja-20180315-r1:0 app-i18n/man-pages-l10n-4.14.0-r1:0 l10n_cs l10n_da l10n_de l10n_el l10n_es l10n_fi l10n_fr l10n_hu l10n_id l10n_it l10n_mk l10n_nb l10n_nl l10n_pl l10n_pt-BR l10n_ro l10n_sr l10n_sv l10n_uk l10n_vi app-i18n/man-pages-ru-5.03.2390.2390.20191017-r1:0 app-i18n/man-pages-zh_CN-1.6.3.6:0 app-misc/c_rehash-1.7-r1:0 app-misc/ca-certificates-20211016.3.86:0 -cacert app-misc/editor-wrapper-4-r1:0 app-misc/mime-types-2.1.53:0 -nginx app-misc/pax-utils-1.3.5:0 -caps man -python python_single_target_python3_10 -python_single_target_python3_11 -python_single_target_python3_8 -python_single_target_python3_9 seccomp -test app-misc/tmux-3.3a-r1:0 -debug -selinux -systemd -utempter -vim-syntax app-portage/eix-0.36.5:0 -debug -doc nls -sqlite app-portage/elt-patches-20221210:0 app-portage/gemato-17.0:0 gpg -pretty-log python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test -tools app-portage/gentoolkit-0.6.1-r3:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test app-portage/portage-utils-0.94.4:0 openmp qmanifest qtegrity -static app-shells/bash-5.2_p15:0 -afs -bashlogger -examples -mem-scramble net nls -pgo -plugins readline -verify-sig app-shells/bash-completion-2.11:0 eselect -test app-shells/dash-0.5.12:0 -libedit -static app-shells/gentoo-bashcomp-20190211-r1:0 app-shells/push-3.4:0 app-shells/quoter-4.2:0 app-text/ansifilter-2.18:0 -qt5 app-text/build-docbook-catalog-2.3-r1:0 app-text/docbook-xml-dtd-4.5-r2:4.5 app-text/docbook-xml-dtd-4.4-r3:4.4 app-text/docbook-xml-dtd-4.2-r3:4.2 app-text/docbook-xml-dtd-4.1.2-r7:4.1.2 app-text/docbook-xsl-stylesheets-1.79.1-r3:0 -ruby app-text/manpager-1:0 app-text/opensp-1.5.2-r9:0 -doc nls -static-libs -test app-text/po4a-0.68:0 -test -test app-text/sgml-common-0.6.3-r7:0 app-text/xmlto-0.0.28-r10:0 -latex text dev-db/postgresql-15.1:15 -debug -doc -icu -kerberos -ldap -llvm -lz4 nls pam -perl -python python_single_target_python3_10 -python_single_target_python3_11 -python_single_target_python3_8 -python_single_target_python3_9 readline -selinux server ssl -static-libs -systemd -tcl -threads -uuid -xml zlib -zstd dev-db/sqlite-3.40.0:3 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -debug -doc -icu readline -secure-delete -static-libs -tcl -test -tools dev-lang/duktape-2.7.0-r3:0/2.7.0 dev-lang/perl-5.36.0-r1:0/5.36 -berkdb -debug -doc gdbm ithreads -minimal -quadmath dev-lang/python-3.11.1:3.11 -bluetooth -build ensurepip -examples gdbm -hardened -libedit -lto ncurses -pgo readline sqlite ssl -test -tk -valgrind -verify-sig dev-lang/python-3.10.9:3.10 -bluetooth -build ensurepip -examples gdbm -hardened -libedit -lto ncurses -pgo readline sqlite ssl -test -tk -valgrind -verify-sig xml dev-lang/python-3.9.16:3.9 -bluetooth -build ensurepip -examples gdbm -hardened -lto ncurses -pgo readline sqlite ssl -test -tk -valgrind -verify-sig xml dev-lang/python-3.8.16:3.8 -bluetooth -build ensurepip -examples gdbm -hardened -lto ncurses -pgo readline sqlite ssl -test -tk -valgrind -verify-sig -wininst xml dev-lang/python-exec-2.4.10:2 native-symlinks python_targets_pypy3 python_targets_python3_10 python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-lang/python-exec-conf-2.4.6:2 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 dev-lang/tcl-8.6.13:0/8.6 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -debug threads dev-libs/boehm-gc-8.2.2-r1:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -cxx large -static-libs threads dev-libs/elfutils-0.188:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 bzip2 -lzma nls -static-libs -test utils -valgrind -verify-sig -zstd dev-libs/expat-2.5.0:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -examples -static-libs unicode dev-libs/glib-2.74.4:2 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -dbus -debug elf -gtk-doc mime -selinux -static-libs -sysprof -systemtap -test -utils xattr dev-libs/gmp-6.2.1-r5:0/10.4 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 asm cpudetection cxx -doc -pic -static-libs dev-libs/gobject-introspection-1.74.0:0 -doctool -gtk-doc python_single_target_python3_10 -python_single_target_python3_11 -python_single_target_python3_8 -python_single_target_python3_9 -test dev-libs/gobject-introspection-common-1.74.0:0 dev-libs/isl-0.24-r2:0/23 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -static-libs dev-libs/jsoncpp-1.9.5:0/25 -doc -test dev-libs/libassuan-2.5.5:0 dev-libs/libatomic_ops-7.6.14:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 dev-libs/libevent-2.1.12:0/2.1-7 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 clock-gettime -debug -malloc-replacement ssl -static-libs -test threads -verbose-debug dev-libs/libffi-3.4.4:0/8 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -debug -exec-static-trampoline -pax-kernel -static-libs -test dev-libs/libgcrypt-1.10.1-r3:0/20 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 asm -cpu_flags_arm_aes -cpu_flags_arm_neon -cpu_flags_arm_sha1 -cpu_flags_arm_sha2 -cpu_flags_ppc_altivec -cpu_flags_ppc_vsx2 -cpu_flags_ppc_vsx3 cpu_flags_x86_aes cpu_flags_x86_avx cpu_flags_x86_avx2 -cpu_flags_x86_padlock -cpu_flags_x86_sha cpu_flags_x86_sse4_1 -doc getentropy -static-libs -verify-sig dev-libs/libgpg-error-1.46-r1:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -common-lisp nls -static-libs -test -verify-sig dev-libs/libksba-1.6.3:0 -static-libs -verify-sig dev-libs/libltdl-2.4.7:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -static-libs dev-libs/libpcre2-10.42:0/3 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 bzip2 jit -libedit pcre16 pcre32 readline split-usr -static-libs unicode -verify-sig zlib dev-libs/libpipeline-1.5.7:0 -test dev-libs/libtasn1-4.19.0:0/6 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -static-libs -test -valgrind -verify-sig dev-libs/libunistring-1.1-r1:0/5 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -doc -static-libs dev-libs/libuv-1.44.2-r1:0/1 dev-libs/libxml2-2.10.3-r1:2 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -debug -examples ftp -icu -lzma python python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 readline -static-libs -test dev-libs/libxslt-1.1.37-r1:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 crypt -debug -examples -python python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -static-libs dev-libs/lzo-2.10:2 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -examples split-usr -static-libs dev-libs/mpc-1.3.1:0/3 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -static-libs dev-libs/mpfr-4.1.1_p1:0/6 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -static-libs dev-libs/nettle-3.8.1:0/8-6 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 asm -cpu_flags_arm_aes -cpu_flags_arm_neon -cpu_flags_arm_sha1 -cpu_flags_arm_sha2 -cpu_flags_ppc_altivec cpu_flags_x86_aes cpu_flags_x86_pclmul -cpu_flags_x86_sha -doc gmp -static-libs -verify-sig dev-libs/npth-1.6-r1:0 -test dev-libs/openssl-3.0.7-r2:0/3 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 asm cpu_flags_x86_sse2 -fips -ktls -rfc3779 -sctp -static-libs -test -tls-compression -vanilla -verify-sig -verify-sig -weak-ssl-ciphers dev-libs/popt-1.19:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 nls -static-libs dev-perl/Clone-0.460.0:0 -test dev-perl/Devel-CheckLib-1.160.0:0 -test dev-perl/Encode-EUCJPASCII-0.30.0-r1:0 -test dev-perl/Encode-HanExtra-0.230.0-r3:0 dev-perl/Encode-Locale-1.50.0-r1:0 -test dev-perl/ExtUtils-CChecker-0.110.0:0 -test dev-perl/File-BaseDir-0.90.0:0 -test dev-perl/File-DesktopEntry-0.220.0-r1:0 -test dev-perl/File-Listing-6.150.0:0 -test -test dev-perl/File-MimeInfo-0.300.0:0 -test dev-perl/HTML-Parser-3.760.0:0 -test dev-perl/HTML-Tagset-3.200.0-r2:0 dev-perl/HTTP-Cookies-6.100.0:0 -test dev-perl/HTTP-Date-6.50.0:0 dev-perl/HTTP-Message-6.440.0:0 -test -test dev-perl/HTTP-Negotiate-6.10.0-r2:0 -test dev-perl/IO-HTML-1.4.0:0 -test dev-perl/IO-Socket-INET6-2.720.0-r2:0 -test dev-perl/IO-Socket-SSL-2.78.0:0 -examples -idn -test dev-perl/IPC-System-Simple-1.300.0:0 -test dev-perl/libwww-perl-6.600.0-r1:0 ssl -test dev-perl/Locale-gettext-1.70.0-r1:0 -test dev-perl/LWP-MediaTypes-6.40.0:0 -test dev-perl/LWP-Protocol-https-6.100.0:0 -test dev-perl/MIME-Charset-1.12.2-r1:0 l10n_ja l10n_zh -test dev-perl/Module-Build-0.423.100:0 -test dev-perl/Mozilla-CA-20999999-r1:0 -test dev-perl/Net-HTTP-6.210.0:0 -minimal -test dev-perl/Net-SSLeay-1.920.0:0 -examples -examples -minimal -test dev-perl/Pod-Parser-1.630.0-r1:0 -test dev-perl/SGMLSpm-1.1-r2:0 -test dev-perl/Socket6-0.290.0:0 -test dev-perl/Sub-Name-0.260.0:0 -suggested -test dev-perl/Syntax-Keyword-Try-0.270.0:0 -test dev-perl/TermReadKey-2.380.0-r1:0 -examples -test dev-perl/Text-CharWidth-0.40.0-r2:0 -test dev-perl/Text-WrapI18N-0.60.0-r2:0 -test dev-perl/TimeDate-2.330.0-r1:0 -test dev-perl/Try-Tiny-0.310.0:0 -minimal -test dev-perl/Unicode-LineBreak-2019.1.0:0 dev-perl/URI-5.110.0:0 -test dev-perl/WWW-RobotRules-6.20.0-r2:0 -test dev-perl/XML-Parser-2.460.0-r2:0 dev-perl/XS-Parse-Keyword-0.250.0:0 -test dev-perl/YAML-Tiny-1.730.0-r1:0 -minimal -test dev-python/appdirs-1.4.4-r2:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 dev-python/attrs-22.2.0:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/autocommand-2.2.2:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/backports-zoneinfo-0.2.1-r2:0 python_targets_python3_8 -test dev-python/certifi-3021.3.16-r3:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/charset_normalizer-3.0.1:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/click-8.1.3:0 -doc -examples python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/configobj-5.0.6-r2:0 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/cython-0.29.32:0 -doc -emacs python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/ensurepip-pip-22.3.1:0 dev-python/ensurepip-setuptools-65.6.3:0 dev-python/ensurepip-wheels-100:0 dev-python/exceptiongroup-1.1.0:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/flit_core-3.8.0:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/flit_scm-1.7.0:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 dev-python/gpep517-13:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/idna-3.4:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/importlib_metadata-5.2.0:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/importlib_resources-5.10.1:0 python_targets_pypy3 python_targets_python3_8 -test dev-python/inflect-6.0.2:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/iniconfig-1.1.1-r1:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/installer-0.6.0:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/jaraco-context-4.2.0:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/jaraco-functools-3.5.2:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/jaraco-text-3.11.0:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/jinja-3.1.2:0 -doc -examples python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/markupsafe-2.1.1:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/more-itertools-9.0.0:0 -doc python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/nspektr-0.4.0:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/ordered-set-4.1.0:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/packaging-21.3-r2:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/pgspecial-2.0.1:0 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/pluggy-1.0.0-r2:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/psycopg-3.1.7:0 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/pydantic-1.10.2:0 native-extensions python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/pyparsing-3.0.9:0 -examples python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/pypy3-7.3.10_p1:0/pypy39-pp73-336 ensurepip gdbm jit ncurses sqlite -tk dev-python/pypy3-exe-bin-7.3.10:3.9-7.3.10 dev-python/PySocks-1.7.1-r2:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 dev-python/pytest-7.2.0:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/requests-2.28.1-r1:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -socks5 -test test-rust dev-python/setuptools-65.6.3:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/setuptools_scm-7.1.0:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/six-1.16.0-r1:0 -doc python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/sqlparse-0.4.3:0 -doc python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/tomli-2.0.1-r1:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/typing-extensions-4.3.0:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 dev-python/urllib3-1.26.13:0 -brotli python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/wheel-0.38.4:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/zipp-3.11.0:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-python/zope-interface-5.5.2:0 python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-util/checkbashisms-2.22.2:0 dev-util/cmake-3.25.1:0 -doc -emacs ncurses -qt5 -test -test -verify-sig dev-util/desktop-file-utils-0.26-r2:0 -emacs dev-util/glib-utils-2.74.4:0 python_single_target_python3_10 -python_single_target_python3_11 -python_single_target_python3_8 -python_single_target_python3_9 dev-util/gperf-3.1-r1:0 dev-util/gtk-doc-am-1.33.2:0 dev-util/intltool-0.51.0-r3:0 dev-util/meson-0.64.1:0 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -test dev-util/meson-format-array-0:0 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 dev-util/ninja-1.11.1-r2:0 -doc -emacs -test dev-util/pkgconf-1.8.0-r1:0/3 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -test dev-util/re2c-2.2:0 -debug -test dev-vcs/git-2.39.0:0 blksha1 -cgi curl -cvs -doc -gnome-keyring gpg -highlight iconv -mediawiki -mediawiki-experimental nls pcre -perforce -perl python_single_target_python3_10 -python_single_target_python3_11 -python_single_target_python3_8 -python_single_target_python3_9 safe-directory -selinux -subversion -test -tk webdav -xinetd media-fonts/liberation-fonts-2.1.5:0 -X -X -fontforge media-gfx/graphite2-1.3.14_p20210810-r2:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -perl -test media-libs/fontconfig-2.14.1-r1:1.0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -doc nls -test media-libs/freetype-2.12.1-r2:2 -X -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 adobe-cff -brotli bzip2 cleartype-hinting -debug -doc -fontforge harfbuzz -infinality png -static-libs -svg -utils media-libs/harfbuzz-6.0.0:0/6.0.0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 cairo -debug -doc -experimental glib graphite -icu introspection -test truetype media-libs/libpng-1.6.39:0/16 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -apng -cpu_flags_arm_neon cpu_flags_x86_sse -static-libs net-dns/c-ares-1.18.1:0/2 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -static-libs -test net-dns/libidn2-2.3.4:0/2 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 nls -static-libs -verify-sig net-firewall/iptables-1.8.8-r5:0/1.8.3 -conntrack -netlink -nftables -pcap split-usr -static-libs net-libs/gnutls-3.7.8:0/30.30 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -brotli cxx -dane -doc -examples -guile idn nls openssl -pkcs11 seccomp -sslv2 -sslv3 -static-libs -test -test-full tls-heartbeat -tools -valgrind -verify-sig zlib -zstd net-libs/libmnl-1.0.5:0/0.2.0 -examples -verify-sig net-libs/libnsl-2.0.0-r1:0/3 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -static-libs net-libs/libtirpc-1.3.3:0/3 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -kerberos split-usr -static-libs net-libs/nghttp2-1.51.0:0/1.14 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -cxx -debug -hpack-tools -jemalloc -static-libs -test -utils -xml net-misc/curl-7.87.0:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 adns -alt-svc -brotli -curl_ssl_gnutls -curl_ssl_mbedtls -curl_ssl_nss curl_ssl_openssl -curl_ssl_rustls ftp -gnutls -gopher -hsts http2 -idn imap ipv6 -kerberos -ldap -mbedtls -nghttp3 -nss openssl pop3 progress-meter -quiche -rtmp -rustls -samba smtp -ssh ssl -sslv3 -static-libs -telnet -test tftp -verify-sig -websockets -zstd net-misc/dhcpcd-9.4.1:0 -debug embedded ipv6 -privsep udev net-misc/iputils-20221126:0 arping -caps -clockdiff -doc filecaps -idn nls -test -tracepath net-misc/netifrc-0.7.3-r1:0 dhcp net-misc/openssh-9.1_p1-r1:0 -X -X509 -abi_mips_n32 -audit -debug -hpn -kerberos -ldns -libedit -livecd pam pie -sctp -security-key -selinux ssl -static -test -verify-sig -xmss net-misc/rsync-3.2.7-r1:0 acl -examples iconv -lz4 python_single_target_python3_10 -python_single_target_python3_8 -python_single_target_python3_9 -rrsync ssl -stunnel -system-zlib -verify-sig xattr -xxhash -zstd net-misc/wget-1.21.3-r1:0 -cookie-check -debug -gnutls -idn ipv6 -metalink nls -ntlm pcre ssl -static -test -uuid -verify-sig zlib perl-core/Compress-Raw-Zlib-2.202.0:0 perl-core/File-Temp-0.231.100:0 sec-keys/openpgp-keys-gentoo-release-20220101:0 -test sys-apps/acl-2.3.1-r1:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 nls split-usr -static-libs sys-apps/attr-2.5.1-r2:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -debug nls split-usr -static-libs sys-apps/baselayout-2.9:0 -build split-usr sys-apps/coreutils-9.1-r2:0 acl -caps -gmp -hostname -kill -multicall nls openssl -selinux split-usr -static -test -vanilla -verify-sig xattr sys-apps/dbus-1.15.2:0 -X -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -debug -doc elogind -selinux -static-libs -systemd -test -test sys-apps/debianutils-5.7:0 installkernel -static sys-apps/diffutils-3.8:0 nls -static -verify-sig sys-apps/file-5.43-r1:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 bzip2 -lzma -python python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 -seccomp -static-libs -verify-sig zlib sys-apps/findutils-4.9.0-r2:0 nls -selinux -static -test -verify-sig sys-apps/gawk-5.2.1:0 -mpfr nls -pma readline -verify-sig sys-apps/gentoo-functions-0.17:0 sys-apps/grep-3.8-r1:0 egrep-fgrep nls pcre -static -verify-sig sys-apps/groff-1.22.4:0 -X -examples -uchardet sys-apps/help2man-1.49.3:0 nls sys-apps/install-xattr-0.8:0 sys-apps/iproute2-6.1.0:0 -atm -berkdb -bpf -caps -elf iptables -libbsd -minimal -nfs -selinux split-usr sys-apps/kbd-2.5.1:0 nls pam -test sys-apps/kmod-30:0 -debug -doc lzma -pkcs7 -python python_targets_python3_10 python_targets_python3_8 python_targets_python3_9 -static-libs tools zlib zstd sys-apps/less-608-r1:0 pcre unicode sys-apps/man-db-2.11.1:0 manpager nls seccomp -selinux -static-libs zlib sys-apps/man-pages-6.02:0 l10n_cs l10n_da l10n_de l10n_el l10n_es l10n_fi l10n_fr l10n_hu l10n_id l10n_it l10n_ja l10n_mk l10n_nb l10n_nl l10n_pl l10n_pt-BR l10n_ro l10n_ru l10n_sr l10n_sv l10n_uk l10n_vi l10n_zh-CN sys-apps/miscfiles-1.5-r4:0 -minimal sys-apps/net-tools-2.10:0 arp hostname ipv6 -nis nls -plipconfig -selinux -slattach -static sys-apps/openrc-0.45.2-r2:0 -audit -bash -debug ncurses netifrc -newnet pam -selinux -sysv-utils unicode sys-apps/portage-3.0.41-r1:0 -apidoc -build -doc -gentoo-dev ipc native-extensions python_targets_pypy3 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 rsync-verify -selinux -test xattr sys-apps/sandbox-2.29:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 abi_x86_32 abi_x86_64 -abi_x86_x32 nnp sys-apps/sed-4.9:0 acl nls -selinux -static -verify-sig sys-apps/shadow-4.13-r1:0/4 acl -audit -bcrypt -cracklib nls pam -selinux -skey split-usr -su -verify-sig xattr sys-apps/systemd-utils-251.10:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 acl -boot kmod -selinux split-usr -split-usr -sysusers -test tmpfiles udev sys-apps/sysvinit-3.06:0 -ibm nls -selinux -static -verify-sig sys-apps/texinfo-7.0.1:0 nls standalone -static sys-apps/util-linux-2.38.1:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -audit -build -caps cramfs -cryptsetup -fdformat hardlink -kill logger -magic ncurses nls pam -python python_targets_python3_10 python_targets_python3_8 python_targets_python3_9 readline -rtas -selinux -slang split-usr -static-libs su suid -systemd -test -tty-helpers -udev unicode -verify-sig sys-apps/which-2.21:0 sys-auth/elogind-246.10-r2:0 acl -audit cgroup-hybrid -debug -doc pam policykit -selinux -test sys-auth/pambase-20220214:0 -caps -debug elogind -gnome-keyring -homed -minimal -mktemp nullok -pam_krb5 -pam_ssh passwdqc -pwhistory -pwquality -securetty -selinux sha512 -systemd -yescrypt sys-auth/passwdqc-2.0.2-r1:0 sys-auth/polkit-122:0 daemon duktape -examples -gtk introspection -kde pam -selinux -systemd -test sys-devel/autoconf-2.71-r5:2.71 -emacs sys-devel/autoconf-archive-2022.09.03:0 sys-devel/autoconf-wrapper-20221207:0 sys-devel/automake-1.16.5:1.16 -test sys-devel/automake-wrapper-11-r1:0 sys-devel/bc-1.07.1-r6:0 -libedit readline -static sys-devel/binutils-2.39-r4:2.39 -cet -default-gold -doc -gold -gprofng -multitarget nls -pgo plugins -static-libs -test -vanilla sys-devel/binutils-config-5.4.1:0 native-symlinks sys-devel/bison-3.8.2-r2:0 -examples nls -static -test -verify-sig sys-devel/clang-15.0.6:15/15 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -debug -doc -doc extra llvm_targets_AArch64 llvm_targets_AMDGPU -llvm_targets_ARC llvm_targets_ARM llvm_targets_AVR llvm_targets_BPF -llvm_targets_CSKY -llvm_targets_DirectX llvm_targets_Hexagon llvm_targets_Lanai -llvm_targets_LoongArch -llvm_targets_M68k llvm_targets_MSP430 llvm_targets_Mips llvm_targets_NVPTX llvm_targets_PowerPC llvm_targets_RISCV -llvm_targets_SPIRV llvm_targets_Sparc llvm_targets_SystemZ llvm_targets_VE llvm_targets_WebAssembly llvm_targets_X86 llvm_targets_XCore pie python_single_target_python3_10 -python_single_target_python3_11 -python_single_target_python3_8 -python_single_target_python3_9 static-analyzer -test -test -verify-sig -xml sys-devel/clang-common-15.0.6:0 -default-compiler-rt -default-libcxx -default-lld -llvm-libunwind -stricter -verify-sig sys-devel/clang-runtime-15.0.6:15.0.6 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 abi_x86_32 abi_x86_64 -abi_x86_x32 compiler-rt -libcxx openmp sanitize sys-devel/clang-toolchain-symlinks-15-r2:15 -gcc-symlinks -multilib-symlinks native-symlinks sys-devel/flex-2.6.4-r5:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 nls -static -test sys-devel/gcc-12.2.1_p20221210:12 -ada -cet -custom-cflags cxx -d -debug -default-stack-clash-protection -default-znow -doc -fixed-point fortran -go graphite -hardened -ieee-long-double -jit -libssp lto multilib nls nptl -objc -objc++ -objc-gc openmp -pch -pgo pie sanitize ssp -systemtap -test -valgrind -vanilla -vtv -zstd sys-devel/gcc-config-2.8:0 cc-wrappers native-symlinks sys-devel/gettext-0.21.1:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 acl -cvs cxx -doc -emacs -git -java -java ncurses nls openmp -static-libs -verify-sig sys-devel/gnuconfig-20221007:0 sys-devel/libtool-2.4.7-r1:2 -vanilla sys-devel/llvm-15.0.6:15/15 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 binutils-plugin -debug -doc -doc -exegesis -libedit libffi llvm_targets_AArch64 llvm_targets_AMDGPU -llvm_targets_ARC llvm_targets_ARM llvm_targets_AVR llvm_targets_BPF -llvm_targets_CSKY -llvm_targets_DirectX llvm_targets_Hexagon llvm_targets_Lanai -llvm_targets_LoongArch -llvm_targets_M68k llvm_targets_MSP430 llvm_targets_Mips llvm_targets_NVPTX llvm_targets_PowerPC llvm_targets_RISCV -llvm_targets_SPIRV llvm_targets_Sparc llvm_targets_SystemZ llvm_targets_VE llvm_targets_WebAssembly llvm_targets_X86 llvm_targets_XCore ncurses -test -verify-sig -xar -xml -z3 -zstd sys-devel/llvm-common-15.0.6:0 -verify-sig sys-devel/llvm-toolchain-symlinks-15-r1:15 -multilib-symlinks native-symlinks sys-devel/llvmgold-15:0 sys-devel/m4-1.4.19:0 -examples nls -verify-sig sys-devel/make-4.4:0 -guile nls -static -verify-sig sys-devel/patch-2.7.6-r5:0 -static -test -verify-sig xattr sys-fs/e2fsprogs-1.46.5-r4:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -cron -fuse -lto nls split-usr -static-libs -test tools sys-fs/udev-init-scripts-35:0 sys-kernel/installkernel-gentoo-6:0 -grub sys-kernel/linux-headers-6.1:0 -headers-only sys-libs/binutils-libs-2.39-r4:0/2.39 -64-bit-bfd -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -cet -multitarget nls -static-libs sys-libs/compiler-rt-15.0.6:15.0.6 abi_x86_32 abi_x86_64 clang -debug -test -verify-sig sys-libs/compiler-rt-sanitizers-15.0.6:15.0.6 abi_x86_32 abi_x86_64 asan cfi clang -debug dfsan gwp-asan hwasan libfuzzer lsan memprof msan orc profile safestack scudo -shadowcallstack -test -test tsan ubsan -verify-sig xray sys-libs/gdbm-1.23:0/6 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 berkdb nls readline -static-libs -test -verify-sig sys-libs/glibc-2.36-r6:2.2 -audit -caps -cet -compile-locales -crypt -custom-cflags -doc -gd -hash-sysv-compat -headers-only multiarch multilib -multilib-bootstrap -nscd -profile -selinux ssp stack-realign static-libs -suid -systemd -systemtap -test -vanilla sys-libs/libcap-2.66:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 pam split-usr -static-libs -tools sys-libs/libomp-15.0.6:0/15 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 abi_x86_32 abi_x86_64 -abi_x86_x32 -debug -hwloc -llvm_targets_AMDGPU -llvm_targets_NVPTX -offload -ompt -test -verify-sig sys-libs/libseccomp-2.5.4:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -experimental-loong -python python_targets_python3_10 python_targets_python3_8 python_targets_python3_9 -static-libs -test sys-libs/libxcrypt-4.4.33:0/1 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 abi_x86_32 abi_x86_64 -abi_x86_x32 compat -headers-only split-usr -static-libs system -test sys-libs/ncurses-6.3_p20221203:0/6 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -ada cxx -debug -doc -gpm -minimal -profile split-usr -split-usr stack-realign -static-libs -test tinfo -trace -verify-sig sys-libs/pam-1.5.2-r3:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -audit -berkdb -debug filecaps -nis -selinux split-usr sys-libs/readline-8.2_p1:0/8 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 split-usr -static-libs unicode -utils -verify-sig sys-libs/timezone-data-2022g:0 -leaps-timezone nls -zic-slim sys-libs/zlib-1.2.13-r1:0/1 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 minizip split-usr -static-libs -verify-sig sys-process/procps-3.3.17-r1:0/8 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 elogind kill -modern-top ncurses nls -selinux split-usr -static-libs -systemd -test unicode sys-process/psmisc-23.6:0 -X -apparmor nls -selinux -test virtual/acl-0-r2:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -static-libs virtual/dev-manager-0-r2:0 virtual/editor-0-r4:0 virtual/libc-1-r1:0 virtual/libcrypt-2-r1:0/2 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 abi_x86_32 abi_x86_64 -abi_x86_x32 -static-libs virtual/libelf-3-r1:0/1 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 virtual/libiconv-0-r2:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 virtual/libintl-0-r2:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 virtual/libudev-232-r7:0/1 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -systemd virtual/man-0-r4:0 virtual/os-headers-0-r2:0 virtual/package-manager-1:0 virtual/pager-0-r1:0 virtual/perl-Carp-1.520.0-r2:0 virtual/perl-Compress-Raw-Bzip2-2.103.0-r3:0 virtual/perl-Compress-Raw-Zlib-2.202.0:0 virtual/perl-CPAN-2.330.0:0 virtual/perl-CPAN-Meta-2.150.10-r6:0 virtual/perl-CPAN-Meta-Requirements-2.140.0-r8:0 virtual/perl-CPAN-Meta-YAML-0.18.0-r8:0 virtual/perl-Data-Dumper-2.184.0:0 virtual/perl-Digest-MD5-2.580.0-r1:0 virtual/perl-Encode-3.170.0:0 virtual/perl-Exporter-5.770.0:0 virtual/perl-ExtUtils-CBuilder-0.280.236-r1:0 virtual/perl-ExtUtils-Install-2.200.0-r1:0 virtual/perl-ExtUtils-MakeMaker-7.640.0:0 virtual/perl-ExtUtils-Manifest-1.730.0-r1:0 virtual/perl-ExtUtils-ParseXS-3.450.0:0 virtual/perl-File-Path-2.180.0-r1:0 virtual/perl-File-Spec-3.840.0:0 virtual/perl-File-Temp-0.231.100:0 virtual/perl-Getopt-Long-2.520.0-r1:0 virtual/perl-IO-1.500.0:0 virtual/perl-IO-Compress-2.106.0:0 virtual/perl-IO-Socket-IP-0.410.0-r1:0 virtual/perl-JSON-PP-4.70.0:0 virtual/perl-libnet-3.140.0:0 ssl virtual/perl-MIME-Base64-3.160.0-r1:0 virtual/perl-Module-Metadata-1.0.37-r2:0 virtual/perl-parent-0.238.0-r2:0 virtual/perl-Parse-CPAN-Meta-2.150.10-r6:0 virtual/perl-Perl-OSType-1.10.0-r6:0 virtual/perl-podlators-4.140.0-r3:0 virtual/perl-Scalar-List-Utils-1.620.0:0 virtual/perl-Test-Harness-3.440.0:0 virtual/perl-Text-ParseWords-3.310.0:0 virtual/perl-Time-Local-1.300.0-r1:0 virtual/perl-version-0.992.900:0 virtual/perl-XSLoader-0.310.0:0 virtual/pkgconfig-2-r1:0 virtual/service-manager-1-r1:0 virtual/ssh-0-r1:0 -minimal virtual/tmpfiles-0-r3:0 virtual/ttf-fonts-1-r2:0 virtual/udev-217-r5:0 virtual/w3m-1:0 www-client/pybugz-0.13-r2:0 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 www-client/w3m-0.5.3_p20220429-r1:0 -X -fbcon -gdk-pixbuf -gpm -imlib l10n_ja -lynxkeymap nls -nntp ssl unicode -xface x11-apps/xprop-1.2.6:0 x11-apps/xset-1.2.5:0 x11-base/xcb-proto-1.15.2:0 python_targets_python3_10 -python_targets_python3_11 python_targets_python3_8 python_targets_python3_9 x11-base/xorg-proto-2022.2:0 -test x11-libs/cairo-1.17.6:0 -X -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -aqua -debug -gles2-only -gles3 glib -gtk-doc -opengl -test x11-libs/libICE-1.1.1-r1:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 x11-libs/libSM-1.2.4:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -doc uuid x11-libs/libX11-1.8.3:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -doc -test x11-libs/libXau-1.0.11:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -doc x11-libs/libxcb-1.15-r1:0/1.12 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -doc -doc -selinux -test xkb x11-libs/libXdmcp-1.1.4-r2:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -doc x11-libs/libXext-1.3.5:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -doc x11-libs/libXmu-1.1.4:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -doc x11-libs/libXt-1.2.1:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -doc -test x11-libs/pixman-0.42.2:0 -abi_mips_n32 -abi_mips_n64 -abi_mips_o32 -abi_s390_32 -abi_s390_64 -abi_x86_32 abi_x86_64 -abi_x86_x32 -cpu_flags_arm_iwmmxt -cpu_flags_arm_iwmmxt2 -cpu_flags_arm_neon -cpu_flags_ppc_altivec cpu_flags_x86_mmxext cpu_flags_x86_sse2 cpu_flags_x86_ssse3 -loongson2f -static-libs -test x11-libs/xtrans-1.4.0:0 -doc x11-misc/compose-tables-1.8.3:0 x11-misc/shared-mime-info-2.2:0 -test x11-misc/xdg-utils-1.1.3_p20210805-r1:0 -dbus -doc -gnome ####################### # build.log # ####################### >>> Unpacking source... >>> Unpacking pgspecial-2.0.1.gh.tar.gz to /var/tmp/portage/dev-python/pgspecial-2.0.1/work >>> Source unpacked in /var/tmp/portage/dev-python/pgspecial-2.0.1/work >>> Preparing source in /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1 ... * Build system packages: * dev-python/gpep517 : 13 * dev-python/installer : 0.6.0 * dev-python/setuptools : 65.6.3 * dev-python/setuptools_scm : 7.1.0 * dev-python/wheel : 0.38.4 >>> Source prepared. >>> Configuring source in /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1 ... >>> Source configured. >>> Compiling source in /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1 ... * python3_8: running distutils-r1_run_phase distutils-r1_python_compile * Building the wheel for pgspecial-2.0.1 via setuptools.build_meta:__legacy__ gpep517 build-wheel --backend setuptools.build_meta:__legacy__ --output-fd 3 --wheel-dir /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1-python3_8/wheel 2022-12-24 15:11:22,283 gpep517 INFO Building wheel via backend setuptools.build_meta:__legacy__ 2022-12-24 15:11:22,312 root INFO running bdist_wheel 2022-12-24 15:11:22,360 root INFO running build 2022-12-24 15:11:22,361 root INFO running build_py 2022-12-24 15:11:22,364 root INFO creating build 2022-12-24 15:11:22,364 root INFO creating build/lib 2022-12-24 15:11:22,364 root INFO creating build/lib/pgspecial 2022-12-24 15:11:22,365 root INFO copying pgspecial/namedqueries.py -> build/lib/pgspecial 2022-12-24 15:11:22,365 root INFO copying pgspecial/main.py -> build/lib/pgspecial 2022-12-24 15:11:22,365 root INFO copying pgspecial/iocommands.py -> build/lib/pgspecial 2022-12-24 15:11:22,365 root INFO copying pgspecial/dbcommands.py -> build/lib/pgspecial 2022-12-24 15:11:22,365 root INFO copying pgspecial/__init__.py -> build/lib/pgspecial 2022-12-24 15:11:22,365 root INFO creating build/lib/pgspecial/help 2022-12-24 15:11:22,366 root INFO copying pgspecial/help/commands.py -> build/lib/pgspecial/help 2022-12-24 15:11:22,366 root INFO copying pgspecial/help/__init__.py -> build/lib/pgspecial/help 2022-12-24 15:11:22,366 root WARNING warning: build_py: byte-compiling is disabled, skipping. 2022-12-24 15:11:22,373 wheel INFO installing to build/bdist.linux-x86_64/wheel 2022-12-24 15:11:22,373 root INFO running install 2022-12-24 15:11:22,382 root INFO running install_lib 2022-12-24 15:11:22,385 root INFO creating build/bdist.linux-x86_64 2022-12-24 15:11:22,385 root INFO creating build/bdist.linux-x86_64/wheel 2022-12-24 15:11:22,385 root INFO creating build/bdist.linux-x86_64/wheel/pgspecial 2022-12-24 15:11:22,386 root INFO creating build/bdist.linux-x86_64/wheel/pgspecial/help 2022-12-24 15:11:22,386 root INFO copying build/lib/pgspecial/help/__init__.py -> build/bdist.linux-x86_64/wheel/pgspecial/help 2022-12-24 15:11:22,386 root INFO copying build/lib/pgspecial/help/commands.py -> build/bdist.linux-x86_64/wheel/pgspecial/help 2022-12-24 15:11:22,386 root INFO copying build/lib/pgspecial/__init__.py -> build/bdist.linux-x86_64/wheel/pgspecial 2022-12-24 15:11:22,386 root INFO copying build/lib/pgspecial/dbcommands.py -> build/bdist.linux-x86_64/wheel/pgspecial 2022-12-24 15:11:22,386 root INFO copying build/lib/pgspecial/iocommands.py -> build/bdist.linux-x86_64/wheel/pgspecial 2022-12-24 15:11:22,387 root INFO copying build/lib/pgspecial/main.py -> build/bdist.linux-x86_64/wheel/pgspecial 2022-12-24 15:11:22,387 root INFO copying build/lib/pgspecial/namedqueries.py -> build/bdist.linux-x86_64/wheel/pgspecial 2022-12-24 15:11:22,387 root WARNING warning: install_lib: byte-compiling is disabled, skipping. 2022-12-24 15:11:22,387 root INFO running install_egg_info 2022-12-24 15:11:22,397 root INFO running egg_info 2022-12-24 15:11:22,397 root INFO creating pgspecial.egg-info 2022-12-24 15:11:22,400 root INFO writing pgspecial.egg-info/PKG-INFO 2022-12-24 15:11:22,400 root INFO writing dependency_links to pgspecial.egg-info/dependency_links.txt 2022-12-24 15:11:22,400 root INFO writing requirements to pgspecial.egg-info/requires.txt 2022-12-24 15:11:22,400 root INFO writing top-level names to pgspecial.egg-info/top_level.txt 2022-12-24 15:11:22,401 root INFO writing manifest file 'pgspecial.egg-info/SOURCES.txt' 2022-12-24 15:11:22,413 setuptools_scm.file_finder_git ERROR listing git files failed - pretending there aren't any 2022-12-24 15:11:22,416 root INFO reading manifest file 'pgspecial.egg-info/SOURCES.txt' 2022-12-24 15:11:22,416 root INFO reading manifest template 'MANIFEST.in' 2022-12-24 15:11:22,418 root WARNING warning: no files found matching '*.ini' under directory 'tests' 2022-12-24 15:11:22,418 root INFO writing manifest file 'pgspecial.egg-info/SOURCES.txt' 2022-12-24 15:11:22,418 root INFO Copying pgspecial.egg-info to build/bdist.linux-x86_64/wheel/pgspecial-2.0.1-py3.8.egg-info 2022-12-24 15:11:22,419 root INFO running install_scripts 2022-12-24 15:11:22,436 wheel INFO creating build/bdist.linux-x86_64/wheel/pgspecial-2.0.1.dist-info/WHEEL 2022-12-24 15:11:22,436 wheel INFO creating '/var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1-python3_8/wheel/.tmp-c5njpxke/pgspecial-2.0.1-py3-none-any.whl' and adding 'build/bdist.linux-x86_64/wheel' to it 2022-12-24 15:11:22,436 wheel INFO adding 'pgspecial/__init__.py' 2022-12-24 15:11:22,437 wheel INFO adding 'pgspecial/dbcommands.py' 2022-12-24 15:11:22,437 wheel INFO adding 'pgspecial/iocommands.py' 2022-12-24 15:11:22,437 wheel INFO adding 'pgspecial/main.py' 2022-12-24 15:11:22,437 wheel INFO adding 'pgspecial/namedqueries.py' 2022-12-24 15:11:22,437 wheel INFO adding 'pgspecial/help/__init__.py' 2022-12-24 15:11:22,437 wheel INFO adding 'pgspecial/help/commands.py' 2022-12-24 15:11:22,438 wheel INFO adding 'pgspecial-2.0.1.dist-info/METADATA' 2022-12-24 15:11:22,438 wheel INFO adding 'pgspecial-2.0.1.dist-info/WHEEL' 2022-12-24 15:11:22,438 wheel INFO adding 'pgspecial-2.0.1.dist-info/top_level.txt' 2022-12-24 15:11:22,438 wheel INFO adding 'pgspecial-2.0.1.dist-info/RECORD' 2022-12-24 15:11:22,438 wheel INFO removing build/bdist.linux-x86_64/wheel 2022-12-24 15:11:22,439 gpep517 INFO The backend produced /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1-python3_8/wheel/pgspecial-2.0.1-py3-none-any.whl * Installing pgspecial-2.0.1-py3-none-any.whl to /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1-python3_8/install gpep517 install-wheel --destdir=/var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1-python3_8/install --interpreter=/usr/bin/python3.8 --prefix=/usr --optimize=all /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1-python3_8/wheel/pgspecial-2.0.1-py3-none-any.whl 2022-12-24 15:11:22,519 gpep517 INFO Installing /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1-python3_8/wheel/pgspecial-2.0.1-py3-none-any.whl into /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1-python3_8/install 2022-12-24 15:11:22,555 gpep517 INFO Installation complete * python3_9: running distutils-r1_run_phase distutils-r1_python_compile * Building the wheel for pgspecial-2.0.1 via setuptools.build_meta:__legacy__ gpep517 build-wheel --backend setuptools.build_meta:__legacy__ --output-fd 3 --wheel-dir /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1-python3_9/wheel 2022-12-24 15:11:22,863 gpep517 INFO Building wheel via backend setuptools.build_meta:__legacy__ 2022-12-24 15:11:22,890 root INFO running bdist_wheel 2022-12-24 15:11:22,938 root INFO running build 2022-12-24 15:11:22,938 root INFO running build_py 2022-12-24 15:11:22,942 root INFO creating build 2022-12-24 15:11:22,942 root INFO creating build/lib 2022-12-24 15:11:22,942 root INFO creating build/lib/pgspecial 2022-12-24 15:11:22,942 root INFO copying pgspecial/namedqueries.py -> build/lib/pgspecial 2022-12-24 15:11:22,942 root INFO copying pgspecial/main.py -> build/lib/pgspecial 2022-12-24 15:11:22,942 root INFO copying pgspecial/iocommands.py -> build/lib/pgspecial 2022-12-24 15:11:22,943 root INFO copying pgspecial/dbcommands.py -> build/lib/pgspecial 2022-12-24 15:11:22,943 root INFO copying pgspecial/__init__.py -> build/lib/pgspecial 2022-12-24 15:11:22,943 root INFO creating build/lib/pgspecial/help 2022-12-24 15:11:22,943 root INFO copying pgspecial/help/commands.py -> build/lib/pgspecial/help 2022-12-24 15:11:22,943 root INFO copying pgspecial/help/__init__.py -> build/lib/pgspecial/help 2022-12-24 15:11:22,944 root WARNING warning: build_py: byte-compiling is disabled, skipping. 2022-12-24 15:11:22,951 wheel INFO installing to build/bdist.linux-x86_64/wheel 2022-12-24 15:11:22,951 root INFO running install 2022-12-24 15:11:22,959 root INFO running install_lib 2022-12-24 15:11:22,963 root INFO creating build/bdist.linux-x86_64 2022-12-24 15:11:22,963 root INFO creating build/bdist.linux-x86_64/wheel 2022-12-24 15:11:22,963 root INFO creating build/bdist.linux-x86_64/wheel/pgspecial 2022-12-24 15:11:22,963 root INFO creating build/bdist.linux-x86_64/wheel/pgspecial/help 2022-12-24 15:11:22,963 root INFO copying build/lib/pgspecial/help/__init__.py -> build/bdist.linux-x86_64/wheel/pgspecial/help 2022-12-24 15:11:22,963 root INFO copying build/lib/pgspecial/help/commands.py -> build/bdist.linux-x86_64/wheel/pgspecial/help 2022-12-24 15:11:22,964 root INFO copying build/lib/pgspecial/__init__.py -> build/bdist.linux-x86_64/wheel/pgspecial 2022-12-24 15:11:22,964 root INFO copying build/lib/pgspecial/dbcommands.py -> build/bdist.linux-x86_64/wheel/pgspecial 2022-12-24 15:11:22,964 root INFO copying build/lib/pgspecial/iocommands.py -> build/bdist.linux-x86_64/wheel/pgspecial 2022-12-24 15:11:22,964 root INFO copying build/lib/pgspecial/main.py -> build/bdist.linux-x86_64/wheel/pgspecial 2022-12-24 15:11:22,964 root INFO copying build/lib/pgspecial/namedqueries.py -> build/bdist.linux-x86_64/wheel/pgspecial 2022-12-24 15:11:22,964 root WARNING warning: install_lib: byte-compiling is disabled, skipping. 2022-12-24 15:11:22,964 root INFO running install_egg_info 2022-12-24 15:11:22,974 root INFO running egg_info 2022-12-24 15:11:22,977 root INFO writing pgspecial.egg-info/PKG-INFO 2022-12-24 15:11:22,977 root INFO writing dependency_links to pgspecial.egg-info/dependency_links.txt 2022-12-24 15:11:22,977 root INFO writing requirements to pgspecial.egg-info/requires.txt 2022-12-24 15:11:22,977 root INFO writing top-level names to pgspecial.egg-info/top_level.txt 2022-12-24 15:11:22,990 setuptools_scm.file_finder_git ERROR listing git files failed - pretending there aren't any 2022-12-24 15:11:22,993 root INFO reading manifest file 'pgspecial.egg-info/SOURCES.txt' 2022-12-24 15:11:22,994 root INFO reading manifest template 'MANIFEST.in' 2022-12-24 15:11:22,995 root WARNING warning: no files found matching '*.ini' under directory 'tests' 2022-12-24 15:11:22,996 root INFO writing manifest file 'pgspecial.egg-info/SOURCES.txt' 2022-12-24 15:11:22,996 root INFO Copying pgspecial.egg-info to build/bdist.linux-x86_64/wheel/pgspecial-2.0.1-py3.9.egg-info 2022-12-24 15:11:22,996 root INFO running install_scripts 2022-12-24 15:11:23,012 wheel INFO creating build/bdist.linux-x86_64/wheel/pgspecial-2.0.1.dist-info/WHEEL 2022-12-24 15:11:23,013 wheel INFO creating '/var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1-python3_9/wheel/.tmp-8ww27n63/pgspecial-2.0.1-py3-none-any.whl' and adding 'build/bdist.linux-x86_64/wheel' to it 2022-12-24 15:11:23,013 wheel INFO adding 'pgspecial/__init__.py' 2022-12-24 15:11:23,013 wheel INFO adding 'pgspecial/dbcommands.py' 2022-12-24 15:11:23,013 wheel INFO adding 'pgspecial/iocommands.py' 2022-12-24 15:11:23,013 wheel INFO adding 'pgspecial/main.py' 2022-12-24 15:11:23,014 wheel INFO adding 'pgspecial/namedqueries.py' 2022-12-24 15:11:23,014 wheel INFO adding 'pgspecial/help/__init__.py' 2022-12-24 15:11:23,014 wheel INFO adding 'pgspecial/help/commands.py' 2022-12-24 15:11:23,014 wheel INFO adding 'pgspecial-2.0.1.dist-info/METADATA' 2022-12-24 15:11:23,014 wheel INFO adding 'pgspecial-2.0.1.dist-info/WHEEL' 2022-12-24 15:11:23,015 wheel INFO adding 'pgspecial-2.0.1.dist-info/top_level.txt' 2022-12-24 15:11:23,015 wheel INFO adding 'pgspecial-2.0.1.dist-info/RECORD' 2022-12-24 15:11:23,015 wheel INFO removing build/bdist.linux-x86_64/wheel 2022-12-24 15:11:23,015 gpep517 INFO The backend produced /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1-python3_9/wheel/pgspecial-2.0.1-py3-none-any.whl * Installing pgspecial-2.0.1-py3-none-any.whl to /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1-python3_9/install gpep517 install-wheel --destdir=/var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1-python3_9/install --interpreter=/usr/bin/python3.9 --prefix=/usr --optimize=all /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1-python3_9/wheel/pgspecial-2.0.1-py3-none-any.whl 2022-12-24 15:11:23,098 gpep517 INFO Installing /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1-python3_9/wheel/pgspecial-2.0.1-py3-none-any.whl into /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1-python3_9/install 2022-12-24 15:11:23,141 gpep517 INFO Installation complete * python3_10: running distutils-r1_run_phase distutils-r1_python_compile * Building the wheel for pgspecial-2.0.1 via setuptools.build_meta:__legacy__ gpep517 build-wheel --backend setuptools.build_meta:__legacy__ --output-fd 3 --wheel-dir /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1-python3_10/wheel 2022-12-24 15:11:23,466 gpep517 INFO Building wheel via backend setuptools.build_meta:__legacy__ 2022-12-24 15:11:23,492 root INFO running bdist_wheel 2022-12-24 15:11:23,540 root INFO running build 2022-12-24 15:11:23,540 root INFO running build_py 2022-12-24 15:11:23,543 root INFO creating build 2022-12-24 15:11:23,544 root INFO creating build/lib 2022-12-24 15:11:23,544 root INFO creating build/lib/pgspecial 2022-12-24 15:11:23,544 root INFO copying pgspecial/namedqueries.py -> build/lib/pgspecial 2022-12-24 15:11:23,544 root INFO copying pgspecial/main.py -> build/lib/pgspecial 2022-12-24 15:11:23,544 root INFO copying pgspecial/iocommands.py -> build/lib/pgspecial 2022-12-24 15:11:23,544 root INFO copying pgspecial/dbcommands.py -> build/lib/pgspecial 2022-12-24 15:11:23,544 root INFO copying pgspecial/__init__.py -> build/lib/pgspecial 2022-12-24 15:11:23,545 root INFO creating build/lib/pgspecial/help 2022-12-24 15:11:23,545 root INFO copying pgspecial/help/commands.py -> build/lib/pgspecial/help 2022-12-24 15:11:23,545 root INFO copying pgspecial/help/__init__.py -> build/lib/pgspecial/help 2022-12-24 15:11:23,545 root WARNING warning: build_py: byte-compiling is disabled, skipping. 2022-12-24 15:11:23,552 wheel INFO installing to build/bdist.linux-x86_64/wheel 2022-12-24 15:11:23,552 root INFO running install 2022-12-24 15:11:23,560 root INFO running install_lib 2022-12-24 15:11:23,563 root INFO creating build/bdist.linux-x86_64 2022-12-24 15:11:23,563 root INFO creating build/bdist.linux-x86_64/wheel 2022-12-24 15:11:23,563 root INFO creating build/bdist.linux-x86_64/wheel/pgspecial 2022-12-24 15:11:23,563 root INFO creating build/bdist.linux-x86_64/wheel/pgspecial/help 2022-12-24 15:11:23,564 root INFO copying build/lib/pgspecial/help/__init__.py -> build/bdist.linux-x86_64/wheel/pgspecial/help 2022-12-24 15:11:23,564 root INFO copying build/lib/pgspecial/help/commands.py -> build/bdist.linux-x86_64/wheel/pgspecial/help 2022-12-24 15:11:23,564 root INFO copying build/lib/pgspecial/__init__.py -> build/bdist.linux-x86_64/wheel/pgspecial 2022-12-24 15:11:23,564 root INFO copying build/lib/pgspecial/dbcommands.py -> build/bdist.linux-x86_64/wheel/pgspecial 2022-12-24 15:11:23,564 root INFO copying build/lib/pgspecial/iocommands.py -> build/bdist.linux-x86_64/wheel/pgspecial 2022-12-24 15:11:23,564 root INFO copying build/lib/pgspecial/main.py -> build/bdist.linux-x86_64/wheel/pgspecial 2022-12-24 15:11:23,565 root INFO copying build/lib/pgspecial/namedqueries.py -> build/bdist.linux-x86_64/wheel/pgspecial 2022-12-24 15:11:23,565 root WARNING warning: install_lib: byte-compiling is disabled, skipping. 2022-12-24 15:11:23,565 root INFO running install_egg_info 2022-12-24 15:11:23,574 root INFO running egg_info 2022-12-24 15:11:23,576 root INFO writing pgspecial.egg-info/PKG-INFO 2022-12-24 15:11:23,577 root INFO writing dependency_links to pgspecial.egg-info/dependency_links.txt 2022-12-24 15:11:23,577 root INFO writing requirements to pgspecial.egg-info/requires.txt 2022-12-24 15:11:23,577 root INFO writing top-level names to pgspecial.egg-info/top_level.txt 2022-12-24 15:11:23,590 setuptools_scm.file_finder_git ERROR listing git files failed - pretending there aren't any 2022-12-24 15:11:23,594 root INFO reading manifest file 'pgspecial.egg-info/SOURCES.txt' 2022-12-24 15:11:23,594 root INFO reading manifest template 'MANIFEST.in' 2022-12-24 15:11:23,596 root WARNING warning: no files found matching '*.ini' under directory 'tests' 2022-12-24 15:11:23,596 root INFO writing manifest file 'pgspecial.egg-info/SOURCES.txt' 2022-12-24 15:11:23,596 root INFO Copying pgspecial.egg-info to build/bdist.linux-x86_64/wheel/pgspecial-2.0.1-py3.10.egg-info 2022-12-24 15:11:23,597 root INFO running install_scripts 2022-12-24 15:11:23,614 wheel INFO creating build/bdist.linux-x86_64/wheel/pgspecial-2.0.1.dist-info/WHEEL 2022-12-24 15:11:23,615 wheel INFO creating '/var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1-python3_10/wheel/.tmp-z27wexyk/pgspecial-2.0.1-py3-none-any.whl' and adding 'build/bdist.linux-x86_64/wheel' to it 2022-12-24 15:11:23,615 wheel INFO adding 'pgspecial/__init__.py' 2022-12-24 15:11:23,615 wheel INFO adding 'pgspecial/dbcommands.py' 2022-12-24 15:11:23,616 wheel INFO adding 'pgspecial/iocommands.py' 2022-12-24 15:11:23,616 wheel INFO adding 'pgspecial/main.py' 2022-12-24 15:11:23,616 wheel INFO adding 'pgspecial/namedqueries.py' 2022-12-24 15:11:23,616 wheel INFO adding 'pgspecial/help/__init__.py' 2022-12-24 15:11:23,616 wheel INFO adding 'pgspecial/help/commands.py' 2022-12-24 15:11:23,617 wheel INFO adding 'pgspecial-2.0.1.dist-info/METADATA' 2022-12-24 15:11:23,617 wheel INFO adding 'pgspecial-2.0.1.dist-info/WHEEL' 2022-12-24 15:11:23,617 wheel INFO adding 'pgspecial-2.0.1.dist-info/top_level.txt' 2022-12-24 15:11:23,617 wheel INFO adding 'pgspecial-2.0.1.dist-info/RECORD' 2022-12-24 15:11:23,617 wheel INFO removing build/bdist.linux-x86_64/wheel 2022-12-24 15:11:23,618 gpep517 INFO The backend produced /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1-python3_10/wheel/pgspecial-2.0.1-py3-none-any.whl * Installing pgspecial-2.0.1-py3-none-any.whl to /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1-python3_10/install gpep517 install-wheel --destdir=/var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1-python3_10/install --interpreter=/usr/bin/python3.10 --prefix=/usr --optimize=all /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1-python3_10/wheel/pgspecial-2.0.1-py3-none-any.whl 2022-12-24 15:11:23,708 gpep517 INFO Installing /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1-python3_10/wheel/pgspecial-2.0.1-py3-none-any.whl into /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1-python3_10/install 2022-12-24 15:11:23,751 gpep517 INFO Installation complete >>> Source compiled. >>> Test phase: dev-python/pgspecial-2.0.1 The files belonging to this database system will be owned by user "portage". This user must also own the server process. The database cluster will be initialized with this locale configuration: provider: libc LC_COLLATE: C LC_CTYPE: C.UTF8 LC_MESSAGES: C LC_MONETARY: C.UTF8 LC_NUMERIC: C.UTF8 LC_TIME: C.UTF-8 The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are disabled. creating directory /var/tmp/portage/dev-python/pgspecial-2.0.1/temp/pgsql ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... posix selecting default max_connections ... 100 selecting default shared_buffers ... 128MB selecting default time zone ... CET creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok syncing data to disk ... ok initdb: warning: enabling "trust" authentication for local connections initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. Success. You can now start the database server using: pg_ctl -D /var/tmp/portage/dev-python/pgspecial-2.0.1/temp/pgsql -l logfile start waiting for server to start....2022-12-24 15:11:24.445 CET [32] LOG: starting PostgreSQL 15.1 on x86_64-pc-linux-gnu, compiled by x86_64-pc-linux-gnu-gcc (Gentoo 12.2.1_p20221210 p4) 12.2.1 20221210, 64-bit 2022-12-24 15:11:24.445 CET [32] LOG: listening on IPv4 address "127.0.0.1", port 5432 2022-12-24 15:11:24.445 CET [32] LOG: listening on Unix socket "/var/tmp/portage/dev-python/pgspecial-2.0.1/temp/.s.PGSQL.5432" 2022-12-24 15:11:24.446 CET [35] LOG: database system was shut down at 2022-12-24 15:11:24 CET 2022-12-24 15:11:24.448 CET [32] LOG: database system is ready to accept connections done server started ALTER ROLE * python3_8: running distutils-r1_run_phase python_test python3.8 -m pytest -vv -ra -l -Wdefault --color=no -o console_output_style=count -p no:cov -p no:flake8 -p no:flakes -p no:pylint -p no:markdown -p no:sugar -p no:xvfb -p no:tavern 2022-12-24 15:11:24.905 CET [33] LOG: checkpoint starting: immediate force wait 2022-12-24 15:11:24.915 CET [33] LOG: checkpoint complete: wrote 902 buffers (5.5%); 1 WAL file(s) added, 0 removed, 0 recycled; write=0.006 s, sync=0.001 s, total=0.011 s; sync files=256, longest=0.001 s, average=0.000 s; distance=8017 kB, estimate=8017 kB ============================= test session starts ============================== platform linux -- Python 3.8.16, pytest-7.2.0, pluggy-1.0.0 -- /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1-python3_8/install/usr/bin/python3.8 cachedir: .pytest_cache rootdir: /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1, configfile: pyproject.toml, testpaths: tests collecting ... collected 71 items tests/test_internal.py::test_get_watch_command[SELECT * FROM foo \\watch-SELECT * FROM foo-2] PASSED [ 1/71] tests/test_internal.py::test_get_watch_command[SELECT * FROM foo \\watch 123-SELECT * FROM foo-123] PASSED [ 2/71] tests/test_internal.py::test_get_watch_command[SELECT *\nFROM foo \\watch 1-SELECT *\nFROM foo-1] PASSED [ 3/71] tests/test_internal.py::test_get_watch_command[SELECT * FROM foo \\watch 1 -SELECT * FROM foo-1] PASSED [ 4/71] tests/test_internal.py::test_get_watch_command[SELECT * FROM foo; \\watch 1 ; -SELECT * FROM foo;-1] PASSED [ 5/71] tests/test_internal.py::test_get_watch_command[SELECT * FROM foo;\\watch 1;-SELECT * FROM foo;-1] PASSED [ 6/71] tests/test_internal.py::test_plain_editor_commands_detected PASSED [ 7/71] tests/test_internal.py::test_edit_view_command_detected PASSED [ 8/71] tests/test_internal.py::test_subst_favorite_query_args PASSED [ 9/71] tests/test_internal.py::test_subst_favorite_query_args_bad_arg_positional PASSED [10/71] tests/test_internal.py::test_subst_favorite_query_args_missing_arg[missing positional argument] PASSED [11/71] tests/test_internal.py::test_subst_favorite_query_args_missing_arg[missing aggregation arguments] PASSED [12/71] tests/test_internal.py::test_subst_favorite_query_args_missing_arg[missing aggregation arguments with positional] PASSED [13/71] tests/test_internal.py::test_subst_favorite_query_args_missing_arg[missing positional argument after aggregation] PASSED [14/71] tests/test_internal.py::test_subst_favorite_query_args_aggregation[raw aggregation] PASSED [15/71] tests/test_internal.py::test_subst_favorite_query_args_aggregation[string aggregation] PASSED [16/71] tests/test_internal.py::test_subst_favorite_query_args_aggregation[positional and aggregation] PASSED [17/71] tests/test_named_queries.py::test_save_named_queries PASSED [18/71] tests/test_named_queries.py::test_delete_named_queries PASSED [19/71] tests/test_named_queries.py::test_print_named_queries PASSED [20/71] tests/test_specials.py::test_slash_d 2022-12-24 15:11:25.064 CET [96] ERROR: database "_test_db" already exists 2022-12-24 15:11:25.064 CET [96] STATEMENT: CREATE DATABASE _test_db PASSED [21/71] tests/test_specials.py::test_slash_d_verbose PASSED [22/71] tests/test_specials.py::test_slash_d_table_1 PASSED [23/71] tests/test_specials.py::test_slash_d_table_2 PASSED [24/71] tests/test_specials.py::test_slash_d_test_generated_default PASSED [25/71] tests/test_specials.py::test_slash_d_table_verbose_1 PASSED [26/71] tests/test_specials.py::test_slash_d_table_verbose_2 PASSED [27/71] tests/test_specials.py::test_slash_d_table_with_exclusion PASSED [28/71] tests/test_specials.py::test_slash_d_table_2_in_schema PASSED [29/71] tests/test_specials.py::test_slash_dn FAILED [30/71] tests/test_specials.py::test_slash_dp 2022-12-24 15:11:25.133 CET [97] ERROR: operator is not unique: unknown || "char" at character 1020 2022-12-24 15:11:25.133 CET [97] HINT: Could not choose a best candidate operator. You might need to add explicit type casts. 2022-12-24 15:11:25.133 CET [97] STATEMENT: SELECT n.nspname as "Schema", c.relname as "Name", CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'm' THEN 'materialized view' WHEN 'S' THEN 'sequence' WHEN 'f' THEN 'foreign table' WHEN 'p' THEN 'partitioned table' END as "Type", pg_catalog.array_to_string(c.relacl, E' ') AS "Access privileges", pg_catalog.array_to_string(ARRAY( SELECT attname || E': ' || pg_catalog.array_to_string(attacl, E' ') FROM pg_catalog.pg_attribute a WHERE attrelid = c.oid AND NOT attisdropped AND attacl IS NOT NULL ), E' ') AS "Column privileges", pg_catalog.array_to_string(ARRAY( SELECT polname || CASE WHEN NOT polpermissive THEN E' (RESTRICTIVE)' ELSE '' END || CASE WHEN polcmd != '*' THEN E' (' || polcmd || E'):' ELSE E':' END || CASE WHEN polqual IS NOT NULL THEN E' (u): ' || pg_catalog.pg_get_expr(polqual, polrelid) ELSE E'' END || CASE WHEN polwithcheck IS NOT NULL THEN E' (c): ' || pg_catalog.pg_get_expr(polwithcheck, polrelid) ELSE E'' END || CASE WHEN polroles <> '{0}' THEN E' to: ' || pg_catalog.array_to_string( ARRAY( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = ANY (polroles) ORDER BY 1 ), E', ') ELSE E'' END FROM pg_catalog.pg_policy pol WHERE polrelid = c.oid), E' ') AS "Policies" FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('r','v','m','S','f','p') AND pg_catalog.pg_table_is_visible(c.oid) AND n.nspname !~ '^pg_' ORDER BY 1, 2 FAILED [31/71] tests/test_specials.py::test_slash_dp_pattern_table 2022-12-24 15:11:25.172 CET [97] ERROR: operator is not unique: unknown || "char" at character 1020 2022-12-24 15:11:25.172 CET [97] HINT: Could not choose a best candidate operator. You might need to add explicit type casts. 2022-12-24 15:11:25.172 CET [97] STATEMENT: SELECT n.nspname as "Schema", c.relname as "Name", CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'm' THEN 'materialized view' WHEN 'S' THEN 'sequence' WHEN 'f' THEN 'foreign table' WHEN 'p' THEN 'partitioned table' END as "Type", pg_catalog.array_to_string(c.relacl, E' ') AS "Access privileges", pg_catalog.array_to_string(ARRAY( SELECT attname || E': ' || pg_catalog.array_to_string(attacl, E' ') FROM pg_catalog.pg_attribute a WHERE attrelid = c.oid AND NOT attisdropped AND attacl IS NOT NULL ), E' ') AS "Column privileges", pg_catalog.array_to_string(ARRAY( SELECT polname || CASE WHEN NOT polpermissive THEN E' (RESTRICTIVE)' ELSE '' END || CASE WHEN polcmd != '*' THEN E' (' || polcmd || E'):' ELSE E':' END || CASE WHEN polqual IS NOT NULL THEN E' (u): ' || pg_catalog.pg_get_expr(polqual, polrelid) ELSE E'' END || CASE WHEN polwithcheck IS NOT NULL THEN E' (c): ' || pg_catalog.pg_get_expr(polwithcheck, polrelid) ELSE E'' END || CASE WHEN polroles <> '{0}' THEN E' to: ' || pg_catalog.array_to_string( ARRAY( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = ANY (polroles) ORDER BY 1 ), E', ') ELSE E'' END FROM pg_catalog.pg_policy pol WHERE polrelid = c.oid), E' ') AS "Policies" FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('r','v','m','S','f','p') AND c.relname OPERATOR(pg_catalog.~) $1 COLLATE pg_catalog.default AND n.nspname !~ '^pg_' ORDER BY 1, 2 FAILED [32/71] tests/test_specials.py::test_slash_dp_pattern_schema 2022-12-24 15:11:25.211 CET [97] ERROR: operator is not unique: unknown || "char" at character 1020 2022-12-24 15:11:25.211 CET [97] HINT: Could not choose a best candidate operator. You might need to add explicit type casts. 2022-12-24 15:11:25.211 CET [97] STATEMENT: SELECT n.nspname as "Schema", c.relname as "Name", CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'm' THEN 'materialized view' WHEN 'S' THEN 'sequence' WHEN 'f' THEN 'foreign table' WHEN 'p' THEN 'partitioned table' END as "Type", pg_catalog.array_to_string(c.relacl, E' ') AS "Access privileges", pg_catalog.array_to_string(ARRAY( SELECT attname || E': ' || pg_catalog.array_to_string(attacl, E' ') FROM pg_catalog.pg_attribute a WHERE attrelid = c.oid AND NOT attisdropped AND attacl IS NOT NULL ), E' ') AS "Column privileges", pg_catalog.array_to_string(ARRAY( SELECT polname || CASE WHEN NOT polpermissive THEN E' (RESTRICTIVE)' ELSE '' END || CASE WHEN polcmd != '*' THEN E' (' || polcmd || E'):' ELSE E':' END || CASE WHEN polqual IS NOT NULL THEN E' (u): ' || pg_catalog.pg_get_expr(polqual, polrelid) ELSE E'' END || CASE WHEN polwithcheck IS NOT NULL THEN E' (c): ' || pg_catalog.pg_get_expr(polwithcheck, polrelid) ELSE E'' END || CASE WHEN polroles <> '{0}' THEN E' to: ' || pg_catalog.array_to_string( ARRAY( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = ANY (polroles) ORDER BY 1 ), E', ') ELSE E'' END FROM pg_catalog.pg_policy pol WHERE polrelid = c.oid), E' ') AS "Policies" FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('r','v','m','S','f','p') AND c.relname OPERATOR(pg_catalog.~) $1 COLLATE pg_catalog.default AND n.nspname OPERATOR(pg_catalog.~) $2 COLLATE pg_catalog.default AND n.nspname !~ '^pg_' ORDER BY 1, 2 FAILED [33/71] tests/test_specials.py::test_slash_dp_pattern_alias 2022-12-24 15:11:25.258 CET [97] ERROR: operator is not unique: unknown || "char" at character 1020 2022-12-24 15:11:25.258 CET [97] HINT: Could not choose a best candidate operator. You might need to add explicit type casts. 2022-12-24 15:11:25.258 CET [97] STATEMENT: SELECT n.nspname as "Schema", c.relname as "Name", CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'm' THEN 'materialized view' WHEN 'S' THEN 'sequence' WHEN 'f' THEN 'foreign table' WHEN 'p' THEN 'partitioned table' END as "Type", pg_catalog.array_to_string(c.relacl, E' ') AS "Access privileges", pg_catalog.array_to_string(ARRAY( SELECT attname || E': ' || pg_catalog.array_to_string(attacl, E' ') FROM pg_catalog.pg_attribute a WHERE attrelid = c.oid AND NOT attisdropped AND attacl IS NOT NULL ), E' ') AS "Column privileges", pg_catalog.array_to_string(ARRAY( SELECT polname || CASE WHEN NOT polpermissive THEN E' (RESTRICTIVE)' ELSE '' END || CASE WHEN polcmd != '*' THEN E' (' || polcmd || E'):' ELSE E':' END || CASE WHEN polqual IS NOT NULL THEN E' (u): ' || pg_catalog.pg_get_expr(polqual, polrelid) ELSE E'' END || CASE WHEN polwithcheck IS NOT NULL THEN E' (c): ' || pg_catalog.pg_get_expr(polwithcheck, polrelid) ELSE E'' END || CASE WHEN polroles <> '{0}' THEN E' to: ' || pg_catalog.array_to_string( ARRAY( SELECT rolname FROM pg_catalog.pg_roles WHERE oid = ANY (polroles) ORDER BY 1 ), E', ') ELSE E'' END FROM pg_catalog.pg_policy pol WHERE polrelid = c.oid), E' ') AS "Policies" FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN ('r','v','m','S','f','p') AND c.relname OPERATOR(pg_catalog.~) $1 COLLATE pg_catalog.default AND n.nspname !~ '^pg_' ORDER BY 1, 2 FAILED [34/71] tests/test_specials.py::test_slash_ddp PASSED [35/71] tests/test_specials.py::test_slash_ddp_pattern PASSED [36/71] tests/test_specials.py::test_slash_dt PASSED [37/71] tests/test_specials.py::test_slash_dt_verbose PASSED [38/71] tests/test_specials.py::test_slash_dv PASSED [39/71] tests/test_specials.py::test_slash_dv_verbose PASSED [40/71] tests/test_specials.py::test_slash_dm PASSED [41/71] tests/test_specials.py::test_slash_dm_verbose PASSED [42/71] tests/test_specials.py::test_slash_ds PASSED [43/71] tests/test_specials.py::test_slash_ds_verbose PASSED [44/71] tests/test_specials.py::test_slash_di PASSED [45/71] tests/test_specials.py::test_slash_di_verbose PASSED [46/71] tests/test_specials.py::test_slash_dx PASSED [47/71] tests/test_specials.py::test_slash_dx_verbose PASSED [48/71] tests/test_specials.py::test_slash_dT PASSED [49/71] tests/test_specials.py::test_slash_dD PASSED [50/71] tests/test_specials.py::test_slash_dD_verbose PASSED [51/71] tests/test_specials.py::test_slash_dF PASSED [52/71] tests/test_specials.py::test_slash_dF_verbose PASSED [53/71] tests/test_specials.py::test_slash_db PASSED [54/71] tests/test_specials.py::test_slash_db_name PASSED [55/71] tests/test_specials.py::test_slash_df PASSED [56/71] tests/test_specials.py::test_slash_h PASSED [57/71] tests/test_specials.py::test_slash_h_command PASSED [58/71] tests/test_specials.py::test_slash_h_alias PASSED [59/71] tests/test_specials.py::test_slash_copy_to_tsv PASSED [60/71] tests/test_specials.py::test_slash_copy_throws_error_without_TO_or_FROM PASSED [61/71] tests/test_specials.py::test_slash_copy_to_stdout PASSED [62/71] tests/test_specials.py::test_slash_copy_to_csv PASSED [63/71] tests/test_specials.py::test_slash_copy_from_csv PASSED [64/71] tests/test_specials.py::test_slash_sf PASSED [65/71] tests/test_specials.py::test_slash_sf_unknown 2022-12-24 15:11:25.398 CET [97] ERROR: function "non_existing" does not exist 2022-12-24 15:11:25.398 CET [97] CONTEXT: unnamed portal parameter $1 = '...' 2022-12-24 15:11:25.398 CET [97] STATEMENT: SELECT $1::pg_catalog.regproc::pg_catalog.oid PASSED [66/71] tests/test_specials.py::test_slash_sf_parens PASSED [67/71] tests/test_specials.py::test_slash_sf_verbose PASSED [68/71] tests/test_specials.py::test_slash_dE 2022-12-24 15:11:25.434 CET [33] LOG: checkpoint starting: immediate force wait 2022-12-24 15:11:25.436 CET [33] LOG: checkpoint complete: wrote 148 buffers (0.9%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.003 s, sync=0.001 s, total=0.003 s; sync files=89, longest=0.001 s, average=0.000 s; distance=4539 kB, estimate=7669 kB PASSED [69/71] tests/test_specials.py::test_slash_dE_with_pattern 2022-12-24 15:11:25.475 CET [33] LOG: checkpoint starting: immediate force wait 2022-12-24 15:11:25.476 CET [33] LOG: checkpoint complete: wrote 52 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.001 s; sync files=39, longest=0.001 s, average=0.000 s; distance=4211 kB, estimate=7324 kB PASSED [70/71] tests/test_specials.py::test_slash_dE_verbose 2022-12-24 15:11:25.512 CET [33] LOG: checkpoint starting: immediate force wait 2022-12-24 15:11:25.514 CET [33] LOG: checkpoint complete: wrote 50 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.001 s, total=0.002 s; sync files=39, longest=0.001 s, average=0.000 s; distance=4208 kB, estimate=7012 kB PASSED [71/71] =================================== FAILURES =================================== ________________________________ test_slash_dn _________________________________ executor = .query_runner at 0x7fbfeed500d0> @dbtest def test_slash_dn(executor): """List all schemas.""" results = executor(r"\dn") title = None rows = [ ("public", POSTGRES_USER), ("schema1", POSTGRES_USER), ("schema2", POSTGRES_USER), ("schema3", POSTGRES_USER), ] headers = ["Name", "Owner"] status = "SELECT %s" % len(rows) expected = [title, rows, headers, status] > assert results == expected E AssertionError: assert [None, [('public', 'pg_database_owner'), ('schema1', 'postgres'), ('schema2', 'postgres'), ('schema3', 'postgres')], ['Name', 'Owner'], 'SELECT 4'] == [None, [('public', 'postgres'), ('schema1', 'postgres'), ('schema2', 'postgres'), ('schema3', 'postgres')], ['Name', 'Owner'], 'SELECT 4'] E At index 1 diff: [('public', 'pg_database_owner'), ('schema1', 'postgres'), ('schema2', 'postgres'), ('schema3', 'postgres')] != [('public', 'postgres'), ('schema1', 'postgres'), ('schema2', 'postgres'), ('schema3', 'postgres')] E Full diff: E [ E None, E - [('public', 'postgres'), E + [('public', 'pg_database_owner'), E ('schema1', 'postgres'), E ('schema2', 'postgres'), E ('schema3', 'postgres')], E ['Name', 'Owner'], E 'SELECT 4', E ] executor = .query_runner at 0x7fbfeed500d0> expected = [None, [('public', 'postgres'), ('schema1', 'postgres'), ('schema2', 'postgres'), ('schema3', 'postgres')], ['Name', 'Owner'], 'SELECT 4'] headers = ['Name', 'Owner'] results = [None, [('public', 'pg_database_owner'), ('schema1', 'postgres'), ('schema2', 'postgres'), ('schema3', 'postgres')], ['Name', 'Owner'], 'SELECT 4'] rows = [('public', 'postgres'), ('schema1', 'postgres'), ('schema2', 'postgres'), ('schema3', 'postgres')] status = 'SELECT 4' title = None tests/test_specials.py:212: AssertionError ________________________________ test_slash_dp _________________________________ executor = .query_runner at 0x7fbfeed50040> @dbtest def test_slash_dp(executor): """List all schemas.""" > results = executor(r"\dp") executor = .query_runner at 0x7fbfeed50040> tests/test_specials.py:218: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ tests/conftest.py:29: in query_runner for title, rows, headers, status in pgspecial.execute(cur=cur, sql=sql): cur = pgspecial = results = [] sql = '\\dp' pgspecial/main.py:117: in execute return special_cmd.handler(cur=cur, pattern=pattern, verbose=verbose) command = '\\dp' commands = {'\\!': SpecialCommand(handler=, syntax='\\! [command]', description='Pass commands to shell.', arg_type=1, hidden=False, case_sensitive=True), '\\?': SpecialCommand(handler=>, syntax='\\?', description='Show Commands.', arg_type=1, hidden=False, case_sensitive=True), '\\copy': SpecialCommand(handler=, syntax='\\copy [tablename] to/from [filename]', description='Copy data between a file and a table.', arg_type=1, hidden=False, case_sensitive=True), '\\d': SpecialCommand(handler=, syntax='\\d[+] [pattern]', description='List or describe tables, views and sequences.', arg_type=1, hidden=False, case_sensitive=True), '\\dD': SpecialCommand(handler=, syntax='\\dD[+] [pattern]', description='List or describe domains.', arg_type=1, hidden=False, case_sensitive=True), '\\dE': SpecialCommand(handler=, syntax='\\dE[+] [pattern]', description='List foreign tables.', arg_type=1, hidden=False, case_sensitive=True), '\\dF': SpecialCommand(handler=, syntax='\\dF[+] [pattern]', description='List text search configurations.', arg_type=1, hidden=False, case_sensitive=True), '\\dT': SpecialCommand(handler=, syntax='\\dT[S+] [pattern]', description='List data types', arg_type=1, hidden=False, case_sensitive=True), '\\db': SpecialCommand(handler=, syntax='\\db[+] [pattern]', description='List tablespaces.', arg_type=1, hidden=False, case_sensitive=True), '\\ddp': SpecialCommand(handler=, syntax='\\ddp [pattern]', description='Lists default access privilege settings.', arg_type=1, hidden=False, case_sensitive=True), '\\df': SpecialCommand(handler=, syntax='\\df[+] [pattern]', description='List functions.', arg_type=1, hidden=False, case_sensitive=True), '\\di': SpecialCommand(handler=, syntax='\\di[+] [pattern]', description='List indexes.', arg_type=1, hidden=False, case_sensitive=True), '\\dm': SpecialCommand(handler=, syntax='\\dm[+] [pattern]', description='List materialized views.', arg_type=1, hidden=False, case_sensitive=True), '\\dn': SpecialCommand(handler=, syntax='\\dn[+] [pattern]', description='List schemas.', arg_type=1, hidden=False, case_sensitive=True), '\\do': SpecialCommand(handler=, syntax='\\do[S] [pattern]', description='List operators.', arg_type=0, hidden=True, case_sensitive=True), '\\dp': SpecialCommand(handler=, syntax='\\dp [pattern]', description='List roles.', arg_type=1, hidden=False, case_sensitive=True), '\\ds': SpecialCommand(handler=, syntax='\\ds[+] [pattern]', description='List sequences.', arg_type=1, hidden=False, case_sensitive=True), '\\dt': SpecialCommand(handler=, syntax='\\dt[+] [pattern]', description='List tables.', arg_type=1, hidden=False, case_sensitive=True), '\\du': SpecialCommand(handler=, syntax='\\du[+] [pattern]', description='List roles.', arg_type=1, hidden=False, case_sensitive=True), '\\dv': SpecialCommand(handler=, syntax='\\dv[+] [pattern]', description='List views.', arg_type=1, hidden=False, case_sensitive=True), '\\dx': SpecialCommand(handler=, syntax='\\dx[+] [pattern]', description='List extensions.', arg_type=1, hidden=False, case_sensitive=True), '\\e': SpecialCommand(handler=, syntax='\\e [file]', description='Edit the query with external editor.', arg_type=0, hidden=False, case_sensitive=True), '\\ef': SpecialCommand(handler=, syntax='\\ef [funcname [line]]', description='Edit the contents of the query buffer.', arg_type=0, hidden=True, case_sensitive=True), '\\ev': SpecialCommand(handler=, syntax='\\ev [viewname [line]]', description='Edit the contents of the query buffer.', arg_type=0, hidden=True, case_sensitive=True), '\\h': SpecialCommand(handler=>, syntax='\\h', description='Show SQL syntax and help.', arg_type=1, hidden=False, case_sensitive=True), '\\l': SpecialCommand(handler=, syntax='\\l[+] [pattern]', description='List databases.', arg_type=1, hidden=False, case_sensitive=True), '\\list': SpecialCommand(handler=, syntax='\\l[+] [pattern]', description='List databases.', arg_type=1, hidden=True, case_sensitive=True), '\\n': SpecialCommand(handler=, syntax='\\n[+] [name] [param1 param2 ...]', description='List or execute named queries.', arg_type=1, hidden=False, case_sensitive=True), '\\nd': SpecialCommand(handler=, syntax='\\nd [name]', description='Delete a named query.', arg_type=1, hidden=False, case_sensitive=True), '\\np': SpecialCommand(handler=, syntax='\\np name_pattern', description='Print a named query.', arg_type=1, hidden=False, case_sensitive=True), '\\ns': SpecialCommand(handler=, syntax='\\ns name query', description='Save a named query.', arg_type=1, hidden=False, case_sensitive=True), '\\pager': SpecialCommand(handler=>, syntax='\\pager [command]', description='Set PAGER. Print the query results via PAGER.', arg_type=1, hidden=False, case_sensitive=True), '\\pset': SpecialCommand(handler=>, syntax='\\pset [key] [value]', description='A limited version of traditional \\pset', arg_type=1, hidden=False, case_sensitive=True), '\\sf': SpecialCommand(handler=, syntax='\\sf[+] FUNCNAME', description="Show a function's definition.", arg_type=1, hidden=False, case_sensitive=True), '\\timing': SpecialCommand(handler=>, syntax='\\timing', description='Toggle timing of commands.', arg_type=0, hidden=False, case_sensitive=True), '\\watch': SpecialCommand(handler=.placeholder at 0x7fbfeeef15e0>, syntax='\\watch [sec=2]', description='Execute query every `sec` seconds.', arg_type=0, hidden=False, case_sensitive=True), '\\x': SpecialCommand(handler=>, syntax='\\x', description='Toggle expanded output.', arg_type=1, hidden=False, case_sensitive=True), '\\z': SpecialCommand(handler=, syntax='\\dp [pattern]', description='List roles.', arg_type=1, hidden=True, case_sensitive=True), 'describe': SpecialCommand(handler=, syntax='DESCRIBE [pattern]', description='', arg_type=1, hidden=True, case_sensitive=False)} cur = pattern = '' self = special_cmd = SpecialCommand(handler=, syntax='\\dp [pattern]', description='List roles.', arg_type=1, hidden=False, case_sensitive=True) sql = '\\dp' verbose = False pgspecial/dbcommands.py:198: in list_privileges cur.execute(sql, params) cur = params = {} pattern = ' AND pg_catalog.pg_table_is_visible(c.oid) ' sql = ('\n' ' SELECT n.nspname as "Schema",\n' ' c.relname as "Name",\n' " CASE c.relkind WHEN 'r' THEN 'table'\n" " WHEN 'v' THEN 'view'\n" " WHEN 'm' THEN 'materialized view'\n" " WHEN 'S' THEN 'sequence'\n" " WHEN 'f' THEN 'foreign table'\n" " WHEN 'p' THEN 'partitioned table' END as " '"Type",\n' " pg_catalog.array_to_string(c.relacl, E'\n" '\') AS "Access privileges",\n' ' pg_catalog.array_to_string(ARRAY(\n' " SELECT attname || E':\n" " ' || pg_catalog.array_to_string(attacl, E'\n" " ')\n" ' FROM pg_catalog.pg_attribute a\n' ' WHERE attrelid = c.oid AND NOT attisdropped AND attacl IS NOT ' 'NULL\n' " ), E'\n" '\') AS "Column privileges",\n' ' pg_catalog.array_to_string(ARRAY(\n' ' SELECT polname\n' ' || CASE WHEN NOT polpermissive THEN\n' " E' (RESTRICTIVE)'\n" " ELSE '' END\n" " || CASE WHEN polcmd != '*' THEN\n" " E' (' || polcmd || E'):'\n" " ELSE E':'\n" ' END\n' ' || CASE WHEN polqual IS NOT NULL THEN\n' " E'\n" " (u): ' || pg_catalog.pg_get_expr(polqual, polrelid)\n" " ELSE E''\n" ' END\n' ' || CASE WHEN polwithcheck IS NOT NULL THEN\n' " E'\n" " (c): ' || pg_catalog.pg_get_expr(polwithcheck, polrelid)\n" " ELSE E''\n" " END || CASE WHEN polroles <> '{0}' THEN\n" " E'\n" " to: ' || pg_catalog.array_to_string(\n" ' ARRAY(\n' ' SELECT rolname\n' ' FROM pg_catalog.pg_roles\n' ' WHERE oid = ANY (polroles)\n' ' ORDER BY 1\n' " ), E', ')\n" " ELSE E''\n" ' END\n' ' FROM pg_catalog.pg_policy pol\n' " WHERE polrelid = c.oid), E'\n" "')\n" ' AS "Policies"\n' ' FROM pg_catalog.pg_class c\n' ' LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n' ' \n' " WHERE c.relkind IN ('r','v','m','S','f','p')\n" ' AND pg_catalog.pg_table_is_visible(c.oid) \n' " AND n.nspname !~ '^pg_'\n" ' ORDER BY 1, 2') verbose = False where_clause = ('\n' " WHERE c.relkind IN ('r','v','m','S','f','p')\n" ' AND pg_catalog.pg_table_is_visible(c.oid) \n' " AND n.nspname !~ '^pg_'\n" ' ') _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = query = '\n SELECT n.nspname as "Schema",\n c.relname as "Name",\n CASE c.relkind WHEN \'r\' THEN \'t...\'p\')\n AND pg_catalog.pg_table_is_visible(c.oid) \n AND n.nspname !~ \'^pg_\'\n ORDER BY 1, 2' params = {} def execute( self: _Self, query: Query, params: Optional[Params] = None, *, prepare: Optional[bool] = None, binary: Optional[bool] = None, ) -> _Self: """ Execute a query or command to the database. """ try: with self._conn.lock: self._conn.wait( self._execute_gen(query, params, prepare=prepare, binary=binary) ) except e.Error as ex: > raise ex.with_traceback(None) E psycopg.errors.AmbiguousFunction: operator is not unique: unknown || "char" E LINE 26: E' (' || polcmd || E'):' E ^ E HINT: Could not choose a best candidate operator. You might need to add explicit type casts. binary = None params = {} prepare = None query = ('\n' ' SELECT n.nspname as "Schema",\n' ' c.relname as "Name",\n' " CASE c.relkind WHEN 'r' THEN 'table'\n" " WHEN 'v' THEN 'view'\n" " WHEN 'm' THEN 'materialized view'\n" " WHEN 'S' THEN 'sequence'\n" " WHEN 'f' THEN 'foreign table'\n" " WHEN 'p' THEN 'partitioned table' END as " '"Type",\n' " pg_catalog.array_to_string(c.relacl, E'\n" '\') AS "Access privileges",\n' ' pg_catalog.array_to_string(ARRAY(\n' " SELECT attname || E':\n" " ' || pg_catalog.array_to_string(attacl, E'\n" " ')\n" ' FROM pg_catalog.pg_attribute a\n' ' WHERE attrelid = c.oid AND NOT attisdropped AND attacl IS NOT ' 'NULL\n' " ), E'\n" '\') AS "Column privileges",\n' ' pg_catalog.array_to_string(ARRAY(\n' ' SELECT polname\n' ' || CASE WHEN NOT polpermissive THEN\n' " E' (RESTRICTIVE)'\n" " ELSE '' END\n" " || CASE WHEN polcmd != '*' THEN\n" " E' (' || polcmd || E'):'\n" " ELSE E':'\n" ' END\n' ' || CASE WHEN polqual IS NOT NULL THEN\n' " E'\n" " (u): ' || pg_catalog.pg_get_expr(polqual, polrelid)\n" " ELSE E''\n" ' END\n' ' || CASE WHEN polwithcheck IS NOT NULL THEN\n' " E'\n" " (c): ' || pg_catalog.pg_get_expr(polwithcheck, polrelid)\n" " ELSE E''\n" " END || CASE WHEN polroles <> '{0}' THEN\n" " E'\n" " to: ' || pg_catalog.array_to_string(\n" ' ARRAY(\n' ' SELECT rolname\n' ' FROM pg_catalog.pg_roles\n' ' WHERE oid = ANY (polroles)\n' ' ORDER BY 1\n' " ), E', ')\n" " ELSE E''\n" ' END\n' ' FROM pg_catalog.pg_policy pol\n' " WHERE polrelid = c.oid), E'\n" "')\n" ' AS "Policies"\n' ' FROM pg_catalog.pg_class c\n' ' LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n' ' \n' " WHERE c.relkind IN ('r','v','m','S','f','p')\n" ' AND pg_catalog.pg_table_is_visible(c.oid) \n' " AND n.nspname !~ '^pg_'\n" ' ORDER BY 1, 2') self = /usr/lib/python3.8/site-packages/psycopg/cursor.py:728: AmbiguousFunction _________________________ test_slash_dp_pattern_table __________________________ executor = .query_runner at 0x7fbfeea81e50> @dbtest def test_slash_dp_pattern_table(executor): """List all schemas.""" > results = executor(r"\dp i*2") executor = .query_runner at 0x7fbfeea81e50> tests/test_specials.py:247: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ tests/conftest.py:29: in query_runner for title, rows, headers, status in pgspecial.execute(cur=cur, sql=sql): cur = pgspecial = results = [] sql = '\\dp i*2' pgspecial/main.py:117: in execute return special_cmd.handler(cur=cur, pattern=pattern, verbose=verbose) command = '\\dp' commands = {'\\!': SpecialCommand(handler=, syntax='\\! [command]', description='Pass commands to shell.', arg_type=1, hidden=False, case_sensitive=True), '\\?': SpecialCommand(handler=>, syntax='\\?', description='Show Commands.', arg_type=1, hidden=False, case_sensitive=True), '\\copy': SpecialCommand(handler=, syntax='\\copy [tablename] to/from [filename]', description='Copy data between a file and a table.', arg_type=1, hidden=False, case_sensitive=True), '\\d': SpecialCommand(handler=, syntax='\\d[+] [pattern]', description='List or describe tables, views and sequences.', arg_type=1, hidden=False, case_sensitive=True), '\\dD': SpecialCommand(handler=, syntax='\\dD[+] [pattern]', description='List or describe domains.', arg_type=1, hidden=False, case_sensitive=True), '\\dE': SpecialCommand(handler=, syntax='\\dE[+] [pattern]', description='List foreign tables.', arg_type=1, hidden=False, case_sensitive=True), '\\dF': SpecialCommand(handler=, syntax='\\dF[+] [pattern]', description='List text search configurations.', arg_type=1, hidden=False, case_sensitive=True), '\\dT': SpecialCommand(handler=, syntax='\\dT[S+] [pattern]', description='List data types', arg_type=1, hidden=False, case_sensitive=True), '\\db': SpecialCommand(handler=, syntax='\\db[+] [pattern]', description='List tablespaces.', arg_type=1, hidden=False, case_sensitive=True), '\\ddp': SpecialCommand(handler=, syntax='\\ddp [pattern]', description='Lists default access privilege settings.', arg_type=1, hidden=False, case_sensitive=True), '\\df': SpecialCommand(handler=, syntax='\\df[+] [pattern]', description='List functions.', arg_type=1, hidden=False, case_sensitive=True), '\\di': SpecialCommand(handler=, syntax='\\di[+] [pattern]', description='List indexes.', arg_type=1, hidden=False, case_sensitive=True), '\\dm': SpecialCommand(handler=, syntax='\\dm[+] [pattern]', description='List materialized views.', arg_type=1, hidden=False, case_sensitive=True), '\\dn': SpecialCommand(handler=, syntax='\\dn[+] [pattern]', description='List schemas.', arg_type=1, hidden=False, case_sensitive=True), '\\do': SpecialCommand(handler=, syntax='\\do[S] [pattern]', description='List operators.', arg_type=0, hidden=True, case_sensitive=True), '\\dp': SpecialCommand(handler=, syntax='\\dp [pattern]', description='List roles.', arg_type=1, hidden=False, case_sensitive=True), '\\ds': SpecialCommand(handler=, syntax='\\ds[+] [pattern]', description='List sequences.', arg_type=1, hidden=False, case_sensitive=True), '\\dt': SpecialCommand(handler=, syntax='\\dt[+] [pattern]', description='List tables.', arg_type=1, hidden=False, case_sensitive=True), '\\du': SpecialCommand(handler=, syntax='\\du[+] [pattern]', description='List roles.', arg_type=1, hidden=False, case_sensitive=True), '\\dv': SpecialCommand(handler=, syntax='\\dv[+] [pattern]', description='List views.', arg_type=1, hidden=False, case_sensitive=True), '\\dx': SpecialCommand(handler=, syntax='\\dx[+] [pattern]', description='List extensions.', arg_type=1, hidden=False, case_sensitive=True), '\\e': SpecialCommand(handler=, syntax='\\e [file]', description='Edit the query with external editor.', arg_type=0, hidden=False, case_sensitive=True), '\\ef': SpecialCommand(handler=, syntax='\\ef [funcname [line]]', description='Edit the contents of the query buffer.', arg_type=0, hidden=True, case_sensitive=True), '\\ev': SpecialCommand(handler=, syntax='\\ev [viewname [line]]', description='Edit the contents of the query buffer.', arg_type=0, hidden=True, case_sensitive=True), '\\h': SpecialCommand(handler=>, syntax='\\h', description='Show SQL syntax and help.', arg_type=1, hidden=False, case_sensitive=True), '\\l': SpecialCommand(handler=, syntax='\\l[+] [pattern]', description='List databases.', arg_type=1, hidden=False, case_sensitive=True), '\\list': SpecialCommand(handler=, syntax='\\l[+] [pattern]', description='List databases.', arg_type=1, hidden=True, case_sensitive=True), '\\n': SpecialCommand(handler=, syntax='\\n[+] [name] [param1 param2 ...]', description='List or execute named queries.', arg_type=1, hidden=False, case_sensitive=True), '\\nd': SpecialCommand(handler=, syntax='\\nd [name]', description='Delete a named query.', arg_type=1, hidden=False, case_sensitive=True), '\\np': SpecialCommand(handler=, syntax='\\np name_pattern', description='Print a named query.', arg_type=1, hidden=False, case_sensitive=True), '\\ns': SpecialCommand(handler=, syntax='\\ns name query', description='Save a named query.', arg_type=1, hidden=False, case_sensitive=True), '\\pager': SpecialCommand(handler=>, syntax='\\pager [command]', description='Set PAGER. Print the query results via PAGER.', arg_type=1, hidden=False, case_sensitive=True), '\\pset': SpecialCommand(handler=>, syntax='\\pset [key] [value]', description='A limited version of traditional \\pset', arg_type=1, hidden=False, case_sensitive=True), '\\sf': SpecialCommand(handler=, syntax='\\sf[+] FUNCNAME', description="Show a function's definition.", arg_type=1, hidden=False, case_sensitive=True), '\\timing': SpecialCommand(handler=>, syntax='\\timing', description='Toggle timing of commands.', arg_type=0, hidden=False, case_sensitive=True), '\\watch': SpecialCommand(handler=.placeholder at 0x7fbfeeef15e0>, syntax='\\watch [sec=2]', description='Execute query every `sec` seconds.', arg_type=0, hidden=False, case_sensitive=True), '\\x': SpecialCommand(handler=>, syntax='\\x', description='Toggle expanded output.', arg_type=1, hidden=False, case_sensitive=True), '\\z': SpecialCommand(handler=, syntax='\\dp [pattern]', description='List roles.', arg_type=1, hidden=True, case_sensitive=True), 'describe': SpecialCommand(handler=, syntax='DESCRIBE [pattern]', description='', arg_type=1, hidden=True, case_sensitive=False)} cur = pattern = 'i*2' self = special_cmd = SpecialCommand(handler=, syntax='\\dp [pattern]', description='List roles.', arg_type=1, hidden=False, case_sensitive=True) sql = '\\dp i*2' verbose = False pgspecial/dbcommands.py:198: in list_privileges cur.execute(sql, params) cur = params = {'table_pattern': '^(i.*2)$'} pattern = (' AND c.relname OPERATOR(pg_catalog.~) %(table_pattern)s COLLATE ' 'pg_catalog.default ') schema = None sql = ('\n' ' SELECT n.nspname as "Schema",\n' ' c.relname as "Name",\n' " CASE c.relkind WHEN 'r' THEN 'table'\n" " WHEN 'v' THEN 'view'\n" " WHEN 'm' THEN 'materialized view'\n" " WHEN 'S' THEN 'sequence'\n" " WHEN 'f' THEN 'foreign table'\n" " WHEN 'p' THEN 'partitioned table' END as " '"Type",\n' " pg_catalog.array_to_string(c.relacl, E'\n" '\') AS "Access privileges",\n' ' pg_catalog.array_to_string(ARRAY(\n' " SELECT attname || E':\n" " ' || pg_catalog.array_to_string(attacl, E'\n" " ')\n" ' FROM pg_catalog.pg_attribute a\n' ' WHERE attrelid = c.oid AND NOT attisdropped AND attacl IS NOT ' 'NULL\n' " ), E'\n" '\') AS "Column privileges",\n' ' pg_catalog.array_to_string(ARRAY(\n' ' SELECT polname\n' ' || CASE WHEN NOT polpermissive THEN\n' " E' (RESTRICTIVE)'\n" " ELSE '' END\n" " || CASE WHEN polcmd != '*' THEN\n" " E' (' || polcmd || E'):'\n" " ELSE E':'\n" ' END\n' ' || CASE WHEN polqual IS NOT NULL THEN\n' " E'\n" " (u): ' || pg_catalog.pg_get_expr(polqual, polrelid)\n" " ELSE E''\n" ' END\n' ' || CASE WHEN polwithcheck IS NOT NULL THEN\n' " E'\n" " (c): ' || pg_catalog.pg_get_expr(polwithcheck, polrelid)\n" " ELSE E''\n" " END || CASE WHEN polroles <> '{0}' THEN\n" " E'\n" " to: ' || pg_catalog.array_to_string(\n" ' ARRAY(\n' ' SELECT rolname\n' ' FROM pg_catalog.pg_roles\n' ' WHERE oid = ANY (polroles)\n' ' ORDER BY 1\n' " ), E', ')\n" " ELSE E''\n" ' END\n' ' FROM pg_catalog.pg_policy pol\n' " WHERE polrelid = c.oid), E'\n" "')\n" ' AS "Policies"\n' ' FROM pg_catalog.pg_class c\n' ' LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n' ' \n' " WHERE c.relkind IN ('r','v','m','S','f','p')\n" ' AND c.relname OPERATOR(pg_catalog.~) %(table_pattern)s COLLATE ' 'pg_catalog.default \n' " AND n.nspname !~ '^pg_'\n" ' ORDER BY 1, 2') table = '^(i.*2)$' verbose = False where_clause = ('\n' " WHERE c.relkind IN ('r','v','m','S','f','p')\n" ' AND c.relname OPERATOR(pg_catalog.~) %(table_pattern)s COLLATE ' 'pg_catalog.default \n' " AND n.nspname !~ '^pg_'\n" ' ') _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = query = '\n SELECT n.nspname as "Schema",\n c.relname as "Name",\n CASE c.relkind WHEN \'r\' THEN \'t...R(pg_catalog.~) %(table_pattern)s COLLATE pg_catalog.default \n AND n.nspname !~ \'^pg_\'\n ORDER BY 1, 2' params = {'table_pattern': '^(i.*2)$'} def execute( self: _Self, query: Query, params: Optional[Params] = None, *, prepare: Optional[bool] = None, binary: Optional[bool] = None, ) -> _Self: """ Execute a query or command to the database. """ try: with self._conn.lock: self._conn.wait( self._execute_gen(query, params, prepare=prepare, binary=binary) ) except e.Error as ex: > raise ex.with_traceback(None) E psycopg.errors.AmbiguousFunction: operator is not unique: unknown || "char" E LINE 26: E' (' || polcmd || E'):' E ^ E HINT: Could not choose a best candidate operator. You might need to add explicit type casts. binary = None params = {'table_pattern': '^(i.*2)$'} prepare = None query = ('\n' ' SELECT n.nspname as "Schema",\n' ' c.relname as "Name",\n' " CASE c.relkind WHEN 'r' THEN 'table'\n" " WHEN 'v' THEN 'view'\n" " WHEN 'm' THEN 'materialized view'\n" " WHEN 'S' THEN 'sequence'\n" " WHEN 'f' THEN 'foreign table'\n" " WHEN 'p' THEN 'partitioned table' END as " '"Type",\n' " pg_catalog.array_to_string(c.relacl, E'\n" '\') AS "Access privileges",\n' ' pg_catalog.array_to_string(ARRAY(\n' " SELECT attname || E':\n" " ' || pg_catalog.array_to_string(attacl, E'\n" " ')\n" ' FROM pg_catalog.pg_attribute a\n' ' WHERE attrelid = c.oid AND NOT attisdropped AND attacl IS NOT ' 'NULL\n' " ), E'\n" '\') AS "Column privileges",\n' ' pg_catalog.array_to_string(ARRAY(\n' ' SELECT polname\n' ' || CASE WHEN NOT polpermissive THEN\n' " E' (RESTRICTIVE)'\n" " ELSE '' END\n" " || CASE WHEN polcmd != '*' THEN\n" " E' (' || polcmd || E'):'\n" " ELSE E':'\n" ' END\n' ' || CASE WHEN polqual IS NOT NULL THEN\n' " E'\n" " (u): ' || pg_catalog.pg_get_expr(polqual, polrelid)\n" " ELSE E''\n" ' END\n' ' || CASE WHEN polwithcheck IS NOT NULL THEN\n' " E'\n" " (c): ' || pg_catalog.pg_get_expr(polwithcheck, polrelid)\n" " ELSE E''\n" " END || CASE WHEN polroles <> '{0}' THEN\n" " E'\n" " to: ' || pg_catalog.array_to_string(\n" ' ARRAY(\n' ' SELECT rolname\n' ' FROM pg_catalog.pg_roles\n' ' WHERE oid = ANY (polroles)\n' ' ORDER BY 1\n' " ), E', ')\n" " ELSE E''\n" ' END\n' ' FROM pg_catalog.pg_policy pol\n' " WHERE polrelid = c.oid), E'\n" "')\n" ' AS "Policies"\n' ' FROM pg_catalog.pg_class c\n' ' LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n' ' \n' " WHERE c.relkind IN ('r','v','m','S','f','p')\n" ' AND c.relname OPERATOR(pg_catalog.~) %(table_pattern)s COLLATE ' 'pg_catalog.default \n' " AND n.nspname !~ '^pg_'\n" ' ORDER BY 1, 2') self = /usr/lib/python3.8/site-packages/psycopg/cursor.py:728: AmbiguousFunction _________________________ test_slash_dp_pattern_schema _________________________ executor = .query_runner at 0x7fbfeeaf7ca0> @dbtest def test_slash_dp_pattern_schema(executor): """List all schemas.""" > results = executor(r"\dp schema2.*") executor = .query_runner at 0x7fbfeeaf7ca0> tests/test_specials.py:266: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ tests/conftest.py:29: in query_runner for title, rows, headers, status in pgspecial.execute(cur=cur, sql=sql): cur = pgspecial = results = [] sql = '\\dp schema2.*' pgspecial/main.py:117: in execute return special_cmd.handler(cur=cur, pattern=pattern, verbose=verbose) command = '\\dp' commands = {'\\!': SpecialCommand(handler=, syntax='\\! [command]', description='Pass commands to shell.', arg_type=1, hidden=False, case_sensitive=True), '\\?': SpecialCommand(handler=>, syntax='\\?', description='Show Commands.', arg_type=1, hidden=False, case_sensitive=True), '\\copy': SpecialCommand(handler=, syntax='\\copy [tablename] to/from [filename]', description='Copy data between a file and a table.', arg_type=1, hidden=False, case_sensitive=True), '\\d': SpecialCommand(handler=, syntax='\\d[+] [pattern]', description='List or describe tables, views and sequences.', arg_type=1, hidden=False, case_sensitive=True), '\\dD': SpecialCommand(handler=, syntax='\\dD[+] [pattern]', description='List or describe domains.', arg_type=1, hidden=False, case_sensitive=True), '\\dE': SpecialCommand(handler=, syntax='\\dE[+] [pattern]', description='List foreign tables.', arg_type=1, hidden=False, case_sensitive=True), '\\dF': SpecialCommand(handler=, syntax='\\dF[+] [pattern]', description='List text search configurations.', arg_type=1, hidden=False, case_sensitive=True), '\\dT': SpecialCommand(handler=, syntax='\\dT[S+] [pattern]', description='List data types', arg_type=1, hidden=False, case_sensitive=True), '\\db': SpecialCommand(handler=, syntax='\\db[+] [pattern]', description='List tablespaces.', arg_type=1, hidden=False, case_sensitive=True), '\\ddp': SpecialCommand(handler=, syntax='\\ddp [pattern]', description='Lists default access privilege settings.', arg_type=1, hidden=False, case_sensitive=True), '\\df': SpecialCommand(handler=, syntax='\\df[+] [pattern]', description='List functions.', arg_type=1, hidden=False, case_sensitive=True), '\\di': SpecialCommand(handler=, syntax='\\di[+] [pattern]', description='List indexes.', arg_type=1, hidden=False, case_sensitive=True), '\\dm': SpecialCommand(handler=, syntax='\\dm[+] [pattern]', description='List materialized views.', arg_type=1, hidden=False, case_sensitive=True), '\\dn': SpecialCommand(handler=, syntax='\\dn[+] [pattern]', description='List schemas.', arg_type=1, hidden=False, case_sensitive=True), '\\do': SpecialCommand(handler=, syntax='\\do[S] [pattern]', description='List operators.', arg_type=0, hidden=True, case_sensitive=True), '\\dp': SpecialCommand(handler=, syntax='\\dp [pattern]', description='List roles.', arg_type=1, hidden=False, case_sensitive=True), '\\ds': SpecialCommand(handler=, syntax='\\ds[+] [pattern]', description='List sequences.', arg_type=1, hidden=False, case_sensitive=True), '\\dt': SpecialCommand(handler=, syntax='\\dt[+] [pattern]', description='List tables.', arg_type=1, hidden=False, case_sensitive=True), '\\du': SpecialCommand(handler=, syntax='\\du[+] [pattern]', description='List roles.', arg_type=1, hidden=False, case_sensitive=True), '\\dv': SpecialCommand(handler=, syntax='\\dv[+] [pattern]', description='List views.', arg_type=1, hidden=False, case_sensitive=True), '\\dx': SpecialCommand(handler=, syntax='\\dx[+] [pattern]', description='List extensions.', arg_type=1, hidden=False, case_sensitive=True), '\\e': SpecialCommand(handler=, syntax='\\e [file]', description='Edit the query with external editor.', arg_type=0, hidden=False, case_sensitive=True), '\\ef': SpecialCommand(handler=, syntax='\\ef [funcname [line]]', description='Edit the contents of the query buffer.', arg_type=0, hidden=True, case_sensitive=True), '\\ev': SpecialCommand(handler=, syntax='\\ev [viewname [line]]', description='Edit the contents of the query buffer.', arg_type=0, hidden=True, case_sensitive=True), '\\h': SpecialCommand(handler=>, syntax='\\h', description='Show SQL syntax and help.', arg_type=1, hidden=False, case_sensitive=True), '\\l': SpecialCommand(handler=, syntax='\\l[+] [pattern]', description='List databases.', arg_type=1, hidden=False, case_sensitive=True), '\\list': SpecialCommand(handler=, syntax='\\l[+] [pattern]', description='List databases.', arg_type=1, hidden=True, case_sensitive=True), '\\n': SpecialCommand(handler=, syntax='\\n[+] [name] [param1 param2 ...]', description='List or execute named queries.', arg_type=1, hidden=False, case_sensitive=True), '\\nd': SpecialCommand(handler=, syntax='\\nd [name]', description='Delete a named query.', arg_type=1, hidden=False, case_sensitive=True), '\\np': SpecialCommand(handler=, syntax='\\np name_pattern', description='Print a named query.', arg_type=1, hidden=False, case_sensitive=True), '\\ns': SpecialCommand(handler=, syntax='\\ns name query', description='Save a named query.', arg_type=1, hidden=False, case_sensitive=True), '\\pager': SpecialCommand(handler=>, syntax='\\pager [command]', description='Set PAGER. Print the query results via PAGER.', arg_type=1, hidden=False, case_sensitive=True), '\\pset': SpecialCommand(handler=>, syntax='\\pset [key] [value]', description='A limited version of traditional \\pset', arg_type=1, hidden=False, case_sensitive=True), '\\sf': SpecialCommand(handler=, syntax='\\sf[+] FUNCNAME', description="Show a function's definition.", arg_type=1, hidden=False, case_sensitive=True), '\\timing': SpecialCommand(handler=>, syntax='\\timing', description='Toggle timing of commands.', arg_type=0, hidden=False, case_sensitive=True), '\\watch': SpecialCommand(handler=.placeholder at 0x7fbfeeef15e0>, syntax='\\watch [sec=2]', description='Execute query every `sec` seconds.', arg_type=0, hidden=False, case_sensitive=True), '\\x': SpecialCommand(handler=>, syntax='\\x', description='Toggle expanded output.', arg_type=1, hidden=False, case_sensitive=True), '\\z': SpecialCommand(handler=, syntax='\\dp [pattern]', description='List roles.', arg_type=1, hidden=True, case_sensitive=True), 'describe': SpecialCommand(handler=, syntax='DESCRIBE [pattern]', description='', arg_type=1, hidden=True, case_sensitive=False)} cur = pattern = 'schema2.*' self = special_cmd = SpecialCommand(handler=, syntax='\\dp [pattern]', description='List roles.', arg_type=1, hidden=False, case_sensitive=True) sql = '\\dp schema2.*' verbose = False pgspecial/dbcommands.py:198: in list_privileges cur.execute(sql, params) cur = params = {'schema_pattern': '^(schema2)$', 'table_pattern': '^(.*)$'} pattern = (' AND c.relname OPERATOR(pg_catalog.~) %(table_pattern)s COLLATE ' 'pg_catalog.default AND n.nspname OPERATOR(pg_catalog.~) %(schema_pattern)s ' 'COLLATE pg_catalog.default ') schema = '^(schema2)$' sql = ('\n' ' SELECT n.nspname as "Schema",\n' ' c.relname as "Name",\n' " CASE c.relkind WHEN 'r' THEN 'table'\n" " WHEN 'v' THEN 'view'\n" " WHEN 'm' THEN 'materialized view'\n" " WHEN 'S' THEN 'sequence'\n" " WHEN 'f' THEN 'foreign table'\n" " WHEN 'p' THEN 'partitioned table' END as " '"Type",\n' " pg_catalog.array_to_string(c.relacl, E'\n" '\') AS "Access privileges",\n' ' pg_catalog.array_to_string(ARRAY(\n' " SELECT attname || E':\n" " ' || pg_catalog.array_to_string(attacl, E'\n" " ')\n" ' FROM pg_catalog.pg_attribute a\n' ' WHERE attrelid = c.oid AND NOT attisdropped AND attacl IS NOT ' 'NULL\n' " ), E'\n" '\') AS "Column privileges",\n' ' pg_catalog.array_to_string(ARRAY(\n' ' SELECT polname\n' ' || CASE WHEN NOT polpermissive THEN\n' " E' (RESTRICTIVE)'\n" " ELSE '' END\n" " || CASE WHEN polcmd != '*' THEN\n" " E' (' || polcmd || E'):'\n" " ELSE E':'\n" ' END\n' ' || CASE WHEN polqual IS NOT NULL THEN\n' " E'\n" " (u): ' || pg_catalog.pg_get_expr(polqual, polrelid)\n" " ELSE E''\n" ' END\n' ' || CASE WHEN polwithcheck IS NOT NULL THEN\n' " E'\n" " (c): ' || pg_catalog.pg_get_expr(polwithcheck, polrelid)\n" " ELSE E''\n" " END || CASE WHEN polroles <> '{0}' THEN\n" " E'\n" " to: ' || pg_catalog.array_to_string(\n" ' ARRAY(\n' ' SELECT rolname\n' ' FROM pg_catalog.pg_roles\n' ' WHERE oid = ANY (polroles)\n' ' ORDER BY 1\n' " ), E', ')\n" " ELSE E''\n" ' END\n' ' FROM pg_catalog.pg_policy pol\n' " WHERE polrelid = c.oid), E'\n" "')\n" ' AS "Policies"\n' ' FROM pg_catalog.pg_class c\n' ' LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n' ' \n' " WHERE c.relkind IN ('r','v','m','S','f','p')\n" ' AND c.relname OPERATOR(pg_catalog.~) %(table_pattern)s COLLATE ' 'pg_catalog.default AND n.nspname OPERATOR(pg_catalog.~) %(schema_pattern)s ' 'COLLATE pg_catalog.default \n' " AND n.nspname !~ '^pg_'\n" ' ORDER BY 1, 2') table = '^(.*)$' verbose = False where_clause = ('\n' " WHERE c.relkind IN ('r','v','m','S','f','p')\n" ' AND c.relname OPERATOR(pg_catalog.~) %(table_pattern)s COLLATE ' 'pg_catalog.default AND n.nspname OPERATOR(pg_catalog.~) %(schema_pattern)s ' 'COLLATE pg_catalog.default \n' " AND n.nspname !~ '^pg_'\n" ' ') _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = query = '\n SELECT n.nspname as "Schema",\n c.relname as "Name",\n CASE c.relkind WHEN \'r\' THEN \'t...(pg_catalog.~) %(schema_pattern)s COLLATE pg_catalog.default \n AND n.nspname !~ \'^pg_\'\n ORDER BY 1, 2' params = {'schema_pattern': '^(schema2)$', 'table_pattern': '^(.*)$'} def execute( self: _Self, query: Query, params: Optional[Params] = None, *, prepare: Optional[bool] = None, binary: Optional[bool] = None, ) -> _Self: """ Execute a query or command to the database. """ try: with self._conn.lock: self._conn.wait( self._execute_gen(query, params, prepare=prepare, binary=binary) ) except e.Error as ex: > raise ex.with_traceback(None) E psycopg.errors.AmbiguousFunction: operator is not unique: unknown || "char" E LINE 26: E' (' || polcmd || E'):' E ^ E HINT: Could not choose a best candidate operator. You might need to add explicit type casts. binary = None params = {'schema_pattern': '^(schema2)$', 'table_pattern': '^(.*)$'} prepare = None query = ('\n' ' SELECT n.nspname as "Schema",\n' ' c.relname as "Name",\n' " CASE c.relkind WHEN 'r' THEN 'table'\n" " WHEN 'v' THEN 'view'\n" " WHEN 'm' THEN 'materialized view'\n" " WHEN 'S' THEN 'sequence'\n" " WHEN 'f' THEN 'foreign table'\n" " WHEN 'p' THEN 'partitioned table' END as " '"Type",\n' " pg_catalog.array_to_string(c.relacl, E'\n" '\') AS "Access privileges",\n' ' pg_catalog.array_to_string(ARRAY(\n' " SELECT attname || E':\n" " ' || pg_catalog.array_to_string(attacl, E'\n" " ')\n" ' FROM pg_catalog.pg_attribute a\n' ' WHERE attrelid = c.oid AND NOT attisdropped AND attacl IS NOT ' 'NULL\n' " ), E'\n" '\') AS "Column privileges",\n' ' pg_catalog.array_to_string(ARRAY(\n' ' SELECT polname\n' ' || CASE WHEN NOT polpermissive THEN\n' " E' (RESTRICTIVE)'\n" " ELSE '' END\n" " || CASE WHEN polcmd != '*' THEN\n" " E' (' || polcmd || E'):'\n" " ELSE E':'\n" ' END\n' ' || CASE WHEN polqual IS NOT NULL THEN\n' " E'\n" " (u): ' || pg_catalog.pg_get_expr(polqual, polrelid)\n" " ELSE E''\n" ' END\n' ' || CASE WHEN polwithcheck IS NOT NULL THEN\n' " E'\n" " (c): ' || pg_catalog.pg_get_expr(polwithcheck, polrelid)\n" " ELSE E''\n" " END || CASE WHEN polroles <> '{0}' THEN\n" " E'\n" " to: ' || pg_catalog.array_to_string(\n" ' ARRAY(\n' ' SELECT rolname\n' ' FROM pg_catalog.pg_roles\n' ' WHERE oid = ANY (polroles)\n' ' ORDER BY 1\n' " ), E', ')\n" " ELSE E''\n" ' END\n' ' FROM pg_catalog.pg_policy pol\n' " WHERE polrelid = c.oid), E'\n" "')\n" ' AS "Policies"\n' ' FROM pg_catalog.pg_class c\n' ' LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n' ' \n' " WHERE c.relkind IN ('r','v','m','S','f','p')\n" ' AND c.relname OPERATOR(pg_catalog.~) %(table_pattern)s COLLATE ' 'pg_catalog.default AND n.nspname OPERATOR(pg_catalog.~) %(schema_pattern)s ' 'COLLATE pg_catalog.default \n' " AND n.nspname !~ '^pg_'\n" ' ORDER BY 1, 2') self = /usr/lib/python3.8/site-packages/psycopg/cursor.py:728: AmbiguousFunction _________________________ test_slash_dp_pattern_alias __________________________ executor = .query_runner at 0x7fbfeeaf7d30> @dbtest def test_slash_dp_pattern_alias(executor): """List all schemas.""" > results = executor(r"\z i*2") executor = .query_runner at 0x7fbfeeaf7d30> tests/test_specials.py:288: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ tests/conftest.py:29: in query_runner for title, rows, headers, status in pgspecial.execute(cur=cur, sql=sql): cur = pgspecial = results = [] sql = '\\z i*2' pgspecial/main.py:117: in execute return special_cmd.handler(cur=cur, pattern=pattern, verbose=verbose) command = '\\z' commands = {'\\!': SpecialCommand(handler=, syntax='\\! [command]', description='Pass commands to shell.', arg_type=1, hidden=False, case_sensitive=True), '\\?': SpecialCommand(handler=>, syntax='\\?', description='Show Commands.', arg_type=1, hidden=False, case_sensitive=True), '\\copy': SpecialCommand(handler=, syntax='\\copy [tablename] to/from [filename]', description='Copy data between a file and a table.', arg_type=1, hidden=False, case_sensitive=True), '\\d': SpecialCommand(handler=, syntax='\\d[+] [pattern]', description='List or describe tables, views and sequences.', arg_type=1, hidden=False, case_sensitive=True), '\\dD': SpecialCommand(handler=, syntax='\\dD[+] [pattern]', description='List or describe domains.', arg_type=1, hidden=False, case_sensitive=True), '\\dE': SpecialCommand(handler=, syntax='\\dE[+] [pattern]', description='List foreign tables.', arg_type=1, hidden=False, case_sensitive=True), '\\dF': SpecialCommand(handler=, syntax='\\dF[+] [pattern]', description='List text search configurations.', arg_type=1, hidden=False, case_sensitive=True), '\\dT': SpecialCommand(handler=, syntax='\\dT[S+] [pattern]', description='List data types', arg_type=1, hidden=False, case_sensitive=True), '\\db': SpecialCommand(handler=, syntax='\\db[+] [pattern]', description='List tablespaces.', arg_type=1, hidden=False, case_sensitive=True), '\\ddp': SpecialCommand(handler=, syntax='\\ddp [pattern]', description='Lists default access privilege settings.', arg_type=1, hidden=False, case_sensitive=True), '\\df': SpecialCommand(handler=, syntax='\\df[+] [pattern]', description='List functions.', arg_type=1, hidden=False, case_sensitive=True), '\\di': SpecialCommand(handler=, syntax='\\di[+] [pattern]', description='List indexes.', arg_type=1, hidden=False, case_sensitive=True), '\\dm': SpecialCommand(handler=, syntax='\\dm[+] [pattern]', description='List materialized views.', arg_type=1, hidden=False, case_sensitive=True), '\\dn': SpecialCommand(handler=, syntax='\\dn[+] [pattern]', description='List schemas.', arg_type=1, hidden=False, case_sensitive=True), '\\do': SpecialCommand(handler=, syntax='\\do[S] [pattern]', description='List operators.', arg_type=0, hidden=True, case_sensitive=True), '\\dp': SpecialCommand(handler=, syntax='\\dp [pattern]', description='List roles.', arg_type=1, hidden=False, case_sensitive=True), '\\ds': SpecialCommand(handler=, syntax='\\ds[+] [pattern]', description='List sequences.', arg_type=1, hidden=False, case_sensitive=True), '\\dt': SpecialCommand(handler=, syntax='\\dt[+] [pattern]', description='List tables.', arg_type=1, hidden=False, case_sensitive=True), '\\du': SpecialCommand(handler=, syntax='\\du[+] [pattern]', description='List roles.', arg_type=1, hidden=False, case_sensitive=True), '\\dv': SpecialCommand(handler=, syntax='\\dv[+] [pattern]', description='List views.', arg_type=1, hidden=False, case_sensitive=True), '\\dx': SpecialCommand(handler=, syntax='\\dx[+] [pattern]', description='List extensions.', arg_type=1, hidden=False, case_sensitive=True), '\\e': SpecialCommand(handler=, syntax='\\e [file]', description='Edit the query with external editor.', arg_type=0, hidden=False, case_sensitive=True), '\\ef': SpecialCommand(handler=, syntax='\\ef [funcname [line]]', description='Edit the contents of the query buffer.', arg_type=0, hidden=True, case_sensitive=True), '\\ev': SpecialCommand(handler=, syntax='\\ev [viewname [line]]', description='Edit the contents of the query buffer.', arg_type=0, hidden=True, case_sensitive=True), '\\h': SpecialCommand(handler=>, syntax='\\h', description='Show SQL syntax and help.', arg_type=1, hidden=False, case_sensitive=True), '\\l': SpecialCommand(handler=, syntax='\\l[+] [pattern]', description='List databases.', arg_type=1, hidden=False, case_sensitive=True), '\\list': SpecialCommand(handler=, syntax='\\l[+] [pattern]', description='List databases.', arg_type=1, hidden=True, case_sensitive=True), '\\n': SpecialCommand(handler=, syntax='\\n[+] [name] [param1 param2 ...]', description='List or execute named queries.', arg_type=1, hidden=False, case_sensitive=True), '\\nd': SpecialCommand(handler=, syntax='\\nd [name]', description='Delete a named query.', arg_type=1, hidden=False, case_sensitive=True), '\\np': SpecialCommand(handler=, syntax='\\np name_pattern', description='Print a named query.', arg_type=1, hidden=False, case_sensitive=True), '\\ns': SpecialCommand(handler=, syntax='\\ns name query', description='Save a named query.', arg_type=1, hidden=False, case_sensitive=True), '\\pager': SpecialCommand(handler=>, syntax='\\pager [command]', description='Set PAGER. Print the query results via PAGER.', arg_type=1, hidden=False, case_sensitive=True), '\\pset': SpecialCommand(handler=>, syntax='\\pset [key] [value]', description='A limited version of traditional \\pset', arg_type=1, hidden=False, case_sensitive=True), '\\sf': SpecialCommand(handler=, syntax='\\sf[+] FUNCNAME', description="Show a function's definition.", arg_type=1, hidden=False, case_sensitive=True), '\\timing': SpecialCommand(handler=>, syntax='\\timing', description='Toggle timing of commands.', arg_type=0, hidden=False, case_sensitive=True), '\\watch': SpecialCommand(handler=.placeholder at 0x7fbfeeef15e0>, syntax='\\watch [sec=2]', description='Execute query every `sec` seconds.', arg_type=0, hidden=False, case_sensitive=True), '\\x': SpecialCommand(handler=>, syntax='\\x', description='Toggle expanded output.', arg_type=1, hidden=False, case_sensitive=True), '\\z': SpecialCommand(handler=, syntax='\\dp [pattern]', description='List roles.', arg_type=1, hidden=True, case_sensitive=True), 'describe': SpecialCommand(handler=, syntax='DESCRIBE [pattern]', description='', arg_type=1, hidden=True, case_sensitive=False)} cur = pattern = 'i*2' self = special_cmd = SpecialCommand(handler=, syntax='\\dp [pattern]', description='List roles.', arg_type=1, hidden=True, case_sensitive=True) sql = '\\z i*2' verbose = False pgspecial/dbcommands.py:198: in list_privileges cur.execute(sql, params) cur = params = {'table_pattern': '^(i.*2)$'} pattern = (' AND c.relname OPERATOR(pg_catalog.~) %(table_pattern)s COLLATE ' 'pg_catalog.default ') schema = None sql = ('\n' ' SELECT n.nspname as "Schema",\n' ' c.relname as "Name",\n' " CASE c.relkind WHEN 'r' THEN 'table'\n" " WHEN 'v' THEN 'view'\n" " WHEN 'm' THEN 'materialized view'\n" " WHEN 'S' THEN 'sequence'\n" " WHEN 'f' THEN 'foreign table'\n" " WHEN 'p' THEN 'partitioned table' END as " '"Type",\n' " pg_catalog.array_to_string(c.relacl, E'\n" '\') AS "Access privileges",\n' ' pg_catalog.array_to_string(ARRAY(\n' " SELECT attname || E':\n" " ' || pg_catalog.array_to_string(attacl, E'\n" " ')\n" ' FROM pg_catalog.pg_attribute a\n' ' WHERE attrelid = c.oid AND NOT attisdropped AND attacl IS NOT ' 'NULL\n' " ), E'\n" '\') AS "Column privileges",\n' ' pg_catalog.array_to_string(ARRAY(\n' ' SELECT polname\n' ' || CASE WHEN NOT polpermissive THEN\n' " E' (RESTRICTIVE)'\n" " ELSE '' END\n" " || CASE WHEN polcmd != '*' THEN\n" " E' (' || polcmd || E'):'\n" " ELSE E':'\n" ' END\n' ' || CASE WHEN polqual IS NOT NULL THEN\n' " E'\n" " (u): ' || pg_catalog.pg_get_expr(polqual, polrelid)\n" " ELSE E''\n" ' END\n' ' || CASE WHEN polwithcheck IS NOT NULL THEN\n' " E'\n" " (c): ' || pg_catalog.pg_get_expr(polwithcheck, polrelid)\n" " ELSE E''\n" " END || CASE WHEN polroles <> '{0}' THEN\n" " E'\n" " to: ' || pg_catalog.array_to_string(\n" ' ARRAY(\n' ' SELECT rolname\n' ' FROM pg_catalog.pg_roles\n' ' WHERE oid = ANY (polroles)\n' ' ORDER BY 1\n' " ), E', ')\n" " ELSE E''\n" ' END\n' ' FROM pg_catalog.pg_policy pol\n' " WHERE polrelid = c.oid), E'\n" "')\n" ' AS "Policies"\n' ' FROM pg_catalog.pg_class c\n' ' LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n' ' \n' " WHERE c.relkind IN ('r','v','m','S','f','p')\n" ' AND c.relname OPERATOR(pg_catalog.~) %(table_pattern)s COLLATE ' 'pg_catalog.default \n' " AND n.nspname !~ '^pg_'\n" ' ORDER BY 1, 2') table = '^(i.*2)$' verbose = False where_clause = ('\n' " WHERE c.relkind IN ('r','v','m','S','f','p')\n" ' AND c.relname OPERATOR(pg_catalog.~) %(table_pattern)s COLLATE ' 'pg_catalog.default \n' " AND n.nspname !~ '^pg_'\n" ' ') _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = query = '\n SELECT n.nspname as "Schema",\n c.relname as "Name",\n CASE c.relkind WHEN \'r\' THEN \'t...R(pg_catalog.~) %(table_pattern)s COLLATE pg_catalog.default \n AND n.nspname !~ \'^pg_\'\n ORDER BY 1, 2' params = {'table_pattern': '^(i.*2)$'} def execute( self: _Self, query: Query, params: Optional[Params] = None, *, prepare: Optional[bool] = None, binary: Optional[bool] = None, ) -> _Self: """ Execute a query or command to the database. """ try: with self._conn.lock: self._conn.wait( self._execute_gen(query, params, prepare=prepare, binary=binary) ) except e.Error as ex: > raise ex.with_traceback(None) E psycopg.errors.AmbiguousFunction: operator is not unique: unknown || "char" E LINE 26: E' (' || polcmd || E'):' E ^ E HINT: Could not choose a best candidate operator. You might need to add explicit type casts. binary = None params = {'table_pattern': '^(i.*2)$'} prepare = None query = ('\n' ' SELECT n.nspname as "Schema",\n' ' c.relname as "Name",\n' " CASE c.relkind WHEN 'r' THEN 'table'\n" " WHEN 'v' THEN 'view'\n" " WHEN 'm' THEN 'materialized view'\n" " WHEN 'S' THEN 'sequence'\n" " WHEN 'f' THEN 'foreign table'\n" " WHEN 'p' THEN 'partitioned table' END as " '"Type",\n' " pg_catalog.array_to_string(c.relacl, E'\n" '\') AS "Access privileges",\n' ' pg_catalog.array_to_string(ARRAY(\n' " SELECT attname || E':\n" " ' || pg_catalog.array_to_string(attacl, E'\n" " ')\n" ' FROM pg_catalog.pg_attribute a\n' ' WHERE attrelid = c.oid AND NOT attisdropped AND attacl IS NOT ' 'NULL\n' " ), E'\n" '\') AS "Column privileges",\n' ' pg_catalog.array_to_string(ARRAY(\n' ' SELECT polname\n' ' || CASE WHEN NOT polpermissive THEN\n' " E' (RESTRICTIVE)'\n" " ELSE '' END\n" " || CASE WHEN polcmd != '*' THEN\n" " E' (' || polcmd || E'):'\n" " ELSE E':'\n" ' END\n' ' || CASE WHEN polqual IS NOT NULL THEN\n' " E'\n" " (u): ' || pg_catalog.pg_get_expr(polqual, polrelid)\n" " ELSE E''\n" ' END\n' ' || CASE WHEN polwithcheck IS NOT NULL THEN\n' " E'\n" " (c): ' || pg_catalog.pg_get_expr(polwithcheck, polrelid)\n" " ELSE E''\n" " END || CASE WHEN polroles <> '{0}' THEN\n" " E'\n" " to: ' || pg_catalog.array_to_string(\n" ' ARRAY(\n' ' SELECT rolname\n' ' FROM pg_catalog.pg_roles\n' ' WHERE oid = ANY (polroles)\n' ' ORDER BY 1\n' " ), E', ')\n" " ELSE E''\n" ' END\n' ' FROM pg_catalog.pg_policy pol\n' " WHERE polrelid = c.oid), E'\n" "')\n" ' AS "Policies"\n' ' FROM pg_catalog.pg_class c\n' ' LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\n' ' \n' " WHERE c.relkind IN ('r','v','m','S','f','p')\n" ' AND c.relname OPERATOR(pg_catalog.~) %(table_pattern)s COLLATE ' 'pg_catalog.default \n' " AND n.nspname !~ '^pg_'\n" ' ORDER BY 1, 2') self = /usr/lib/python3.8/site-packages/psycopg/cursor.py:728: AmbiguousFunction =============================== warnings summary =============================== ../../../../../../../usr/lib/python3.8/site-packages/psycopg/connection.py:156 /usr/lib/python3.8/site-packages/psycopg/connection.py:156: ResourceWarning: connection was deleted while still open. Please use 'with' or '.close()' to close the connection warn( ../../../../../../../usr/lib/python3.8/site-packages/psycopg/connection.py:156 /usr/lib/python3.8/site-packages/psycopg/connection.py:156: ResourceWarning: connection was deleted while still open. Please use 'with' or '.close()' to close the connection warn( ../../../../../../../usr/lib/python3.8/site-packages/psycopg/connection.py:156 /usr/lib/python3.8/site-packages/psycopg/connection.py:156: ResourceWarning: connection was deleted while still open. Please use 'with' or '.close()' to close the connection warn( pgspecial/main.py:238 /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1/pgspecial/main.py:238: DeprecationWarning: invalid escape sequence \w """ tests/test_specials.py:866 /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1/tests/test_specials.py:866: DeprecationWarning: invalid escape sequence \c executor("\copy (SELECT 'Montréal', 'Portland', 'Cleveland') INTO stdout ") tests/test_specials.py::test_slash_d /usr/lib/python3.8/site-packages/psycopg/connection.py:156: ResourceWarning: connection was deleted while still open. Please use 'with' or '.close()' to close the connection warn( tests/test_specials.py::test_slash_copy_to_tsv /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1/pgspecial/main.py:117: ResourceWarning: unclosed file <_io.BufferedWriter name='/var/tmp/portage/dev-python/pgspecial-2.0.1/temp/pytest-of-portage/pytest-0/test_slash_copy_to_tsv0/pycons.tsv'> return special_cmd.handler(cur=cur, pattern=pattern, verbose=verbose) Enable tracemalloc to get traceback where the object was allocated. See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. tests/test_specials.py::test_slash_copy_to_tsv /usr/lib/python3.8/site-packages/_pytest/python.py:195: ResourceWarning: unclosed file <_io.TextIOWrapper name='/var/tmp/portage/dev-python/pgspecial-2.0.1/temp/pytest-of-portage/pytest-0/test_slash_copy_to_tsv0/pycons.tsv' mode='r' encoding='utf-8'> result = testfunction(**testargs) Enable tracemalloc to get traceback where the object was allocated. See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. tests/test_specials.py::test_slash_copy_to_csv /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1/pgspecial/main.py:117: ResourceWarning: unclosed file <_io.BufferedWriter name='/var/tmp/portage/dev-python/pgspecial-2.0.1/temp/pytest-of-portage/pytest-0/test_slash_copy_to_csv0/pycons.tsv'> return special_cmd.handler(cur=cur, pattern=pattern, verbose=verbose) Enable tracemalloc to get traceback where the object was allocated. See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. tests/test_specials.py::test_slash_copy_to_csv /usr/lib/python3.8/site-packages/_pytest/python.py:195: ResourceWarning: unclosed file <_io.TextIOWrapper name='/var/tmp/portage/dev-python/pgspecial-2.0.1/temp/pytest-of-portage/pytest-0/test_slash_copy_to_csv0/pycons.tsv' mode='r' encoding='utf-8'> result = testfunction(**testargs) Enable tracemalloc to get traceback where the object was allocated. See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. tests/test_specials.py::test_slash_copy_from_csv /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1/pgspecial/main.py:117: ResourceWarning: unclosed file <_io.BufferedWriter name='/var/tmp/portage/dev-python/pgspecial-2.0.1/temp/pytest-of-portage/pytest-0/test_slash_copy_from_csv0/tbl1.csv'> return special_cmd.handler(cur=cur, pattern=pattern, verbose=verbose) Enable tracemalloc to get traceback where the object was allocated. See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. tests/test_specials.py::test_slash_copy_from_csv /var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1/pgspecial/main.py:117: ResourceWarning: unclosed file <_io.TextIOWrapper name='/var/tmp/portage/dev-python/pgspecial-2.0.1/temp/pytest-of-portage/pytest-0/test_slash_copy_from_csv0/tbl1.csv' mode='r' encoding='UTF-8'> return special_cmd.handler(cur=cur, pattern=pattern, verbose=verbose) Enable tracemalloc to get traceback where the object was allocated. See https://docs.pytest.org/en/stable/how-to/capture-warnings.html#resource-warnings for more info. tests/test_specials.py::test_slash_dE /usr/lib/python3.8/site-packages/psycopg/connection.py:156: ResourceWarning: connection was deleted while still open. Please use 'with' or '.close()' to close the connection warn( tests/test_specials.py::test_slash_dE /usr/lib/python3.8/site-packages/psycopg/connection.py:156: ResourceWarning: connection was deleted while still open. Please use 'with' or '.close()' to close the connection warn( tests/test_specials.py::test_slash_dE /usr/lib/python3.8/site-packages/psycopg/connection.py:156: ResourceWarning: connection was deleted while still open. Please use 'with' or '.close()' to close the connection warn( tests/test_specials.py::test_slash_dE_with_pattern /usr/lib/python3.8/site-packages/psycopg/connection.py:156: ResourceWarning: connection was deleted while still open. Please use 'with' or '.close()' to close the connection warn( tests/test_specials.py::test_slash_dE_with_pattern /usr/lib/python3.8/site-packages/psycopg/connection.py:156: ResourceWarning: connection was deleted while still open. Please use 'with' or '.close()' to close the connection warn( tests/test_specials.py::test_slash_dE_with_pattern /usr/lib/python3.8/site-packages/psycopg/connection.py:156: ResourceWarning: connection was deleted while still open. Please use 'with' or '.close()' to close the connection warn( tests/test_specials.py::test_slash_dE_verbose /usr/lib/python3.8/site-packages/psycopg/connection.py:156: ResourceWarning: connection was deleted while still open. Please use 'with' or '.close()' to close the connection warn( tests/test_specials.py::test_slash_dE_verbose /usr/lib/python3.8/site-packages/psycopg/connection.py:156: ResourceWarning: connection was deleted while still open. Please use 'with' or '.close()' to close the connection warn( tests/test_specials.py::test_slash_dE_verbose /usr/lib/python3.8/site-packages/psycopg/connection.py:156: ResourceWarning: connection was deleted while still open. Please use 'with' or '.close()' to close the connection warn( -- Docs: https://docs.pytest.org/en/stable/how-to/capture-warnings.html =========================== short test summary info ============================ FAILED tests/test_specials.py::test_slash_dn - AssertionError: assert [None, ... FAILED tests/test_specials.py::test_slash_dp - psycopg.errors.AmbiguousFuncti... FAILED tests/test_specials.py::test_slash_dp_pattern_table - psycopg.errors.A... FAILED tests/test_specials.py::test_slash_dp_pattern_schema - psycopg.errors.... FAILED tests/test_specials.py::test_slash_dp_pattern_alias - psycopg.errors.A... ================== 5 failed, 66 passed, 21 warnings in 0.57s =================== /usr/lib/python3.8/site-packages/psycopg/connection.py:156: ResourceWarning: connection was deleted while still open. Please use 'with' or '.close()' to close the connection * ERROR: dev-python/pgspecial-2.0.1::gentoo failed (test phase): * pytest failed with python3.8 * * Call stack: * ebuild.sh, line 136: Called src_test * environment, line 3397: Called distutils-r1_src_test * environment, line 1596: Called _distutils-r1_run_foreach_impl 'python_test' * environment, line 704: Called python_foreach_impl 'distutils-r1_run_phase' 'python_test' * environment, line 3070: Called multibuild_foreach_variant '_python_multibuild_wrapper' 'distutils-r1_run_phase' 'python_test' * environment, line 2596: Called _multibuild_run '_python_multibuild_wrapper' 'distutils-r1_run_phase' 'python_test' * environment, line 2594: Called _python_multibuild_wrapper 'distutils-r1_run_phase' 'python_test' * environment, line 1024: Called distutils-r1_run_phase 'python_test' * environment, line 1519: Called python_test * environment, line 3359: Called distutils-r1_python_test * environment, line 1469: Called epytest * environment, line 2101: Called die * The specific snippet of code: * "${@}" || die -n "pytest failed with ${EPYTHON}"; * * If you need support, post the output of `emerge --info '=dev-python/pgspecial-2.0.1::gentoo'`, * the complete build log and the output of `emerge -pqv '=dev-python/pgspecial-2.0.1::gentoo'`. * The complete build log is located at '/var/log/emerge-log/build/dev-python/pgspecial-2.0.1:20221224-141119.log'. * For convenience, a symlink to the build log is located at '/var/tmp/portage/dev-python/pgspecial-2.0.1/temp/build.log'. * The ebuild environment file is located at '/var/tmp/portage/dev-python/pgspecial-2.0.1/temp/environment'. * Working directory: '/var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1' * S: '/var/tmp/portage/dev-python/pgspecial-2.0.1/work/pgspecial-2.0.1'