joplin
joplin copied to clipboard
PostgreSQL Version Test
Operating system
Linux
Joplin version
Server 2.14.22 and above
Desktop version info
No response
Current behaviour
Version Testing breaks if PostgreSQL Server returns a comma instead of a blank after Version Number
this is due to a poor RegExp in line 417 in ds.ts
const matches = versionString.match('PostgreSQL (.*?) ');
better: PostgreSQL (.*?)[, ] (other wildcards may be possible)
Details:
the current Windows Server returns "PostgreSQL 16.3, compiled by Visual C++ build 1938, 64-bit", which above statement matches to "16.3,". This breaks compare-versions from node.js
Expected behaviour
No response
Logs
No response