#1434 closed defect (fixed)

Postgresql Version check regexp not valid on Windows

Reported by: hannibal218bc Owned by: nobody
Priority: normal Milestone:
Component: plugins Version: devel
Severity: normal Keywords:


In Pgsql.pm the version of the PostgreSQL server is extrated with a regexp from executing "version()" (line 519 in current version):

unless ($v =~ /^PostgreSQL (\d+)\.(\d+)\.(\d+) on/);

The regex does not match the version string that is returned from a Windows PSQL instance:

PostgreSQL 9.2.4, compiled by Visual C++ build 1600, 64-bit

I suggest using

unless ($v =~ /^PostgreSQL (\d+)\.(\d+)\.(\d+)\b/);


Change History (1)

comment:1 Changed at 2014-01-29T22:49:42+01:00 by snide

  • Resolution set to fixed
  • Status changed from new to closed

Fixed in d53da53810e0cba5d776302d43a1f2ca98813d84.

Thx for the report and the fix.

Note: See TracTickets for help on using tickets.