Re: [Rawt-devel] Postgresql 8.3.6 problem

[Harald H. <bo...@da...>]

 > Hi!

Hi Andreas,

 > But there seems to be an incompatibility with Postgresql 8.3.6:
 > when selecting "statistics" I get this error:
 > Warning: pg_query() [function.pg-query]: Query failed: FEHLER:
 > Funktion pg_catalog.substring(timestamp with time zone, integer,
 > integer) existiert nicht LINE 1: ...ints_h from
 > t_act_contest_60_1236000075_117 where substring
 > ... ^ HINT: Keine Funktion stimmt mit dem angegebenen Namen und den
 > Argumenttypen überein. Sie müssen möglicherweise ausdrückliche
 > Typumwandlungen hinzufügen. in /var/www/functions/psqlif.php on
 > line 64
 > In module dbif, function query_arr: An error occured:
 >  	UTC 	Pts 	% 	Pts/h 	%/h 	QSOs 	% 	QSOs/h 	> %/h 	Pts/QSO 	Pts/QSO (h)

 > I don't think this is an error with the debian Postgresql package. It
 > more seems like the 8.3.x version handles the pg_catalog.substring
 > function more strict. You probably have to use to_char function first.

Yes, you're right, I just checked the documentation 
(http://www.postgresql.org/docs/8.3/interactive/functions-string.html):
=============/snip/=================================================
Before PostgreSQL 8.3, these functions would silently accept values of 
several non-string data types as well, due to the presence of implicit 
coercions from those data types to text
================/snap/===============================================

So, this is why we get a problem here...
It should be no problem to fix it, but I have to update my develop 
database first (running 8.2 for DEV and 8.1 on the demo system, so never 
spotted this bug).
In the meantime, would it be an option to use 8.2? It's no problem to 
install 8.2 and 8.3 on the same system (I'm also running both versions 
on my workstation here).

 > Another thing is ADIF? RAWT links to /contest/adif_auswertung.php but
 > this file doesn't exist: neither in CVS nor in the download tar
 > package.

Yes, you're right: That was a planned, but never realized feature, since 
we only used CAB and no ADIF. But since it's requested, I think it's 
time to realize it now, :-).

 > Thank you!

Thanks, it's nice that RAWT is still alive!

 > Regards,
 >  Andreas Weller, DF1PAW

Regards and 73,

Harald