Package: sql-ledger
Version: 3.0.0-2
Severity: important
Tags: upstream
Dear Maintainer,
While installing your latest package of sql-ledger I got the error:
Error!
sql/Pg-tables.sql : CREATE TABLE payrate (
trans_id int,
id int,
rate float,
over float
)
ERROR: syntax error at or near "over"
LINE 5: over float
^
My investigation showed that "over" is now a reserved word in PostgreSQL.
This issue was also fixed by the upstream author in release 3.0.2 on the 17th
of April this year, and a check of the latest release (3.0.3) shows that the
sql is indeed changed, and that the name of that field has changed.
Thanks,
Nikolai Lusan <[email protected]>
-- System Information:
Debian Release: wheezy/sid
APT prefers unstable
APT policy: (500, 'unstable')
Architecture: amd64 (x86_64)
Kernel: Linux 3.2.2-kiev (SMP w/2 CPU cores)
Locale: LANG=en_AU.UTF-8, LC_CTYPE=en_AU.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages sql-ledger depends on:
ii apache2 2.2.22-5
ii apache2-mpm-prefork [httpd] 2.2.22-5
ii libdbd-pg-perl 2.19.2-1
ii perl 5.14.2-10
sql-ledger recommends no packages.
Versions of packages sql-ledger suggests:
pn postgresql 9.1+129
pn texlive-latex-extra <none>
-- no debconf information
--
To UNSUBSCRIBE, email to [email protected]
with a subject of "unsubscribe". Trouble? Contact [email protected]
