SQL-Fehler bei Berichte -> Kontoübersicht mit PostgreSQL 8.3.x

[Axel.Rau@…]

Problem: Nach der Aktualisierung auf PostgreSQL 8.3.x gibt es bei (z.B.)

Berichte -> Kontoübersicht

SQL-Fehler der Art:

ERROR: function comma(date) does not exist

Diagnose: PostgreSQL 8.3.x benötigt mehr explizite Typumwandlungen als vorherige Versionen.

Lösung:

---

Index: SL/CA.pm
===============================================================
====
--- SL/CA.pm (revision 3369)
+++ SL/CA.pm (working copy)
@@ -76,11 +76,11 @@

c.pos_eur,
c.valid_from,
c.datevautomatik,

• comma(tk.startdate) AS startdate,
• comma(tk.taxkey_id) AS taxkey,

+ comma(tk.startdate::text) AS startdate,
+ comma(tk.taxkey_id::text) AS taxkey,

comma(tx.taxdescription

to_char (tx.rate, '99V99' )

'%') AS taxdescription,

• comma(tx.taxnumber) AS taxaccount,
• comma(tk.pos_ustva) AS tk_ustva,

+ comma(tx.taxnumber::text) AS taxaccount,
+ comma(tk.pos_ustva::text) AS tk_ustva,

( SELECT accno
FROM chart c2
WHERE c2.id = c.id

---

Referenz: Vollständige Fehlermeldung:

---

SELECT
c.accno,
c.id,
c.description,
c.charttype,
c.category,
c.link,
c.pos_bwa,
c.pos_bilanz,
c.pos_eur,
c.valid_from,
c.datevautomatik,
comma(tk.startdate) AS startdate,
comma(tk.taxkey_id) AS taxkey,

comma(tx.taxdescription

to_char (tx.rate, '99V99' )

'%') AS taxdescription,

comma(tx.taxnumber) AS taxaccount,
comma(tk.pos_ustva) AS tk_ustva,
( SELECT accno
FROM chart c2
WHERE c2.id = c.id
) AS new_account
FROM chart c
LEFT JOIN taxkeys tk ON (c.id = tk.chart_id)
LEFT JOIN tax tx ON (tk.tax_id = tx.id)
WHERE 1=1

GROUP BY c.accno, c.id, c.description, c.charttype, c.gifi_accno,
c.category, c.link, c.pos_bwa, c.pos_bilanz, c.pos_eur, c.valid_from,
c.datevautomatik
ORDER BY c.accno

ERROR: function comma(date) does not exist
LINE 14: comma(tk.startdate) AS startdate,

---

Axel

Danke, entsprechend behoben.