In my continuing custom enrolment work (using 3 tables to generate our enrolment) I'm running into a postgres problem. Everything works fine when I use a local mysql database. However our data usually resides on a remote postgres database. I found I wasn't getting any results when querying the external postgres database -- no connection errors, just no results from select!
So I installed postgres on the moodle box to see if it an issue with the postgres server. I am having the same results with the local postgres database! It appears to connect but my selects return nothing.
The moodle server is debian with PHP Version 4.3.10-15.
Is anyone using a postgres database for db enrolments?