#123 MRBS\DBException with PostgreSQL 15 while doing table field introspection

[dwpoon]

changeset: 6215:01f381ea234a
tag: tip
user: dwpoon dwpoon@users.sourceforge.net
date: Sun Feb 26 23:44:48 2023 -0800
files: web/lib/MRBS/DB_pgsql.php
description:
Fixed SQL syntax for PostgreSQL schema introspection

Fixed an uncaught MRBS\DBException trying to execute

SELECT column_name, ...
FROM information_schema.columns
WHERE table_name = ?ORDER BY ordinal_position

In PostgreSQL 15, the lack of whitespace between the placeholder and ORDER BY
is a syntax error, whereas PostgreSQL 14 seems to tolerate it.

diff -r 736d1ffc3013 -r 01f381ea234a web/lib/MRBS/DB_pgsql.php
--- a/web/lib/MRBS/DB_pgsql.php Tue Jul 20 20:36:58 2021 +0100
+++ b/web/lib/MRBS/DB_pgsql.php Sun Feb 26 23:44:48 2023 -0800
@@ -244,7 +244,7 @@
$sql .= " AND table_schema = ?";
$sql_params[] = $table_parts['table_schema'];
}
- $sql .= "ORDER BY ordinal_position";
+ $sql .= " ORDER BY ordinal_position";

 $stmt = $this->query($sql, $sql_params);

[Campbell Morrison]

Thanks. Now fixed in 5f3a2b7.