using postgresql
Hello,
I'm doing some tests with Galaxia on postgresql, my only problem is with mixed case column names (eg: pId) in SQL statements.
I solved this issue using backquotes in all queries as reccomended in:
http://tikiwiki.org/tiki-index.php?page=DbAbstractionDev
eg: select count(*) from ".GALAXIA_TABLE_PREFIX."activities where `pId`=$pId
NB: I could not use unquoted table creation scripts as some of the column names are postgres reserved keywords and must be quoted
hope this saves some time to someone
bye