'bridging cultures & improving education through better dictionaries & terminology'
Version 2020 released for TLex, tlTerm, tlCorpus, tlDatabase (32/64-bit Windows & macOS. What's New) All users may upgrade.
Watch tlTerm easily load millions of terms »
macOS Catalina versions available »

Knowledge Base : TshwaneDJe Software

The TshwaneDJe Knowledge Base contains a small collection of technical articles with information on specific issues to assist you with the configuration or use of our software. You can search through the Knowledge Base using the search box below, or by browsing the list of articles. We will continually be adding new articles over time. If you don't find a solution here, please also try the FAQ or other support resources.

Search for:

ODBC and PostgreSQL Error "CAST(timeofday() AS timestamp)

Possible Solution(s)

Go to e.g. c:\Program Files\PostgreSQL\9.3\share\timezonesets

Edit the file "Default" in a text editor, adding your timezone (as in the 'timezone') field in postgresql.conf). So e.g. for South Africa, open "Africa.txt" and copy/paste the "CAT" timezone definition into the "Default" file. (You might also need to edit the 'timezone' field in postgresql.conf, e.g. set it to "Africa/Harare" as one of the CAT timezones.)

Restart the PostgreSQL server service (or 'reload configuration')

If it still doesn't work, check both the PostgreSQL logs for clues, and if on Windows, check the Windows "Event logs", as some PostgreSQL errors log there.

« Back to List of Knowledge Base Articles



The quick-help below shows you how to construct advanced search queries on the Knowledge Base.

Advanced Search Quick-help:
&ANDwindows & odbc
|ORwindows | odbc
"..."Exact phrase"cover flow"
_Single-character wildcardlinu_
%Multi-character wildcardactivat%
/(1-9)Within x words of one another, given order"windows odbc"/8
@(1-9)Within x words of one another, any order"windows odbc"@8
#XOR (find one or the other, but not both)mac # windows
^None of ...^mac

The Knowledge Base was created with TLex, and is published online and updated using the TLex Online Publishing System