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.
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.
Quick-Help
The quick-help below shows you how to construct advanced search queries on the Knowledge Base.
| Advanced Search Quick-help: |
| Symbol | Functionality | Example |
| & | AND | windows & odbc |
| | | OR | windows | odbc |
| "..." | Exact phrase | "cover flow" |
| _ | Single-character wildcard | linu_ |
| % | Multi-character wildcard | activat% |
| /(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
