Are there many people out there running PostgreSQL? I'm curious what
your experience of Habari on PostgreSQL is.

I'm having a play around with PostgreSQL 8.4. Things I've observed:
1. Reproduced https://trac.habariproject.org/habari/ticket/1220.
2. An "Indeterminate datatype" error on the dashboard.
3. I don't think the index changes in r4225 worked, though I haven't
got my head around querying indices yet.

2 is caused by DB::get_results('SELECT id as token_id, ? as
access_mask FROM {tokens}', array($bitmask->full) );. PostgreSQL
doesn't know the data type of the bitmask, and this can be solved by
doing 0+?. I don't know if that would have any effect on other RDBMs,
or if there's a better fix.

So, who's out there, what version of PostgreSQL are you running, and
how is it going?

-- 
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at http://groups.google.com/group/habari-dev

Reply via email to