[pkg-bacula-devel] Bug#764314: bacula: PostgreSQL syntax error

[prochazka at cortex.cz]

Package: bacula
Version: 5.2.6+dfsg-9.3
Severity: important

Dear Maintainer,

*** Reporter, please consider answering these questions, where 
appropriate ***

    * What led up to the situation? Upgrade from 5.2.6+dfsg-9.2
    * What exactly did you do (or not do) that was effective (or
      ineffective)?
    * What was the outcome of this action?
bacula=# SELECT DISTINCT j.JobId, j.Name AS JobName, j.Level, 
j.ClientId, j.StartTime, j.EndTime, j.VolSessionId, j.VolSessionTime, 
j.JobFiles, j.JobBytes, j.JobErrors, j.Reviewed, j.PoolId, j.FileSetId, 
j.PurgedFiles, j.JobStatus, j.(NOW() - StartTime) AS DurationTime, 
s.JobStatusLong, c.Name AS ClientName, p.Name AS PoolName FROM Job AS j 
LEFT JOIN Status AS s ON j.JobStatus = s.JobStatus LEFT JOIN Client AS c 
ON j.ClientId = c.ClientId LEFT JOIN Pool AS p ON j.PoolId = p.PoolId 
WHERE ((j.EndTime IS NULL) OR (j.JobStatus IN 
('C','R','B','e','F','S','m','M','s','j','c','d','t','p','i','a','l','L'))) 
AND (j.StartTime > ( NOW() - INTERVAL '7 days' )) ORDER BY StartTime 
ASC, JobId ASC
;
ERROR:  syntax error at or near "("
LINE 1: ...oolId, j.FileSetId, j.PurgedFiles, j.JobStatus, j.(NOW() - 
S...
                                                              ^
    * What outcome did you expect instead?

*** End of the template - remove these template lines ***


-- System Information:
Debian Release: jessie/sid
   APT prefers testing-updates
   APT policy: (500, 'testing-updates'), (500, 'testing')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 3.16-2-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages bacula depends on:
ii  bacula-client  5.2.6+dfsg-9.3
ii  bacula-common  5.2.6+dfsg-9.3
ii  bacula-server  5.2.6+dfsg-9.3

bacula recommends no packages.

Versions of packages bacula suggests:
pn  bacula-doc  <none>

-- no debconf information