D5012.id17963.diff
No OneTemporary
Actions

Size

658 B

Subscribers

None

D5012.id17963.diff
View Options

	diff --git a/swh/storage/postgresql/db.py b/swh/storage/postgresql/db.py
	--- a/swh/storage/postgresql/db.py
	+++ b/swh/storage/postgresql/db.py
	@@ -1343,7 +1343,14 @@

	def dbversion(self):
	with self.transaction() as cur:
	- cur.execute(f"SELECT {', '.join(self.dbversion_cols)} FROM dbversion")
	+ cur.execute(
	+ f"""
	+ SELECT {', '.join(self.dbversion_cols)}
	+ FROM dbversion
	+ ORDER BY version DESC
	+ LIMIT 1
	+ """
	+ )
	return dict(zip(self.dbversion_cols, cur.fetchone()))

	def check_dbversion(self):