From ac43ef8e9f2350fc7794ffed818bbc447f74c1f3 Mon Sep 17 00:00:00 2001
From: Joel Beckmeyer <joel@beckmeyer.us>
Date: Fri, 16 Sep 2022 13:23:51 -0400
Subject: [PATCH 1/3] New package: python3-psycopg-3.1.1

---
 srcpkgs/python3-psycopg/template | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)
 create mode 100644 srcpkgs/python3-psycopg/template

diff --git a/srcpkgs/python3-psycopg/template b/srcpkgs/python3-psycopg/template
new file mode 100644
index 000000000000..ca04d790e1c6
--- /dev/null
+++ b/srcpkgs/python3-psycopg/template
@@ -0,0 +1,16 @@
+# Template file for 'python3-psycopg'
+pkgname=python3-psycopg
+version=3.1.1
+revision=1
+wrksrc="psycopg-${version}"
+build_style=python3-module
+hostmakedepends="python3-setuptools"
+depends="python3"
+short_desc="PostgreSQL database adapter for Python"
+maintainer="Joel Beckmeyer <joel@beckmeyer.us>"
+license="LGPL-3.0-or-later"
+homepage="https://www.psycopg.org"
+changelog="https://raw.githubusercontent.com/psycopg/psycopg/master/docs/news.rst"
+distfiles="${PYPI_SITE}/p/psycopg/psycopg-${version}.tar.gz"
+checksum=3ee0af9cf944d9579441c15702835a949788b5a57894823f0a916c2598c96f40
+make_check=no # requires running postgres server on system

From 4326aa75232d9625f699e4e566a4cc0d28975d6f Mon Sep 17 00:00:00 2001
From: Joel Beckmeyer <joel@beckmeyer.us>
Date: Fri, 16 Sep 2022 13:15:36 -0400
Subject: [PATCH 2/3] python3-pgspecial: update to 2.0.1.

---
 srcpkgs/python3-pgspecial/template | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/srcpkgs/python3-pgspecial/template b/srcpkgs/python3-pgspecial/template
index 8d52e1238aa2..f46230672db3 100644
--- a/srcpkgs/python3-pgspecial/template
+++ b/srcpkgs/python3-pgspecial/template
@@ -1,11 +1,11 @@
 # Template file for 'python3-pgspecial'
 pkgname=python3-pgspecial
-version=1.13.1
+version=2.0.1
 revision=1
 wrksrc="pgspecial-${version}"
 build_style=python3-module
 hostmakedepends="python3-setuptools"
-depends="python3-click python3-sqlparse python3-psycopg2"
+depends="python3-click python3-sqlparse python3-psycopg"
 checkdepends="${depends} python3-pytest"
 short_desc="Meta-commands handler for PostgreSQL"
 maintainer="Joel Beckmeyer <joel@beckmeyer.us>"
@@ -13,7 +13,7 @@ license="BSD-3-Clause"
 homepage="https://www.dbcli.com"
 changelog="https://raw.githubusercontent.com/dbcli/pgspecial/main/changelog.rst"
 distfiles="${PYPI_SITE}/p/pgspecial/pgspecial-${version}.tar.gz"
-checksum=d5dab96690908275916dc2c622efae217f142e08165fa366949d41cbc5658701
+checksum=64443bbc9ad09b57d0f4dcbb38eff44d52853b7418c9ea52f5857abe1bb534ec
 make_check=no # pgspecial tests require a PostgreSQL server; skip them.
 
 post_install() {

From 25cb163e5049c25f8e0050d9ac397a3d9100b69e Mon Sep 17 00:00:00 2001
From: Joel Beckmeyer <joel@beckmeyer.us>
Date: Fri, 16 Sep 2022 13:14:11 -0400
Subject: [PATCH 3/3] pgcli: update to 3.5.0.

---
 srcpkgs/pgcli/template | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/srcpkgs/pgcli/template b/srcpkgs/pgcli/template
index 6f651301e0d4..e5463eb7ac6a 100644
--- a/srcpkgs/pgcli/template
+++ b/srcpkgs/pgcli/template
@@ -1,11 +1,11 @@
 # Template file for 'pgcli'
 pkgname=pgcli
-version=3.4.1
+version=3.5.0
 revision=1
 build_style=python3-module
 hostmakedepends="python3-setuptools"
 depends="python3-pgspecial python3-click python3-Pygments python3-prompt_toolkit
- python3-psycopg2 python3-sqlparse python3-configobj python3-pendulum
+ python3-psycopg python3-sqlparse python3-configobj python3-pendulum
  python3-cli_helpers python3-setproctitle"
 short_desc="PostgreSQL CLI with autocompletion and syntax highlighting"
 maintainer="Joel Beckmeyer <joel@beckmeyer.us>"
@@ -13,7 +13,7 @@ license="BSD-3-Clause"
 homepage="https://www.pgcli.com"
 changelog="https://raw.githubusercontent.com/dbcli/pgcli/main/changelog.rst"
 distfiles="${PYPI_SITE}/p/pgcli/pgcli-${version}.tar.gz"
-checksum=f03930187e27d60df658ca8a04fb601ec5d7476c735f2b1542c6adec5cac8fe2
+checksum=cc448d95159fc0903d36182992778a096eda5752d660d47671383c8e2bf633f1
 make_check=no # pgcli tests require a PostgreSQL server; skip them.
 
 post_install() {